Yeah i realise that, but i did have some code behind it, i was using this page as a template
http://office.microsoft.com/en-au/assistance/HA011170771033.aspx
The way they have it in there the report opens up the form to let you enter in the parameters.
Your way is working now though so i...
I commented out the form closing code but am still having the same problem. I found the thread below and it is working for me so i will try and do it that way. Thank you for all your help though, its greatly appreciated
Brendon
http://www.tek-tips.com/viewthread.cfm?qid=1175691&page=1
Yeah looks like im going to have to do it the way you suggested (using the form to open up the report instead of just opening up the report) (plus that way is working for me so always a bonus)
Thanks for all the help :-)
Brendon
Thank you for the reply and advice Tom (I have started a new post as well.) Yes the name of the form is "Sort by Workshop Date" and the text boxs on the form are StartDate and EndDate and both are undound. I have just copied and pasted the names into the query to avoid spelling mistakes yet am...
I dont know how to edit posts in this forum but the writing in that box is part of my query (it has two pop up boxes, one for the start date and one for the end date)
I have tried what you suggested. It still opens the form to let me input the paramaters but i then get this pop up box asking for the parameters again?? Im at a loss to what is wrong. Thank you for your help so far though
Brendon
I have been using this page
http://office.microsoft.com/en-au/assistance/HA011170771033.aspx
as a guide, from what i can understand, it opens up the query that i have named Appointments Period and then closes the form
Hey Tom, i have done all that on a similar report i am making, but after i click on the command button to open the report i get a text box pop up asking me to enter in the country (or in my case Date) the text box has the heading "Enter Parameter Value" and then part of the code i created in my...
I Have created a report that is obtaining its parameters from a form, which in turn then runs a query, the problem i am having is that after you enter the parameters into the form (a start date and end date), two text boxes pop up asking you to enter the startdate and enddate for the query...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.