Search results

ok so i changed it to this DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, ctl.Name, fileIn, True, "" and its exporting only the ones with true results if i picked more then 5 but the issue it always send the first query even if it has results or not...but the rest work fine and...

So if I do that it gives me an error that "run time error 3010 Table A1:Z90 already exists" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, ctl.Name, fileIn, True, "A1:Z90" is there something else i should refer to so it goes to the next sheet?

Cbrighton/vbaInet, please help...i think we're almost there if i can get this last thing to work so it doesnt override my sheet everytime all the queries are run... i want them so that they export out to different sheets...i appreciate all the help you and vbaInet has given me!!!

when you say "by using range argument of transferspreadsheet" isnt that the name of the sheet? so "missing name errors" is that the range? or do i put something else here?

so i runs through each query but only exports the last query that had results in the first tab... i was thinking it would go through and give me all the query that have results and post it in different sheets... is it because the transfersheet refrences "missing name errors"? how can i make it...

thanks CBrighton. question does this mean when my run report button is clicked it will go through each checkbox even if its not clicked?

ok so i went back to ur original question and even if i put the query name in the tag property of the checkbox, it still exports both the queries instead of just one query...

hi vbaInet, ok so i feel really dumb right now... since i cant understand what u r refering to .. are you saying that the name of the checkbox and the query name need to match? if you look at my if else statement, the lable name is "Missing_name_on_file" and the query name is "1b-...

the if then else statement runs the query when the checkbox is clicked...is that what you're asking?

Ok so i went and corrected the issue, however when it goes through the code it still spits out the query that does not have any errors... whats wrong?? Private Sub run_reports_Click() Dim db As DAO.Database Set db = CurrentDb Dim rst As DAO.Recordset If Missing_name_on_file.Value = True Then...

Same issue again on the same line code "Set rst = db.openrecordset ("1b- Missing_name_on_file") " - runtime error 13 "Type Mismatch"...i am using 2007 ...could that be the reason??? does it matter?

cool... when i try to implement that in my code it gives me an error and highlights he following code error "type mismatch" Private Sub run_reports_Click() Dim db As Database Set db = CurrentDb Dim rst As Recordset If Missing_name_on_file.Value = True Then Set rst = ("1b-...

yes so to give you an example.. if the user checked query 1,2 and 3 and only query 1 and 2 have results then I would like to export just query 1 and 2 to different sheets in excel.

Hello, learning access and VB Code as I have this DB that I have inherited. I have multiple queries (about 60) that run on different tables and have different values on each query. I want to run these queries (using checkbox) and then export query (using button) to excel (each query on single...

can anyone please help??? if i do this then the follwoing error comes "runtime error 438 object doesnt support this property or method" With xlApp.ActiveSheet .Columns.Select .Columns.EntireColumn.AutoFit .Range("A1").Select 'Selects first cell to deselect the rest of the sheet...

nevermind stupid me i got it..thank you very much Jared... but now my question becomes how do i select just the first row??? and then do what ever it is that i need to do? before it was xlRange...but now it gives me an error stating "Object variable or with bolck variable not set" ?? what i...

Hello Jared, I am glad this forum helped you, trust me a lot of the credits goes to Mr.B and also other posts i have been researching...just a mini part on my end...thank you for your code above, however i do have a question...not sure if you remember but i ad 2 functions where i called the path...

can you gte me started on how to get this done? have not used setfocus before and not sure where to begin...PLEASE??? thanks!

please help anyone!!!!

Hello, i've inhereted this DB and am very new at this and no clue what going on...on top i was forced to upgrade to access 2007...the db was working fine in 2003 but now is giving me this runtime error "" in 2007. when i searched the web i saw that the filesearch has been removed in access...