Are you looking at the Access 2007 templates? Contacts or Assets templates for example? I'm pretty sure they way they do it is to create a split form with the individual detail size set to 0.00" height. I haven't actually tried making one myself, but it drove me crazy until I figured out what...
I have been creating a personal database (access 2002) to keep help keep track of all the stupid things I own. I was wondering what people think about encoding data to help reduce database size. I know that for my small database it probably doesnt matter, but it it worth it to enocde colors...
Thank you for the reply. I believe what you are suggesting will work, but I would prefer to have a semi-random distribution of numbers. I would like to remove *any* correspondence between the number and the items.
Will seeding the generator on database load be sufficient?
I was hoping to run this by you guys to see if I'm doing anything horribly wrong. I have done a number of searches related to custom Autonumbers and I think this is okay but any suggestions/confirmations would be greatly appreciated.
I want to create a random Primary Key that will also be used...