Help with Forms!

#1 July 14th, 2004, 02:00 PM

I would like to know how to insert a log number in every
record of an Access form that I have created.

Each log number would sequentially increase by 1 for each
record. For example, record 1 would be ABC0001, record 2
would be ABC0002, record 3 would be ABC0003, etc.

Can anyone help?

#2 July 14th, 2004, 05:33 PM

Using the pattern you have given, set the default value of the control that
shows the log number to

="ABC" & Format(DMax("CLng(Right([FieldName],4))", "[TableName]") + 1,
"0000")

--
Wayne Morgan
Microsoft Access MVP

"Beth" wrote in message
...
I would like to know how to insert a log number in every
record of an Access form that I have created.

Each log number would sequentially increase by 1 for each
record. For example, record 1 would be ABC0001, record 2
would be ABC0002, record 3 would be ABC0003, etc.

Can anyone help?

#3 July 14th, 2004, 05:35 PM

ps,

Will this be a multi-user database? If so, this will need to be moved from
the default value.

--
Wayne Morgan
Microsoft Access MVP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
datasheet forms open in form mode from the Switchboard	Paul James	Using Forms	5	July 13th, 2004 06:51 AM
Data entry forms and/or subforms	Hugh Crean	Using Forms	2	July 8th, 2004 05:56 PM
Word Forms?	CEVisker	New Users	4	June 21st, 2004 01:25 AM
Forms Check Box not working	DLLower	General Discussion	2	June 17th, 2004 09:34 PM
matching multiple forms on open to form records	EdwardA	Using Forms	0	June 10th, 2004 06:38 PM