Search results

Solved at another forum: http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1617437

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

That works great. Thanks very much for the quick reply.

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

Ok, I found Lister's code: http://www.access-programmers.co.uk/forums/showthread.php?t=136282 and have adapted it to print a msgbox with productname (name of query).prodid=3 OR etc if more than one are selected. How can I now get this to insert each selection in its own row in the shopping...

Aah, I understand. So for each selected product, you put a new row in the shopping_basket table, but each with the same orderid. I've been looking around for some ideas on how to do this, and it looks like an arrays the way to go, but I'm not sure how to implement this. Any ideas?

Ok, here's the table schema: products prodid (PK) name description price shopping_basket basketid (PK) custid prodid The listbox on the form runs from a query that gets just the id and name of each product from the product table. What I want is for the user to select one or more products...

I'm not sure it's a normalisation problem, but I had an idea about this today but am unsure how to code it. I thought the best thing to do would be when the submit button is clicked to run a loop that gets each selected value and puts them together in a string, this string is then used in an...

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