Search results

Thanks for the reply, Pat. This is a bound form but the suggestion from arnelgp works great, a macro calling a function: ======================= If you must use runcode, create first a public function in a standard module in vba: Public function fnPutDate() Forms!yourformname!datebox=Date End...

arnelgp: Sweet! Creating the public function and calling it from the RunCode command in the macro works perfectly. Many thanks! Question: when I click the "Save Changes" button, which I put on the form for when users edit an existing record, my message box pops us correctly, "Record saved...

arnelgp: this sounds right to me but how do I add code lines to the macro? I'm using the macro UI (form design view --> "Add New Record" button properties --> On Click event --> Embedded macro (ellipsis) opens the Macro UI but I see no way to just enter raw lines of code. I tried adding a...

Thanks, good replies. However... More detail: I have “locked down” Access to behave as a stand alone application. The user will launch a desktop shortcut that launches a Main Menu modal form that is all they see centered on the screen. No tables, no forms, no navigation etc. only the Main Menu...

Access created a macro for my button to create a new record (via button wizard), but I'd like to have that new record's first field ("DateBox") auto-populated with the current date. I see no way to use the existing macro function to populate that default-focus field with the date. I'd prefer NOT...