Search results

I have a report running on two queries. Each query has a where clause with the same parameter: WHERE bookings.bookingid=[latestbooking] What I've already done is to code when a user presses the confirm button, to write the most recent booking id to a variable. What I want is this variable to...

I'm running a loop on a listbox to get each selected value, I want to then insert these into separate rows in a table. The way I thought to do this was to put an append query into the loop to insert each time a selected value is found. Here is the code: On Error GoTo ErrHandler 'Set...

Solved: Insert a multiple selection into a table This is probably in the wrong forum, but I'm not sure what area the answer would cover, either queries, macros, VBA etc. I have a form, on which is a listbox with multiple selection enabled getting it's data from a query. What I want to do is...