Access questions

  • Thread starter Thread starter Shark
  • Start date Start date
S

Shark

Trying to do the following:

1st Question
"Export the rptCustomers report to a new Excel 97-2002
workbook called Customer's List. The new workbook should
be in the current folder."

2nd Question
"Without using the Expression Builder, ensure that if a
user enters any date in the Shipped Date field that is on
or before January 1, 2000, Access will show a message that
says "The date is invalid."
 
1) Highlight the desired report, go to Export... in the file menu. Name the file, save it as an Excel file type in the desired location

2) In the table's design view, put an expression in the "validation rule" field property, and the desired error message in "validation text"
 
Many thanks for your help-the first answer worked like a
charm! For the second question, I'm trying to correctly
enter the expression in the validation rule field property
and I'm getting error messages. I'm entered the date
as "#01/01/2000#". Do you have any suggestions? As you
can tell, I'm a brand new user. Thanks again.
-----Original Message-----
1) Highlight the desired report, go to Export... in the
Click to expand...
file menu. Name the file, save it as an Excel file type
in the desired location
2) In the table's design view, put an expression in
Click to expand...
the "validation rule" field property, and the desired
error message in "validation text"
 
Back
Top