QueryParameter issue

[roger556]

I have created a query with a criteria that runs a parameter but the list of parameters is long so I would like to create a drop down list what would be the best way to pursue doing it.My Goal is to provide a simple drop down list to select from for the end user rather than going through selecting each parameter and most important to remember them.


Please any help or suggestions is more than welcomed

Thanks,
Rajesh

[alansidman]

This tutorial may have your solution

http://www.datapigtechnologies.com/f...earchform.html

Alan

[roger556]

Hi Alan,
I have been following your video since yesterday I have understood the idea but I am doing something wrong in between the steps.That is messing up my form and achieving the goal of pulling all the records.Is there any was we can chat in google chat or something so I can better understand your presentation.
Please let me know also I want to print a report after running these parameters I have already created a select query and it also has its report.
I am stuck how to create a form and link it to the query so it can run the query.
Thanks a lot in advance for all your help appreciate it.

Roger

[roger556]

Hi Alan,
I have figured out how to create clear parameter button thanks a lot for your presentation it is really awesome you see I am a rookie in access so everything is coming slowly to me.
Thanks for sharing this awesome video really appreciate it.I am sure I should be able to figure out the rest of the form set up.

Roger

[roger556]

Hi Alan,
I was able to create the form and also was able to sucessfully set up the buttons.One last question please can you tell me how to create a report as per the criteria and also how to set up the button.Please do I need to set up any filter criteria as right now I was able to set up a button through wizard but it pulls up the whole report rather than just the parameter I set up on the form.
Please do you have any suggestions.Thanks in advance.

Roger

[roger556]

Hi Alan,
I have a question in my query table I have field that lists all the GL ticket numbers now gl is listed as G/L in the fields of the table it belongs to and also in all the reports,forms,queries.So it will be impossible for me to change all that without messing my database set up.
Now the problem is when I run the code for Clear Parameters it does not like / in GL and so it is triggering a parameter query.I am not sure how to work around it .
Please can you suggest a way where by I am able to keep that slash and still be able to run the clear parameter button without triggerring parameter query window popping up.

Thanks,

Roger

[alansidman]

Here is a list of reserved words and symbols. In simple English, Access doesn't like it when you use these. The slash is one of those reserved symbols. You will need to change it.

http://office.microsoft.com/en-us/ac...010030643.aspx

Alan

[roger556]

Hi Alan,
I was able to fix that issue now I do not have any errors in the VB thanks for all the help and guidance really appreciate it.
One last question I was wondering if there is a way to create a auto fax button that will fax specific record in the report.If so please can you guide as how I should go about setting it up.

Thanks,

Roger

[alansidman]

Roger;
I have never done this, but did a quick search in google using "Fax from MS Access" Here is one link -- there may be more......

http://support.microsoft.com/kb/145787

Alan

[roger556]

Hi Alan,
Its me again I have a question I have 10 reports that I am manually clicking to open,run and print them I would like to create a form that will give me sets of buttons or text box that would run those reports and also give me the option of printing them.
Please can you suggest to me as to how should I go about doing it.I should be able to select which report I need to run and also print it.
Thanks in advance for all your help.

Roger

[alansidman]

On a new form, create 10 command buttons and link each to an on click event in the properties to open and and run the particular report. If you use the wizard when you create the button, it should assist you and give you the option to run a report.

Alan

[roger556]

Thanks alan for your response really appreciate all your help I am able to better my access skills with what you are sharing with me.I am very grateful to you for that.
Is it possible to create a drop down list of all the reports in a form secondly is it possible to open a report right from a form in the sense if I add information in form it should open respective reports for that entry so I can print it.
Please any ideas are more than welcomed my database is based on invoices from different vendors I have reports that create a receipt and a fax cover sheet for a particular vendor invoice entry.So I want to just pull the record in the report I just data entered in the form.

Thanks,
Roger

[alansidman]

Take a look at this video. Sounds like this is what you are looking to do.

http://www.datapigtechnologies.com/f...eportlist.html

Alan

[roger556]

Hi Alan,
Thanks a lot you are awesome I have a lot to learn from you.I have created the dynamic report as shown in your video.I have one more question as usual is it possible for me to set up the report to open the last entered record .Is it possible to set up the reports in such a manner where it opens to that last date.
Now I have set up in the Report selector to post the last entered record last.But when I open the report it still opens to the first record so I have to select on the record button on the report to take me to the last entered record.
Is there a way to sort of distinct it so when I open the report it takes me to the last entered record by the latest date.
Hope I am making sense...

Thanks

Roger

[alansidman]

Roger;
This had me stumped so I started to play around with a report that I run regularly. What I found is that if you open the report in PrintPreview and then page to the last page and close the report it will ask you if you want to save the report. Click Yes. Now when you open the report, it will open with the last record (page) opening. Is this what you are attempting to do? Or do you want the last record to appear first on the first page? If the latter is what you are looking for, then open the query that is underlying the report and change the sort to descending for the field you want to determine the sort should act upon.

I hope this gets you where you need to be. Post back if you need more assistance.

Alan