Search results

Hi all, I'm a bit stumped on a problem - I have an access routine that works through a list box and opens up a form for each entry to update the record. Trouble is that once the form has been opened and edited, the list box then resets, so I can only update one at a time - here's the code...

Hi all, We've just upgraded to Office 365 and I've had a puzzling error come up in one of my forms. There's a part of Form_Current routine that display an error only when a the form is first opened: Private Sub Form_Current() If Me.NewRecord = False Then Me.cmbCustomer.SetFocus...

Hiya - been working on (simple) databases for about 10 years now - no training, just picked up pieces here and there. Deffo don't understand SQL!

I have a main table using [Con_Num] as the primary key (using autonumber) with a sub table linked to the table using [Con_Num]. In my sub table I have two fields : [LNum] & [LText] I'm trying to design validation form using a query, from the main table with a join to the sub table. The bit I'm...

I'm trying to work out how to print a number of labels depending on data in my table. I have a report set up using a select query, but how do I send data through VBA to the report. I have a table "tblCartons" which has multiple records linked to my table "tblShipLists" by the primary key...

I'm a bit stuck on a problem with autonumber - i have two tables set up, one for a report and another which is a subform for actions on that report. The report has an autonumber set, but i want to set an autonumber for the actions, but always starting at 1 on each new report. i.e. Report 1 -...