Search results

Hello. I created a union query based on three different select queries. When the query is executed, I want the user to be able to enter specific data to search on. Each select query has the same field name for the search. This is what I currently have. SELECT * from qrySearch_Active Union...

Hello! I have a db that needs to export a query to an excel spreadsheet in the my documents folder on the users hard drive. I can make that work fine but if the directory does not exist, I need to have it created and then have the file put in the new directory. Here is the code that I use to...

I have an issue where a user needs to copy a record from one table to another. I can successfully do this using an append query but I also need to update two check boxes when the copy occurs. Is this an option with one query?

I am trying to update fields on a form from a different record source. I have a form driven by a table and a user wants to update one field and have two others autopopulate with values from another table based on the value that was entered. I was trying an After Update event and a Dlookup but...