Limiting # of records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to limit the database to only one record ? I know this is
stupid but we have access printing a single report and then it is erased. If
the scroll button on the mouse is touched it starts scrolling through the
other records and people think they have lost there data. I only want one
record accessable in each file that ther are using. I know its a database but
it prints a great form also
 
Just build an unbound form (instead of writing to a table) then build your
Report from the entries on that form. When the form is closed, the data is
gone.

I'd probably NOT use Access for this though.
 
Not sure I understand how you're using Access...

If you start with a form, use selection criteria in a control on the form,
base a query on the form and the value selected, and add a command button to
the form that opens the report using the WHERE clause in the
DoCmd.OpenReport statement, you can get a single record into your report.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top