Search results

OK everyone...got it figured out. All I needed to do for the validation rule for the Serial Number field was to write the following validation: NOT Like "######". So now if the user accidentally scans the Asset Tag Number in the scan is rejected and a error message now appears.

Hope this thread is posted in the right category....I need to get an instructional text for Access 2010....does anyone have any recommendations for this database noob?.......hummm...maybe this should have been posted under "Debates?" LOL!

Does anyone here play World of Tanks? If so: What are your favorite tiers? What are your favorite tanks? Do you have a favorite country? What do you think of the Domination battle?

Should it be legal for women to go topless if they so choose?

Thank you....but....where do I insert the program text?

Thank you for your replies so far. 1) As noted the serial number will always be alphanumeric. Two examples of what the serial number will look like are: 1) 4K5VM22, or 2) C02N60WEF2GC. The first one is 7 digits; whereas, the second one is 12. 2) Yes, although I did not mention it, I will be...

Working on building a table in Access that will contain only two fields: 1) Asset Tag Number and 2) Serial Number. The “Asset Tag Number” is always a six- (6) digit number; whereas, the “Serial Number” is always alphanumeric. Both fields will be inputted via a barcode scanner. Two...

Thanks! Actually, the plan is for me to set up my own business doing custom design and restoration out of my shop. I can ship anywhere. But for right now...need to work on building an Access database and getting a question answered....LOL!

Greetings everyone! My name is Stan Pearse. I work at San Francisco State University and am a very green Access user as I only use it from time to time; however, I am seeing the need to use it more in my function here at the University. I am a PeopleSoft Purchasing and Asset Management super...