Date problem 2

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

Guest

I posted this before, but got an answer I did not understand.

I need to have the date a check box was clicked stored in a table.

I created a macro. The action was SetValue. The item is caled [Email
Verified Date]. The expression is Date().

When I click the check I get n error which says "The expression you entered
has function name that Microsoft Access can't find"

I don't understand. I have done this before with no problem.

When I change the expression to Now() it works fine, except I can't easily
total the number of checks per date.

I wrote a similar question over the weekend, but my facts were not exact.
 
You need to have your object (Email Verified Date) completely qualified. E.g.,
if it's a control on a form, you have to call the item Forms!YourFormName!
[Email Verified Date] in order for the macro to work. If the form is closed,
of course, it won't work at all. The Date() function is no problem.

Hope this helps, but I might be missing something.

Sam
I posted this before, but got an answer I did not understand.

I need to have the date a check box was clicked stored in a table.

I created a macro. The action was SetValue. The item is caled [Email
Verified Date]. The expression is Date().

When I click the check I get n error which says "The expression you entered
has function name that Microsoft Access can't find"

I don't understand. I have done this before with no problem.

When I change the expression to Now() it works fine, except I can't easily
total the number of checks per date.

I wrote a similar question over the weekend, but my facts were not exact.
Click to expand...
 
This did not work.

OfficeDev18 via AccessMonster.com said:
You need to have your object (Email Verified Date) completely qualified. E.g.,
if it's a control on a form, you have to call the item Forms!YourFormName!
[Email Verified Date] in order for the macro to work. If the form is closed,
of course, it won't work at all. The Date() function is no problem.

Hope this helps, but I might be missing something.

Sam
I posted this before, but got an answer I did not understand.

I need to have the date a check box was clicked stored in a table.

I created a macro. The action was SetValue. The item is caled [Email
Verified Date]. The expression is Date().

When I click the check I get n error which says "The expression you entered
has function name that Microsoft Access can't find"

I don't understand. I have done this before with no problem.

When I change the expression to Now() it works fine, except I can't easily
total the number of checks per date.

I wrote a similar question over the weekend, but my facts were not exact.
Click to expand...
Click to expand...
 
This actually worked

Duane Hookom said:
Possibly a references issue. Check Doug Steele's page
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

You should consider converting your macros to code....

--
Duane Hookom
MS Access MVP
--

zombeese said:
I posted this before, but got an answer I did not understand.

I need to have the date a check box was clicked stored in a table.

I created a macro. The action was SetValue. The item is caled [Email
Verified Date]. The expression is Date().

When I click the check I get n error which says "The expression you
entered
has function name that Microsoft Access can't find"

I don't understand. I have done this before with no problem.

When I change the expression to Now() it works fine, except I can't easily
total the number of checks per date.

I wrote a similar question over the weekend, but my facts were not exact.
Click to expand...
Click to expand...
 
Back
Top