Attention MS Access Aces 1

[macduff]

hello,
I need some help with auto numbering. Is there a way to change the format from 1,2,3,4,5 etc.....to 000001,000002,000003,000004,000005 etc.....

I tried messing with some of the property boxes, but had no luck. Is a character that I need to add? like ie....' * # %

See attached, and thank you!

Colin Fitzpatrick (aka Macduff)
Mechanical Designer
Solidworks 2010 SP 5.0
Dell T5500 Windows 7 Pro (64-bit)
Xeon CPU 2.53 GHz 6.00 GB of RAM
nVida Quadro 4000 2 GB
3D Connexion-SpaceExplorer

 

[CorBlimeyLimey]

You may have better luck asking at Tek-Tips

http://www.tek-tips.com/threadforum.cfm?lev3=27

 

[macduff]

thanks cbl. same username and password as eng-tips?


Colin Fitzpatrick (aka Macduff)
Mechanical Designer
Solidworks 2010 SP 5.0
Dell T5500 Windows 7 Pro (64-bit)
Xeon CPU 2.53 GHz 6.00 GB of RAM
nVida Quadro 4000 2 GB
3D Connexion-SpaceExplorer

 

[EEnd]

Going by the following:

http://office.microsoft.com/en-us/a...tom-formatting-HA010334645.aspx#_Toc296346325

You might get the desired result by putting 000000 in the Format property that you highlighted.

Eric

 

[CorBlimeyLimey]

same username and password as eng-tips?

No. You can use the same if you want, but you have to register separately. E-T & T-T use separate member databases.

 

[macduff]

Eric,
Thanks so much! It's very simple to do.


Colin Fitzpatrick (aka Macduff)
Mechanical Designer
Solidworks 2010 SP 5.0
Dell T5500 Windows 7 Pro (64-bit)
Xeon CPU 2.53 GHz 6.00 GB of RAM
nVida Quadro 4000 2 GB
3D Connexion-SpaceExplorer