mustangcoupe
Technical User
Hello,
I have an access dB that I am trying to link to excel. I have done almost everyting I need to do BUT when I generate a report I get a pop up box that says enter parameter value and has a text field and "OK" and "cancel". This entry in the text box is entered in the page header on the report (Label27 with a control of "test method:"
. But I need to enter data in to this text box and click OK from Excel vba without the user. Any ideas??
I was told this is generated by SQL. I do not understand SQL at ALL!!!!! I can not make changed to the DB either as some users use the DB directly not in excel.
thanks in advance
Todd
I have an access dB that I am trying to link to excel. I have done almost everyting I need to do BUT when I generate a report I get a pop up box that says enter parameter value and has a text field and "OK" and "cancel". This entry in the text box is entered in the page header on the report (Label27 with a control of "test method:"
. But I need to enter data in to this text box and click OK from Excel vba without the user. Any ideas??I was told this is generated by SQL. I do not understand SQL at ALL!!!!! I can not make changed to the DB either as some users use the DB directly not in excel.
thanks in advance
Todd