Search results

I think the problem is that the field 'date' is a reserved word in SQL and cannot be used as a field name. Cheers, SteveA

The SQL statement has two arrays. The first contains all the fields to be updated, and the second holds all the new values for each field. Try the following. Hopefully it will work: ss = "INSERT INTO [resorts](resortname, transfercost) VALUES (txt_resort_name, txt_trans_cost);" Cheers, SteveA

To identify all the options you have selected in a multi-select listbox you can do the following: for i = 0 to Me!Listbox.Listcount - 1 if Me!Listbox.Selected(i) then ... 'Enter code here end if next i Just replace Listbox with the name of your listbox. I hope this is what...

If your subform is linked to the main form by the CountryID, you can add new records to the Resort table by entering data straight into the subform. Access will add the record to the resorts table and set the ResortCountryID to the CountryID on your main form.

If you are building your query using VBA, you are able to loop through the items in a listbox and check the Selected property. ie for i = 0 to Me!Listbox.Listcount -1 if Me!Listbox.Selected(i) then ... end if next i If you aren't using VBA, unfortunately I don't know of any way...

If the source of your dropdown box is a query, set the 'Unique Values' to 'Yes' in the Properties of the actual query. This will ensure that duplicated entries are removed. Cheers, SteveA