does access keep a history?

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

Guest

Im a newbie with this stuff, and my boss is getting me to make a database for
the company. I need to know if Access keeps a history of things before they
are changed. Also i need to know if its possible to make a drop down menu in
a query. I know how to make em in forms and tables, but I was wondering if
that is possible in a parameter query where you type in what you want it to
search for. Any random advice for me creating this database might help too.
Thanks.
 
Im a newbie with this stuff, and my boss is getting me to make a database for
the company. I need to know if Access keeps a history of things before they
are changed.
Click to expand...

No, it does not. You can do so yourself using VBA code but if you
change or delete a value, the old value is gone for good.
Also i need to know if its possible to make a drop down menu in
a query. I know how to make em in forms and tables, but I was wondering if
that is possible in a parameter query where you type in what you want it to
search for. Any random advice for me creating this database might help too.
Thanks.
Click to expand...

Yes, you can do this. The simplest way is to create an unbound Form
(let's call it frmCrit) with a Combo Box on the form (cboMyCombo let's
say). The Bound Column of the combo should be whichver field you want
to search for (usually a concealed numeric ID but whatever you need);
its Control Source must be blank, since you don't want this combo box
overwriting anything.

On your Query you would use a criterion

=[Forms]![frmCrit]![cboMyCombo]

It's also handy to base a Form (for onscreen display) or a Report (for
printing) on this query, and put a command button on frmCrit (using
the toolbox button wizard) to open said form or report. Users should
in general never see query or table datasheets.

John W. Vinson[MVP]
 
Back
Top