Search results

Nevermind, I think I have it figured out. I created the union query with just select statements then created another query based on the union with the criteria that I wanted to pull. I guess I just needed to write it down to figure it out. Thanks.

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...

I got it all figured out. Thanks for pointing me in the right direction.

Okay, I added the mkdir function and when I hit the command button to export the file, it creates the dir and adds the file. Now, when I go to export the file again with the mkdir function still there, I get an error, Path/File access error. This function will only have to happen once because...

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 was using Yes and No as the values I was trying to update instead of True and False. Thanks again.

You are awesome dcb. So far it is working. I am going to test a little more just to ease my mind before I throw it out for others to use. I initially tried what you suggested but of course I didn't have something correct. Thanks.

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?

Thanks for the help. I ended up using the combo box alternative. Much easier than trying to do the Dlookup and it worked perfect without racking my brain any further. :-)

Okay, I added the new code and I am getting a Run Time error that there is a Data Type Mismatch in expression: varX = DLookup("[Investor_ID]", "tblInvestor_Update", "[GSE_Code] = " & intSearch) My field names are correct and my table name is correct. Is there another way to do this that...

I know this is really bad code but I am still getting to know this part of access. Private Sub txtInvestorID_AfterUpdate() Dim intSearch As Integer Dim varX As Variant intSearch = 1 varX = DLookup("[InvestorID]", "tblInvestor_Update", _ "[GSE_Code] = " & intSearch) End Sub What I...

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...