Microsoft access can't find the macro......

[Jphillis]

I am trying to calculate the total time from a start and finish time. I am using the experssion:

txtDiff = DateDiff("h", txtStart, txtEnd) & ":" & DateDiff("n", txtStart, txtEnd) Mod 60

as show in a thread, but when i try to execute it the message "Microsoft access can't find the macro txtDiff = DateDiff("h", txtStart, txtEnd) & ":" & DateDiff("n", txtStart, txtEnd) Mod 60. The macro does not exist."

As far as i am aware i am not using a macro. Should i be?

 

[tlbroadbent]

Where are you using the statement? On a form? In VB code? In a query? Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln

 

[Jphillis]

yeah on a form

 

[tlbroadbent]

Is the statement the control source of a text box? If so, try this in the control source.

= DateDiff("h", [txtStart], [txtEnd]) & ":" & DateDiff("n", [txtStart], [txtEnd]) Mod 60
Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln

 

[Jphillis]

Thanks....that has done the trick.