I'd like to validate two numbers being entered on a form.
One is to within 0.5 ( i..e. 6.5 or 7.0 is ok but 6.6 and 6.4 are not.)
and the other is to within 0.05  (i.e 6.05 and 6.40 are OK but 6.47 and 6.52
are not

I want to build into a form a way store deleted records in an archive table
for 30-days.  Records may get deleted by accident or on purpose, but I want
a way to fall back in-case this happens.
So, the record would be deleted from the User's view and from the main

Is there an alpha equivalent to the "NumRecs" code?
Thanks,
LB

I have a table with a startdate and an enddate.
ex. 04/30/04,  04/30/05
I have a form that opens a report with a where statement
DoCmd.OpenReport stDocName, acPreview, , ["startDate] between #" &

I have an employee clock-in program.  I have hundreds of employees and
hundreds of password fields tied to each employee.  I want the form view for
each record to only update and save if the field for password is filled out
correctly.  If not, I want an error message and a cancel ...

I have a form that I use as a dialog box.  On the form is an OK button with
the following code behind it.
'minimizes the dialog box (can't close it because the viewqc form needs
'to use the code number to do the query).

Does anyone know if this is possible?
At the moment on my form I have a label reading "Today's date is" and a
separate unbound text box fomatted as Date().
I would like to combine the whole thing into one unbound text box.

I'm trying to construnct a string for a hyperlink in VBA which will display a
different value from the actual address (string is passed to Outlook mail
message). E.g. the display of the link would say Approve, and not show the
entire address.

In our database, we wish to have the following:
item #1 is either yes/no. Item #2 has 5 possible values, say, A,B,C,D, and E.
We want it to behave as follows:
if the user inputs item #1 as yes, then Item #2 will only allow C,D, or E as

I load data into my access db from a .csv file.  I want to delete the file
after loading the data.  What is the proper vb code. Any help will be
appreciated.

I am trying to increase the max entries of a combo box.  I have over 100k
rows in my table.  Is there a way to do this?  If not, are there any
alternatives?

I have a subform that is nested 2 deep.
The main form is DocEntry
1st Subform is Offices
2nd is OfficesSpecsSub

I have a continuous form based on a query(2 related tables). I would like to
have a couple of drop downs or text boxes that the users can use to filter
the form. The filters correspond to the query fields IndexField and Category.
They should be able to filter on one, both or none ...

I'm assigned a task to generate a dynamic report which shows the sales
number based on the month chosen.
The structure of the table 'Sales' is
account, name, $Jan-lastyr, $feb-lastyr, $mar-lastyr....., $Jan-thisyr,

Hi everyone!!! Happy Cinco de Mayo!  Using A02 on XP. Have
a form with unique field [Key]. Want to fill in the form
and click the button to open the report. But only want the
report for that record not all records and don't want to