By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,971 Members | 1,732 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,971 IT Pros & Developers. It's quick & easy.

Is there a simple way to produce a report upon user input?

P: 52
I’m looking for suggestions to see if it is possible to produce information in a read only format for my users. I have an event log within an Access table which tracks all the installations within our servers (there are 34 different servers by the way). The users need the ability to query this information by the specific server name. How can I produce this information via an easy interface (report, query, datasheet, etc) which would allow the user to input/select the server name and then produce the report?

I’m sure this is pretty easy for it appears Access is very powerful. I must admit that I am a novice and trying to learn as I go. I have purchased several books to help me learn the application but I can find nothing that covers the sort of situation I am trying to address here.

Any help would be greatly appreciated. Can you also tell me where I can find the select that is being used behind a report and or datasheet? Is this select alterable, maybe via VB?

Thanks
Birky
Jan 23 '07 #1
Share this Question
Share on Google+
3 Replies


P: 52
Hold the phones… After researching this quite extensively on the internet as well as within this site I have stumbled over the perfect solution. All I needed to do was create the Report and within the repots properties alter a few options.

Filter On - Yes
Filter - Server=Server

Now when I launch the report, Access prompts me to enter the Server from within an “Enter Parameter Value” box where the user can enter the name of the Sever. Once they select OK the report is generated with the Server name information.

Thought I would post to let you know I did find a simple and very useful solution..

Birky
Jan 23 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks for that Birky. It's great that you came back and posted the solution here as it will be useful to others.

Mary
Jan 23 '07 #3

NeoPa
Expert Mod 15k+
P: 31,560
Can you also tell me where I can find the select that is being used behind a report and or datasheet? Is this select alterable, maybe via VB?

Thanks
Birky
If you open the properties of a Report the top one is Record Source.
This either has the SQL or the name of the QueryDef the Report is based upon.
This is alterable via VBA. It is generally best to do this in the Report_Open event procedure.
Jan 23 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.