Search results

I'm trying to make this Dcount work I've searched the forum and pondered other examples. I don't think I need any quotes since the criteria is a number. I've verified that the int3 is what I want it to be immediately before the Dcount, but the result of the function is as if I haven't put in...

I want to be able to launch a certain excel file from a button in Access. I've searched the forum and have found that there are problems passing filepaths with spaces in them. The solution is using more quotes around the filepath to pass the spaces too. However, I'm still having trouble. Can you...

I have a DB that I just distribute a shortcut to a front end on a network location. Then when I update the front end I delete the old one and give the new one the same name as the old one, so everyone's shortcut still works, but the FE has changed. I haven't seen anyone else do this, which...

I have a query that displays results in a form, but if the query is null, I want to display a different form, or just an error message that says something like "your query returned no results" (right now it will display the form with no fields) I am a beginning Access/VBA user and have searched...

I have two fields (Vendor and Manufacturer) -which to a user searching the DB seem very similiar- and I want the user to be able to search and return results that appear in either field with only one input, but still maintain seperate fields. I've tried prompting the user with: Like "*" &...

I've been using the ctrl+F search in order to search my db for a string or phrase (from a form). Now, after I put it on the Intranet and accesss it through there, I use ctrl+F and if I search for something that is not there, it doesn't return a "did not find" box. It's like it just keeps...