Recent content by Lizba

Thanks for your suggestions. I eventually solved the problem another way, I created a table called "Dates", where I pasted a list of dates from 2007 to 2035 (by then I should be retired!!) with an autonumber ID. So now I just use the ID to open the correct form irrespective of whatever date...

Hi Can someone help me with a date problem. We have recently upgraded to 2007. In 2003, all our dates were yyyy/mm/dd. In 2007, the regional settings for South Africa, is now dd/mm/yyyy . All the forms in the program are using this format. The problem now is: On the booking schedule, if...

Thanks guys, that helps a lot. Cheers to the comment on idiot proofing :D

I have two questions on the same form. The form (SaleMainFrm) has a subform (SalesSub). The records of the subform are entered via a Barcode scanner. I am trying to prevent the user from creating errors by entering things in the wrong places etc. So far, the error trapping that I have done...

The drawer is opening properly, it is just the customer display that is not working now.

Hi There I need to send commands to both the Com1 (Customer/Pole display) and LTP1 (Printer and Cash drawer). I first used it for the Com1 port and it worked beautifully. Now I added the command for the Ltp1 port and this works but now the pole display doesn't work. ie: Open "COM1" For Output...

I have written a small POS sytem in Access 2007. We have a pole display attached - Bixolon BCD-1000 at COM1. I would like to program it so that the product sold "[ProductDescription]" appears on the display at line 1 and the price "[LineTotal]" appears at Line 2 everytime a product is scanned. I...

Unfortunately its not an assignment! Nor am I at college! Its a genuine query for our company database.

Hi there I have a form where someone books a room (Room 1) for x number of nights - from [DateIn] = 2010/04/28 to [DateOut] = 2010/05/02. I want to load this info to a table similar to this: Room Date Customer Room1 2010/04/28 Mr Jones Room1 2010/04/29 Mr Jones Room1 2010/04/30 Mr Jones Room1...