Search results

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

Have you tried importing the query directly to Excel instead of through code? Data - External Data - Access ?

Hi Evilbungle, Have you tried opening the table and filtering the results to see how many records the query should return? 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).

you can try using an iif statement.

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 would need to use an if statement. if StartTime > Finishtime then elapsedtime=elapsedtime+24 or something similar.

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.

Just reading back through, in your table you have 8 fields. What are all the field names?

So effectively the query will search for each instance of any ingredient and then total it up. Kind of like a shopping list?

You can use either a form of query. Are you trying to get the total of each column, or the sum of one or more fields in each row?

Could you not modify the report before the export process?

after the open form command, add a gotorecord,,aclast

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.

Finally got it working again. Full uninstall and re-install thanks MS!

Already tried that. Nearly finished re-install now anyway. Fingers crossed this fixes the bug. From what I can gather from other posts it's the runtime has 'over written' some of the registry keys for Access. I think someone mentioned that a little warning on the download website would have...

Just come across a new issue with this. I have 2010 on this machine. Downloaded the runtime for deployment on other comps. Thought I'd test it on here first. Runtime installed without any issues (which contradicts this entire post!) But now all my wizards and extensions in Access don't work...

I thought the OnChange event only fires once i.e on the first keypress?

If you really want it to update as you type then you'll need to look at the Keydown, Keypress, KeyUp events. I have done this before just because it looks good. But as vbaInet says, much easier on the AfterUpdate.