Prev: Msaccess 97 out of memory
Next: VBS Script to Run Macro in Access 2003
From: de_ja on 26 Jun 2008 07:33
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
From: Allen Browne on 26 Jun 2008 07:54
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_ja(a)hotmail.co.uk> wrote in message
news:aee10330-f100-40e5-b295-2cb6001559e7(a)c58g2000hsc.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

From: de_ja on 26 Jun 2008 08:10

Thanks very much Allen,

I will have a look at your sites later.
 | 
Pages: 1
Prev: Msaccess 97 out of memory
Next: VBS Script to Run Macro in Access 2003