ACCESS 2000 has "Conditional Formatting" which allows formatting in ANY form view, including Datasheets!
Just highlight the control you want to change, then FORMAT, CONDITIONAL FORMATTING... you can set the conditions and what type of formatting you want.
Even better, you can then...
Solved my own problem!
The issue that there are MISSING refrences in the TOOL/REFERENCES list. Problem is that once you run the form and get the error, the REFERENCES is grayed out of the TOOLS menu.
So close and reopen the form in DESIGN MODE and then look at your code again... then...
I've run into the same issue. Furthermore, after getting the error "Compile error: can't find project or library" when running a simple VB statement: [Cdate]=date, I've found that I can't even check my REFERENCES menu because it's grayed out. The only way to get it back it to REPAIR...
Programming the scanner works and was very easy to do with the book that came with the scanner. I scanned in a suffix (from the book), which was the ASCII code to TAB (7009). <br>Thanks.
Does anyone know how to set up a field (in a form) to automatically accept a bar code (exactly 40 characters)? I have no problem scanning in the first one, but I need it to auto-enter so I can scan muliple items without having to touch the keyboard.
Jim... one quick follow up question. Since I am new to SQL, could you explain how the quotations work in the statement <br><b>docmd.runsql "UPDATE Inventory set DateOut = date() where UPCcode = """ & variable & """"<br></b>?<br><br>
In a form, I'm trying to scan in many barcodes in an UNBOUND text box and would like to have the barcodes show up in a subform. Any ideas?
Thanks Jim,<br><br>You suggestion works great, however, I still am trying to enter the scans <b><i>without</b></i> having to hit ENTER and answer OK to the UPDATE confirmation. Any ideas? (I have a SYMBOL scanner that is on a y-adapter with the keyboard via the...
Can anyone help with this?<br><br>I have a table of UPC codes that have been scanned (inbound products). <br> <br>Table: Inventory<br>Fields: <b>[UPCcode],[DateIn],[DateOut]</b><br><br>I would like to scan the product again when it is shipped out and add a date (which uould be an update to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.