Search results

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

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

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

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

Ok...now I think im losing my mind. Im trying to create a macro that will run a module named Output2() Right now i have action "RunCode" then Arguments "Output2()" Please help

hey everyone.... I'm not a programmer, (yet) however I work as a private contracter thru a temp agency. I have read alot of the treads under small business and I have to ask. What are my rights to my work?? Im building an Access Database to create an efficant work space here at this company...

DoCmd.OutputTo acOutputQuery, "Exch_Compare", acFormatXLSX, "M:\Exceptions Research\OutPut\(NEED TODAYS DATE HERE)Exchange.xlsx", False Hi- I need to add todays date to the output file name. It needs to change every day (Today "3-8-2011Exchange.xlsx) then (tomorrow 3-9-2011Exchange.xlsx)...

Can someone help me. Im trying to find the instruction manual for my RUMBA mainframe session. PS....I tried googling it already...got instructions on how to dance the RUMBA....not the actual Program Thanks

Ill do my best to describe what I need to do...:o Please keep in mind, I am a noob and the only macros i know how to run are very basic.:D I have MS Access run some compares, then I output a few excel spreadsheets. I then open these EXCEL spreadsheets and manually input all these fingures...

Anyone have another suggestion on a download P2P Prog?? And whats up with torrents??? I investigated Torrents and even downloaded a Free Torrent Prog....Now im on the phone with the comp techs....tryin to save my Hard Drive.......:eek:

I run a compare between 2 tables. Table "A" & Table "B". Table "A" is Numbered 1-100. The end result is fine, however, I want to use the result to remove whatever numbers 1-100, Table "A", that matched with the rest of my query result. Thanks:confused:

I have 2 tables: Master (A) & Master (B) There is no unique match between tables. I have numbered the first column in each table 1-whatever.... I have noticed that #'s in Master (A) & Numbers in Master(B) are multiplying on a massive scale. ie; 10 rows in master (A) match to 3 rows in...

DoCmd.OutputTo acOutputQuery, "Knight Compare", acFormatXLSX, "c:\apps\xp\Desktop\Project File\EXCEL FILES\Output Folder\Knight \Knight.xlsx", False Looks like ur basic output code; However, The issue im having is the actual output size is over 205000 rows but when I run this module, Only...

I have 3 reports with no unique column that can idenify a true match. I inserted a column in both reports numbering each itemthat range 1-22405. Report "A" is my break report, Report "B"&"C" have the same information but in addition has an idenifier that shows me who owns the break. The...

I have multiple queries that output to a specific folder, however i want to join a few of them, so instead of seperate files, One Excel file with multiple tabs....Is this possible? Here is what i got so far: DoCmd.OutputTo acOutputQuery, "Citidel Vs Jan 2011 Breaks", acFormatXLS, "C:\Documents...

Ok so im trying to link a XLS file to my access data base, however; there are 2 columns that show blank after the linking process is complete. The Spreadsheet has these columns populated. One is date m/dd/yyyy format, the other is Quantity (formatted as Number). I linked another spreadsheet...