Search results

I am trying to use an excel workbook in my access 2013 database. I like to use linked tables because I can update the excel workbook and the new data is available when I go into access. The problem is an address field in excel only imports the first line of a 3 line address field. I have...

Hi everyone, I have this code Dim ID As Long ID = QuoteID DoCmd.GoToRecord , , acNewRec location = DLookup("location", "tblSeller", "QuoteID=" & ID) UserFK = DLookup("UserFK", "tblSeller", "QuoteID=" & ID) cmdClose.SetFocus works really well. It opens a new record...

I have done this before and I cannot remember what I did. I used a DLOOKUP and grabbed the number in previous record field InvNo and added 1 to it. So if last record InvNo was 14750 then in new record InvNo was defaulted to 14751 I can use this code to copy forward text fields. I thought I...

I have a main form frmTicket and a subform on the above form named frmTicketDetails I am trying to setProperty in the subform on control FoodID Please correct my mistakes none of these work Form.frmTicket.frmTicketDetails.Form.FoodID Form!frmTicket!frmTicketDetails.form.FoodID...

Hi, I created a macro on a subform that does setProperty value to Bob in the helper field. Works for first record in subform. I only have 3 helpers Bob, Susan and Sam so I created 3 macros for each value. So I created 3 macros they work fine. The problem is how do I make them move to new...

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

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