Search results

Thanks for the input. I avoided a combo because the Products table has around 2000 records and they often use a barcode scanner, it's just the odd occassion where they have forgot to register the product in the table that the error used to occur and annoy them.

Hi there, thanks for this, I have tested it and indeed it works. Could you give me a quick overview of the difference and benefts for future reference?

Thanks for that Bob, that would work too I seem to be having more success on the After_Update for some strange reason and after 3 hours of trying to figure it out I think it is time for a coffee :)

Found a solution. Who said talking to yourself isn't a good thing? Private Sub Product_code_AfterUpdate() Dim code_search As Variant code_search = DLookup("[Product_code]", "Products", "[Product_code] = " _ & Me.Product_code) If IsNull(code_search) Then MsgBox "Enter valid product...

Tried this but no joy: Private Sub Product_code_AfterUpdate() Dim search As Variant search = DLookup("[Product_code]", "Products", "[Product_code] = " _ & Me.Product_code) If search < 0 Then MsgBox "Enter valid product code" Me.Undo Else 'Transfers the price of the product to...

I need to do this: Private Sub Product_code_BeforeUpdate(Cancel As Integer) IF product_code exists in products table THEN 'Transfers the price of the product to the OrderLine table Me.txtPrice = Me.ProductsPrice ELSE MsgBox "Enter valid product code" Me.Undo End Sub Can anyone hep me with the...

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 Pat, thanks for the reply. As this is new territory for me could you recommend... 1 - method for exporting the tables 2 - how to update them on the externally hosted web server, ftp? 3 - what software would you use to create the asp pages? I haven't web developed for a while.

It's hard to advise without seeing the database design but the way I see you doing this is... Having a form based on the order. Subform1 - based on a query to find all the plots for that order. Subform2 - based on a query to find all the products for that plot and order.

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...

Solved... Used Allen Brown's code (http://allenbrowne.com/AppPrintMgt.html) to set the default printer for that report.

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...

Thanks for your input, I know I can network another computer and share the DB however I was wondering if there was a better solution as although PCs are cheap I didn't really want to have to use the space in the shop to connect another up.

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...

Cheers guys. The issue with the above code Dale is that there is the odd occasion where the Qty will need to be more than 1. I have used your suggestions and will instruct the user that they have to press enter to fire the AfterUpdate event to go to the next product. This will have to do for...

If I call the AfterUpdate event: Call Qty_AfterUpdate I get the same error as putting the code on GotFocus. Is there a way I can trick access into thinking the user has selected a value for the Qty combobox?

Cheers, it works on the After Update event. Is there anything I can do on the set focus event so that after it sets the value to 1 it triggers the After Update event?

I can use the tab key to go to a new record so I tried vbTab however that didn't work either :(

Should have said that the subform is based on a query, I guess that is why I have the error coming up stating that "you cannot go to the specified record". Note to self: need to research moving to next record when form based on a query.

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...