Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MS Acess - CTRL F box - macro?
Name: cl0306 Date: April 11, 2006 at 14:28:03 Pacific OS: winxp CPU/Ram: XP2400/512MB
Comment:
Hi,
I have a simple ms access application that allows you to scan barcodes in to a form which stores them in the database. The barcodes are 6 digits in length e.g. 555666 but my handheld scanner always adds a leading zero - e.g. 0555666. You can get round this problem by changing the database design for the field where this is stored from text to number format.
However, when it comes to quickly doing a search for a code - CTRL + F- the scanner still puts the code into the search box with the leading zero. Is there a good way of stopping this? Would this be something I could code via a macro?
(the long-term solution has to be to find the manual and scan a system code that removes the leading zero)
Summary: Hi, I am currently working with a third party vendor. I want to build a databse which can be updated by the vendor at his premises. Can I see the forms/querries at my system in real time? Also can mor...
Summary: I have 2 Access tables, t1 and t2, they are the same structure but located in different databases. How can I merge these 2 tables and put it back to the databases. eg. t1 rec1 rec2 rec3 rec10 t2 re...
Summary: How to create a function in MS Access?Pls help!! ---------------------- Hello, I need create a function in MS access 2003 which run a ***.bat file in my hard drive d:\application\. I have a old versi...
know the name of the data...
