Recent content by HaroldIII

Report 1 contains our ID#'s and trade info. Report 2 contains Client names and trade info The object is to get all the client names from Report 2 and put them on Report1. I match by the following: Buy/Sell, Call/Put, Strike, QTY, Price, and Symbol. The Join Properties are to only incluede...

Im running a Simple Query. I have 2 Excel files that I upload into Excel. then i go to Design Query, and link the criteria where only matched will be pulled from the reports. Then: I run a unMatched query with the original Doc vs the query. This will show me all the unmatched items. The...

So im going to change: DoCmd.OutputTo acOutputQuery, "Jan_2009", acFormatXLSX, "R:\STATS\IVY's Folder\CMTA Stats Master Report\CMTA Stats Output\Jan-2009.xlsx", False to: DoCmd.TransferSpreadsheet acOutputQuery, "Jan_2009", acFormatXLSX, "R:\STATS\IVY's Folder\CMTA Stats Master Report\CMTA...

:confused:I have multiple queries that are dated for every month of 2009, 2010, and 2011. How do i get Access to take every month for every year and place them on different tabs in excel.... Example, my end result should be: Tab1: Jan-2009 Tab2: Feb-2099 Etc... all the way to Dec-2011...

I was looking for a general answer...(other then I have a error with the external database) Like what is an external database...?

! Unexpected error from External Database Driver (with in this bracket are what seems to be chinese lettering)

I am still haveing an error....am i doing this right??? please check the attachment... thanks again

Column A has a list of brokers (some brokers comes up multiple times approx 20 different Names) Column B has a list of Clients (No Duplicate clients here, approx 150 different names) On the second Tab If cell any cell in E2:E25 has a client name, then F2:F25 needs to have the matching...

In the Daily Reporting Tab there are multiple items highlighted Yellow. These cells will be uploaded daily... The gray cells will be copied into the monthly reporting Tab according to the date that is highlighted in Yellow. The monthly reporting tab takes the Information for that day and inputs...

that were chipped

And now i see why you are the "AWF VIP" and I am the "NOOB" i created the Macro and it worked. Access was getting confused because i had the module and the function with the same name:D Thanks!!!

sorry missed 11 cause of the double post... I renamed the module to basoutput Function Output2()

output2() needed to make the post longer....

Haha...dude..you spun my head a total 360 with that last post...:confused::confused::confused::confused: Please let me clairfy what im trying to do. I have a module saved as Output2. This module takes my queries and outputs them into excel spreadsheets in a specific folder. I need to create...

then how do i run (Call) this module to output the reports i need?