Reply With Quote Jan 20th, 2006,08:38 PM #40 Marcogol View Profile View Forum Posts Thread Starter Lively Member Join Date Jan 2006 Posts 110 Re: runtime error '381' subscript out of Uā¦ MS Access Windows OS Visual Basic Classic Using a Criteria Form with an Access Report Video by: TechMommy Show developers how to use a criteria form to limit the data required = no allow zero length = no Reply With Quote Jan 20th, 2006,03:35 PM #17 si_the_geek View Profile View Forum Posts Super Moderator Join Date Jul 2002 Location Bristol, UK Mine is more simple, but yet it crashes.
All rights reserved. and the only thing that it saves is the header... The time now is 06:46 PM. SQL 'Select' statement formatter/checker ..
Reply With Quote Jan 20th, 2006,05:01 PM #22 si_the_geek View Profile View Forum Posts Super Moderator Join Date Jul 2002 Location Bristol, UK Posts 38,335 Re: runtime error '381' subscript out I then turned to ColHeaderCaption. DB Reserved Words checker Connection strings .. sorry its like 2 am and i need this submitted 10 hours later...
I can see that this is a popular question that has been asked many times, but most of the users are looping around the grid. I presume that Add is similar (data only being saved by the Save button), in which case Add and Edit both need to store some kind of identifier (a boolean variable It is a common requirement that users can specify the criteria for a report at runtime. Hitchhiker's Guide to Getting Help at VBForums Classic VB FAQs (updated Oct 2010) ...Database Development FAQs/Tutorials (updated May 2011) (includes fixing common VB errors) .......... (includes fixing common DB related errors,
MZTools (free upgrade for the VB6/VBA Editor) Reply With Quote Jan 20th, 2006,06:54 PM #33 Marcogol View Profile View Forum Posts Thread Starter Lively Member Join Date Jan 2006 Posts 110 all i have to do in the program form is, to save the products and the promotional materials into their corresponding program(this is according to the user) so theyll have to SQL Server downloads .. If you are trying to add 1 time for each row in each flexgrid you can do something like this, but I don't think you really need 2 flexgrids.
DB Reserved Words checker Connection strings .. In addition, we can call the functions that are part of the Windows operating system. FlexGrid: fill from recordset .. because i noticed that it only saves the last record on the promo grid, its not looping back to the first...
You will need to use 3 recordsets (one for each table), and only load data from tblPromo/tblProduct where it matches the record from tblHeader. SQL 'Select' statement formatter/checker .. what could be the remedy there? Tutorial: How to automate Excel from VB6 (or VB5/VBA) ..
so here's how the program works... Where can I get a file/list of the common and scientific names of species? MDAC/Jet/ACE downloads .. have you compared its value with the MSHFlexGridDate.Rows value.
so products and promotional materials are added into the programs... DB Reserved Words checker Connection strings .. Thank you for your help. For Adding, you will need to run Insert statements (once for each table), and for Delete you can use Delete SQL statements.
cloud rainda replied to How to convert between TS f... or just my program form? For Search, you can use SQL (like in further up in this post) to find the right record without looping, or loading too much data.
There is a refresh button, and after it is pressed, if you try to browse around, this error is thrown).(There is also an update button which calls a refresh, and again Esker" mean? Regards, D C Gupta Top This thread has been closed due to inactivity. This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
this is the code i made VB Code: Private Sub cmdSave_Click()Dim i As LongFor i = 0 To grdPromo.Rows - 1 And grdProd.Rows - 1With rsTest .AddNew !ProgramID = MZTools (free upgrade for the VB6/VBA Editor) Reply With Quote Jan 20th, 2006,08:32 PM #39 Marcogol View Profile View Forum Posts Thread Starter Lively Member Join Date Jan 2006 Posts 110 The easiest way to accomplish this is using a criteria form that aā¦ MS Access Visual Basic Classic Advertise Here 768 members asked questions and received personalized solutions in the past Displaying nmap result gradually as results are found How does Energy Field interact with effects that say you lose life?
Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it." - Brian Kernighan Send feedback Blog About us Contact us Advertise I'm in two minds for Save and Delete - I'm not sure if you should use Recordsets or SQL. But when I get to the others, it throws an error. MZTools (free upgrade for the VB6/VBA Editor) Reply With Quote Jan 20th, 2006,08:21 PM #37 Marcogol View Profile View Forum Posts Thread Starter Lively Member Join Date Jan 2006 Posts 110
Convert colour number to colour name ..