Search results

I only mention a touch screen to explain how the buttons will be used. I do not want the users to have to use a keyboard. When I add the touch screen monitor the users will no have to use a keyboard. I want a DB that enters data from buttons. I do not need a kiosk.

I am using 2010. I uploaded what I have written so far and it works. Just open the form frmTicket. If you click on my 2 buttons it adds tickets for those customers. So that part is good. I want to add buttons to enter money and buttons for the food items.

I am trying to write a DB that does 90% of data entry by touch screen and buttons. It will be a simple Point of Sale for a small cafe. keep track of money taken give change back, if it is a cash transaction. If it is a charge transaction save to be added up and paid later. Some customers...

When you preface a field with "Me.", that means you are referring to a control on the same form that your code is executing on.

I found the original code in this thread Command button to input data in a table John Big Booty gave the good info

My main form is frmTicket My subform on frmTicket is frmTicketDetailsSubform my subform has a field named FoodID I want to put a 1 in that field when I click the button

This makes no sense to me. Sorry.

I have a button with this code attached to the on click event. Like I said it works on the frmTicket main form. I have added another button to the main form that I want to put a 1 in the FoodID field of the subform. It is not always 1. Just when I push the button I added to make it 1. Thanks.

I have clicked on that link to the examples and I cannot find what I need. I tried and failed. I provided the form names I was hopping someone would update my code with the correct syntax.

I am using buttons to add data. I used this code. It works perfectly on the main form. If Me.NewRecord = False Then DoCmd.GoToRecord acDataForm, "frmTicket", acNewRec Me.CustomerID = 1 End If I need to add another button on the main form that adds data to the...