Search results

Hi all, I have a simple Ordering DB with tables: Products - Order-line (one-many) I have an Order form with an order-line subform based on a query which pulls out a description from Products and displays on the form. When a user scans a product into the Order-line and the Product isn't in the...

Hi all, Looking for some advice. I would like to allow my customers to access my internal database (MS Access .mdb) to see what orders they have placed. I need a web form where they can enter their ID and this would run a query (data from 2 tables) and show them another form which would show...

Hi all, Does anyone know how to fix the height and width of a report. I would like the report to stay landscape, 100mm wide, 62mm high. This is required by a label printer. The issue is that a A4 laser printer has to be set as default (for other software) so when the report is launched the...

Hi, I have created a simple Till App for my friend's shop. He now wants to run 2 tills. Any suggestions how to do this? I can connect 2 monitors to the back of the existing PC and extend the desktop, does anyone foresee an issue with this? The DB is currently in accdb format. It would be a...

I have a subform that I use to scan in products using a barcode reader, when the item scans it moves to the quantity (Qty) field where I have this code: Private Sub Qty_GotFocus() Qty.Value = 1 DoCmd.GoToRecord , , acNewRec txtOrderNo.SetFocus End Sub I am simply trying to set...

Hi all, I have a USB cash drawer attached to a simple EPOS DB I created, it has a built in Serial converter and is installed on COM5. Does anyone know how to fire/open this in Access? I have researched and researched but cannot find a solution. I believe it needs an escape command sending to...