Hi,
The program works by looking up the data online. There is no local table of addresses!
To open the code, hold down shift while opening the database.
Rich
Another option is to hold down the Shift Key while opening the database.
This bypasses the startup form, re-instates the nav bar and all context menus (If you had disabled them).
Hi,
I haven't tested this, but I think using NZ in the query instead of the Or statements might work.
WHERE (([Satellite Launches].Launcher=Nz([Forms]![QBF_Form_F]![Launcher] ,"") AND ....
Hi,
In your do ... loop you are adding data to different fields, but using the same excel cell (A & r).
This will make every field in the table the same.
Hi,
You can filter on as many fields as you like. Just use 'AND' after each item
i.e.
With Me.frmsub.Form
.Filter = "[Franchise] = 'Abarth' AND [YourField] = '" & [YourTextBox] & "'"
.FilterOn = True
End With
Hope this helps.
Hi,
A quick idea for you would be to have a combobox which looks up the UPC from your table. Then have the Record Source for the form which filters the results based on the combobox
Then all you need to do is requery the form after the combo changes.
Hope this helps.