Search results

If I select MessageBox in a Macro, I only get a single "Ok" button in the Message Box. How can I get a Yes/No Message Box by using MACRO (not VBA)?

Bob, thank you so much for your reply. Meanwhile everything ok.

Got it, gotta insert a MessageBox action before the OpenQuery action. Now, how do I get the macro to retrieve the number of records being updated? In other words; how do I use code inside the message macro, to retrieve the sum of records set to "Yes" in a CheckBox field

I guess I have to Create my own "Dialog Box Form" and let it run before the Update Query, correct?

I used macro. Can you please help me in either, Macro or VBA?

Hi I have the same problem - running an Update Query brings up 2 warnings. Warning#1: You are about to run an update query that will modify data in your table. Are you sure you want to run this type of action query... Yes No Help Warning#2: You are about to update 3 row(s). Once you click...

You're right, vbaInet. But I had in mind people just like me. After searching and not finding the right answer that fits my needs, I worked a long time till I came up with the solution. So why not share it with future searchers? We're here to help others too, right? :)

Here's your best solution (I think ;)). That's what I did, while my system is set to USA date format (mm/dd/yyyy). 1. Field Type: "Date/Time". 2. I set Field Name as: "Exp". In form: 3. Format>format: "mm/yy". 4. Create following 'After Update' macro on that same control ("Exp")...