Jan 15 2005, 10:03 AM
How do you use the index to find code to increment a number??
Jan 15 2005, 10:08 AM
I assume you want to add on 1 for each record?
=Dmax("YourFakeIDfieldInTable","Yourtablename") + 1
Jan 15 2005, 10:13 AM
Yes, thank you.
Is there a book that can help a person understand how to create code??
Jan 15 2005, 10:28 AM
I very often have to refer to a VBA book for both help and often just clarity on a segment of code.
The book I have to hand is:
Beginning Access 97 VBA Programming
By Robert Smith & David Sussman
PlusRecommended Reading Access 97
Jan 15 2005, 11:00 AM
thanks, will surely give it a try
Jan 15 2005, 11:30 AM
do i put the code in the table??
Jan 15 2005, 11:45 AM
What is this incremented number used for ???
How many records do you antisipate this table to contain over the lifetime of the application ???
Is this a multiuser application where the incremental number must be applied as the record is created ???
Jan 15 2005, 12:13 PM
1. log number
2. thousands, but may purge once a year
Jan 15 2005, 12:51 PM
Here is the basic answer you need that I made at another post that in related to your problem ...Basic Answer to Question
Jan 15 2005, 12:57 PM
thanks I will give it a try
Jan 15 2005, 01:26 PM
can you have two event procedure for ex. "on Current"?
I tried the code but the last number stays as a 1, and the middle number changes but only up to nine. the 00 in front stay the same
do I need to add something??
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here