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

ms-access parameter value query

P: n/a
Hi,

If, for example an access database that concerns insurance claim
investigations.

The database comprises only one table containing data - investigation
reference number, referral date, referral source, investigation
commencement date, forename of claimant, surname of claimant, address1
of claimant, address2 of claimant, postcode of claimant, comments,
investigation end date, outcome etc etc.

All of this data is displayed in one "sheet", all the information
relating to the investigation can be seen at once.

In my database I have successfully implemented a parameter value query
that requires a user input and this returns the result in the
datasheet view.

What I want to do is to have the results displayed in the form view
(as mentioned above) displaying all of the data relating to that
particular parameter value.

Please could someone advise me or point me to a resource that explains
how to achieve this.

Thanks very much

Z
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
What do you want to search on?

If it is just one unique field (such as the reference number), and there are
only a few thousand of them, you could use this simple technique:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

If you want to be able to choose one field (any field, but only one at a
time), and then filter the form to match what you type, see:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
This is copy'n'paste stuff, i.e. you don't need to change the code to use
it.

If you want to provide a form where the user can enter several things at
once (e.g. date range and claimant surname), see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
This one does require some coding, but includes a sample database for you to
download, pull apart, and see how it works.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"de_ja" <de***@hotmail.co.ukwrote in message
news:ae**********************************@c58g2000 hsc.googlegroups.com...
>
If, for example an access database that concerns insurance claim
investigations.

The database comprises only one table containing data - investigation
reference number, referral date, referral source, investigation
commencement date, forename of claimant, surname of claimant,
address1 of claimant, address2 of claimant, postcode of claimant,
comments, investigation end date, outcome etc etc.

All of this data is displayed in one "sheet", all the information
relating to the investigation can be seen at once.

In my database I have successfully implemented a parameter value
query that requires a user input and this returns the result in the
datasheet view.

What I want to do is to have the results displayed in the form view
(as mentioned above) displaying all of the data relating to that
particular parameter value.

Please could someone advise me or point me to a resource that
explains how to achieve this.

Thanks very much

Z
Jun 27 '08 #2

P: n/a

Thanks very much Allen,

I will have a look at your sites later.
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.