Search results

Hi John, if i have more then one query then do i have to repeat these lines of code for each query?

ok so i've searched many fourms and still no clue as to how to print the query name or the checkbox label to row 1 in excel for each of the tabs. any help is appreciated it !

Still having issues, hopefully you have a better idea Bob. thanks!

no not a problem thats fine. thank you for looking into it.. i am still trying to make it work as well (without any luck at this point)...i think i am going to put it down as well and start with freash mind tomorrow... :) thank you once again

ok so to explain, i have about 50+ queries which i have checkboxes for, the user can do one of two things 1.) User can select all which will select all 55 checkboxes and run through and only export the queries that have true output (not the blank queries with no results) to excel and format it...

when i do that it screws up and creates few spreadsheet by overlaying information and insterting each querys name in rows 1, 2, 3 etc... so basically i think its going through each qeury and if it has a value it writes it but then goes through and if the second query has a value then overlays...

i think you mean xlApp.Activecell.Value = xlApp.Activesheet.Name that worked but the reason for me to print this is because some of the query names are long... and so i wanted to print it in the first row since it was getting cut of in the tab name. By doing the activesheet.name, its just...

is there some sort of hierarchy i need to consider before i use this code of line? because if i try to insert the .activecell line in it gives me the same run time error. i tried to do several different things by putting the line in different places but same issue...

thanks Bob... that worked but now getting an error on ctl.name.. i assume i cant use that but in order for me to not spell out every query dont i have to use that? am i coding it wrong?

ok so i tried using what Bob had given and below in red is where i got the error and also i have another question in the code it self... For Each ctl In MyForm.Controls Select Case ctl.ControlType Case acCheckBox If ctl = True Then Set rst = db.OpenRecordset(ctl.Name) If Not rst.EOF Then...

thank you Bob and John! Let me get to work with the examples you have given and see waht happens... thank you both again!!!

thank you both!! this does help however i was looking for a way to have the name of the query in the spreadsheet itself in the first row is there a way to do that?? so for example sheet1 - queryone and tab is named queryone (already working fine) but i want it so the word "queryone" is in...

does anyone know of how to do this? is it even possible?

Hello, is there anyway to print the query name as the header on the first row? For example i have 50+ queries that i am exportin currently to one spreadsheet with different tabs for each query, i am also formatting each tab, however the query name is printed as the tab name on each tab but gets...

never mind i figuered it out.. i had to code it so that when the form loaded the checkboxes were in the false state..

thank you both apr pillai and CBrighton! If checkbox1 = False Then checkbox1.Value = True checkbox2.Value = True Else checkbox1.Value = Flase checkbox2.Value = False End If CBrighton the solution you have given regarding the above works, however now its done in three clicks...

thank you, so if i want it so that when the lable is clicked it checks the 2 boxes is it doable? I am doing this through toggle button right now, it works fine however the form is very conjusted and not user freindly and so i thought to see if I can use a label instead. can i do this through a...

ok this should be pretty easy but getting an error that i cant seem to understand.. i have a label where if i click on it, it should check off 2 boxes and if i click on it again it should clear both. here is what i am coding too but its giving me a type mismatch error, what am i doing wrong...

awesome! thank you!

thank you!!!! that worked. Ok so right now it highlights all the text in black, how can i make it so that its plain and not highlighted?