Search results

HELL YA!!!!!!!!!! I was going CRAZY!!!!!!!!!!!!!!!! THANK YOU THANK YOU THANK YOU!!!!

OMG ... thats all???? geez... thank you!!!!!!!!!!!!!!!

for combo box row source here is the SQL i have SELECT tblClient.ID, tblClient.[Client name] FROM tblClient; for record source of the form, here is the SQL that i have SELECT tblclient_selection.ID, tblclient_selection.ClientName, tblclient_selection.[qryedit_200]...

not sure what you mean by code, its a combo box and the only thing i am doing is requerying the form... and the combo box itself has a query built in to do the selection. I have attached the Database in this forum, does that not help?

Hello, my combo box works fine and it updates the field as expected, however when i choose a value on the list, it brings up the appropriate records on the form but moves the name on the combobox to the next value, but the records still remain for the first value i chose, when i choose the...

i actually got it to work... i had to basically add all the controls in the table ... i just thought maybe i can try few and then see if it runs.. but i should have known...went brain dead for few hours there :) thanks for your help though!!!

i didnt have that and added that but still the same error at the same point

do you think the ctl would only work with unbound checkboxes and not bound checkboxes?

i do have that.. Dim db As DAO.Database Set db = CurrentDb Dim rst As DAO.Recordset Dim MyForm As Form Set MyForm = Forms!edit_selection Dim fileIn As String Dim intCountofSheets, intCurrentSheet As Integer Dim strFileName As String

not sure waht you mean, do you mean the record source of the form?

Hi, i basically have a combobox that when selected checks all the check boxes that are applicable for that customer. Now the checked boxes i want to export these out in excel. it was working fine previously when the checkboxes were not bound, but now that they are bound its not working.. and am...

nevermind i got it to work after researching further i had to use db.execute and not db.openrecordset.... thanks again for your help! Summer

can ayone please help? Basically i want to check of the queries i want to run and export it out.. the code i have above only work on select queries and not append queries.. i have append queries that stores the results in a table and i want to then export the table... so really check off the...

can append queries be run withctl.name though? i think that only opens select queries correct? if so do i now need to do 50 if/else statements to run append queries... can someone please help? PLEASE

so do i need to write docmd.openquery for all 50+ append queries that i have?? or is there another way?

so how do i run a query that is checked off? do i have to name each one? i was thinking to do docmd.openquery but do i have to write out each one? i assume you mean something like below right? For Each ctl In MyForm.Controls Select Case ctl.ControlType Case acCheckBox If ctl =...

let me try that! thanks for the idea.

Hello, i have bunch of checkboxes that someone can click and export to excel, however it exports to different tabs. how do i make them export to one tab but on different rows? so for example if check box1, 2 and 3 are clicked and only 1 and 3 have values then current it exports checkbox 1 value...

first of all THANK YOU!!! that is exactly what i was trying to do! Also the Author should be you as i am not the one who wrote this so i will change that, i really appreciate your help. I am not going to try and see if it works for me on my DB and will let you know if i have any questions. But...

yes your understanding is correct on both of these and this DB is not what i am working on, this is just somthing i pulled off of Access that they offer so that i can show you what i am trying to do... hope that helps and THANK YOU!