If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Accessing Table with VBA code
Hi,
I am currently using the following code in my form: Private Sub Form_Load() Set dbs = CurrentDb Set doc = dbs.Containers("Databases")!UserDefined Me.PreSearchStores = doc.Properties!PRS Me.PostSearchStores = doc.Properties!POS .. .. .. I am trying to write to a table. Some values are entered by the user and others are internal and are being written using the code above. The problem is, the code above always writes one record down from the rest of the data. The CurrentRecord is 1 but it still writes on line down. Can someone please help me fix this problem? Thanks a lot. Chin Bhat. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Code to change a table definition | Tim | General Discussion | 3 | June 30th, 2004 02:07 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
Adding selected data (using code atached to cmd button from a form) to a table | Chris | Using Forms | 0 | May 26th, 2004 12:12 PM |