Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Lostsouljer

    Change Query that report uses.

    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...
  2. Lostsouljer

    Report Parameter Queries help

    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
  3. Lostsouljer

    Change Query that report uses.

    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
  4. Lostsouljer

    Change Query that report uses.

    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...
  5. Lostsouljer

    Report Parameter Queries help

    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)
  6. Lostsouljer

    Report Parameter Queries help

    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
  7. Lostsouljer

    Report Parameter Queries help

    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
  8. Lostsouljer

    Change Query that report uses.

    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...
  9. Lostsouljer

    Report Parameter Queries help

    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...

Part and Inventory Search

Back
Top