Search results

Ah yes Gasman - I see I've left out some of the code: stConNum = Me.lstSendMani.Column(1, varItem) stWhere = "[Con_Num] = " & stConNum Doh!

Thanks DB - I did try taking out the requery part, but it still did the same. It looked like it got stuck when I opened the form to edit it - I'm guessing because the form with the list box lost focus and refreshed when it go the focus back - maybe? Good suggestion on the update query, I will...

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

Thanks all for your suggestions - after spending a bit of time messing about with it and googling it, it turns out that I need to turn off the reference library for calendar control as it's no longer valid in 2016! What that has to do with that bit of coding (which has no date reference in it)...

Thanks to all for you're input. I've gone back into it and made some changes and noticed that when I click on the (linked) table, it will not allow me to make changes to the field 'MIL_Lic' and displays the same error message - but if I open the actual table itself, it can be changed with no...

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