Need help with a Checkbox

[bigtman07]

If macro coding is the only way to do this then is there anything I can do to make this work??? Boss isn't thrilled that the input has to be manual. But if there isn't any other way then so be it. I may have to try and build a non web based one and do it that way. If anyone has any suggestions or would like to help me build a macro that will put the date and time in a text field I would greatly appreciate it.

[June7]

Maybe SetValue macro action is what you want. http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[bigtman07]

That might work if I had that option in my macro list.

[bigtman07]

I don't need any error checking or anything that fancy. I just need to put in the day and time automatically. So I need to find a place to put the Now() command and it will run. Sad thing is I can't find where to put it on this stupid web form to run.

[June7]

The option is kind of there. Have to reveal it. Click the Show All Actions on the macro Design tab. Why MS decided to separate some actions and force you to find them is anyone's guess.

[bigtman07]

Here is what I have. Not seeing SetValue in my macro list.

[June7]

Odd, it shows up for me. I created a checkbox on form, in Click event selected Embedded Macro, macro editor opens and the SetValue action does not show. I click Show All Actions, and then it shows. However, am using 2007 at the moment.

[bigtman07]

Lol well maybe that has been my problem all along. This access is messed up. You have it set as a web form?? Maybe that is the difference.

[June7]

Okay, so SetValue is not available for web forms http://office.microsoft.com/en-us/ac...010386888.aspx. Maybe solution is in the alternates listed in that link, possibly SetLocalVar or SetTempVar.

[bigtman07]

lol yeah tell me about it. When I started this whole thing I didn't realize a web DB was sooooo different. I had made some before and never had this much trouble. I do appreciate the help!!

[June7]

I edit my previous post while you were posting. More info.

[bigtman07]

lol ok thanks! I'll look into those options too!!

[bigtman07]

Well you are not going to believe this... But somehow I got the full list of commands to show in the macro list!!! No idea how I did it but I did. So now we are getting somewhere... I think

[June7]

That is with a web form or a normal form?

[bigtman07]

The Web form. I haven't made any changes to my current setup. I now have the RunCode Command. Within there I am able to put my now command and then call the command. Now I need to figure out how to insert the data from the now function into my CheckInTime field.