Search results for query: *

Hello, I am trying to run this TRANSFER SPREADSHEET macro, but I think my syntax is wrong in the end for the RANGE option: Path = txtPath.Value DoCmd.TransferSpreadsheet acExport, , MSA_SA & " RENEWAL", "" & Path & "", True, (B8:H50)

Hi, I wanted to save the following Query, but only wanted to save Queries with Data in them since some of these Queries will have no Data in them. I wanted to save the Queries with DATA in them. Could you let me know what Argument should I be using in my DCount Statement?? SQL = "SELECT A.CID...

The following command button when clicked, saves the Query in Access and exports that Query to Excel. I get a Run-Time Error '424' "Object Required". I set A.BranchName as MSA_ARRAY(Iteration).Name BranchName is what I want to pull from the Main SQL Query and save it as an Excel Worksheet with...

I have this Filtering system that creates custom queries. The form has combo boxes for users to input criteria which they specify for a Query. I want to save the Query as well. For example, following values are entered by the user: BranchName = Blossom Year = 2005 Month = 12 It will Pull...

Hi, I have two tables Tbl1 and Tbl2. Tble2 is a Subset of Tbl1. I want to Return the values in Tbl1 MINUS the values in Tbl2. So, I used Set Operator MINUS that "Removes the result of the second query that are also found in the first Query and only displays the rows that were uniquely returned...

I have two Excel tables that I imported into an Access Database. I want to check a certain column "Customer_ID" (Maybe even two) in Table1 with Table2. Make sure its all the same Line by Line, If not, a third column in my Query named "MATCH" can say a Yes/No. I was thinking about using an...