Search results

not exactly sure how that is relevant....

One table is a list of Breaks for the month of Janurary, The other table is a list of trades for the corresponding Broker. The issue I beleive is I might have 15 breaks, but A specific broker (Knight) might have placed 3 trades that could have been placed with the same information(date, qty...

Here is the SQL View...However i attached the query & result If you see the result i highlighted, i have 7 results where i should have 2 SELECT [Janurary 2011 Master].[#400], [Citadel Master].[#], [Janurary 2011 Master].[FIRMS NAME], [Citadel Master].[Trade Date], [Citadel Master].[C/P]...

One table is a list of Breaks for the month of Janurary, The other table is a list of trades for the corresponding Broker. The issue I beleive is I might have 15 breaks, but A specific broker (Knight) might have placed 3 trades that could have been placed with the same information(date, qty...

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

Yep cought that...I changed it and it worked.... Thanks for ur patience and your help!!

Yes...I had a test module with that code in it...I deleted it... Now i have another compile error Wrong number of arguments or invalid property assignment

Im getting an compile error...ambiguous name detected: SendTQ2Excel Here is what I actually have...First what you gave me saved as Basexcelfunctions Option Compare Database Option Explicit Public Function SendTQ2Excel(strTQName As String, strFilePathAndName As String, Optional strSheetName...

I guess i should have also added that everything i know about Access I tought myself thru the help menu. looking at ur code...i almost fell out of my chair...haha... although i must say i am quite intregued....maybe if you can give me some clarity otherwise...ill be researching what that all...

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 think i got it....I have to create macro within Excel to take all 3 files and paste them into each tab... Right???:confused:

#1 i am a noob #2 Visual Basics?? not really...but i could do some research on it....is it a line of code in access?? or is this something in Excel?

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