If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"OK" Macro Buttons
I have followed the help instructions to the letter on creating a macro to
run the "OK" button on a form created to enter report criteria. The action type on the macro is set to "SetValue", the Item is set to "[Visible]", and the Expression is set to "No".......which is exactly how the instructions read on how to set this up. However, everytime the macro tries to run, I get the following error: "You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object specified." Can anyone make any recommendations? |
#2
|
|||
|
|||
"OK" Macro Buttons
On Thu, 26 Oct 2006 14:50:46 -0500, Valerie Tubbs wrote:
I have followed the help instructions to the letter on creating a macro to run the "OK" button on a form created to enter report criteria. The action type on the macro is set to "SetValue", the Item is set to "[Visible]", and the Expression is set to "No".......which is exactly how the instructions read on how to set this up. However, everytime the macro tries to run, I get the following error: "You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object specified." Can anyone make any recommendations? Yes. I would recommend that you use code. You wish to make a form not visible using a command button on that form? On that command button's property sheet, select the Event tab. Click on the Click event line and enter [Event Procedure] Then click on the button with the 3 dots that appears on that line. When the code window opens, the cursor will be flashing between 2 already written lines of code. Between those 2 lines, write: Me.Visible = False Save the changes by exiting the window. That should do it. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
"OK" Macro Buttons
Fred's advice is a-ok.
What I notice from your post is you state: "... the "OK" button on a form created to enter report criteria..." So you are pressing a button on a Form that is to make a Report not visible? Your error message is telling you that the object you are attempting to make not visible can not be made not visible.... -- NTC "Valerie Tubbs" wrote: I have followed the help instructions to the letter on creating a macro to run the "OK" button on a form created to enter report criteria. The action type on the macro is set to "SetValue", the Item is set to "[Visible]", and the Expression is set to "No".......which is exactly how the instructions read on how to set this up. However, everytime the macro tries to run, I get the following error: "You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object specified." Can anyone make any recommendations? |
#4
|
|||
|
|||
"OK" Macro Buttons
Hey fred, I tried the recommendations you gave Valerie but I don't get any
results, could give me a bit more details on how to fix this problem? Right now I have in the "On Click" event the macro for the OK button. What should I do? thanx for the help, Dennis. "fredg" wrote: On Thu, 26 Oct 2006 14:50:46 -0500, Valerie Tubbs wrote: I have followed the help instructions to the letter on creating a macro to run the "OK" button on a form created to enter report criteria. The action type on the macro is set to "SetValue", the Item is set to "[Visible]", and the Expression is set to "No".......which is exactly how the instructions read on how to set this up. However, everytime the macro tries to run, I get the following error: "You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object specified." Can anyone make any recommendations? Yes. I would recommend that you use code. You wish to make a form not visible using a command button on that form? On that command button's property sheet, select the Event tab. Click on the Click event line and enter [Event Procedure] Then click on the button with the 3 dots that appears on that line. When the code window opens, the cursor will be flashing between 2 already written lines of code. Between those 2 lines, write: Me.Visible = False Save the changes by exiting the window. That should do it. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#5
|
|||
|
|||
"OK" Macro Buttons
Hey fred, I tried the recommendations you gave Valerie but I don't get any
results, could give me a bit more details on how to fix this problem? Right now I have in the "On Click" event the macro for the OK button. What should I do? thanx for the help, Dennis. "fredg" wrote: On Thu, 26 Oct 2006 14:50:46 -0500, Valerie Tubbs wrote: I have followed the help instructions to the letter on creating a macro to run the "OK" button on a form created to enter report criteria. The action type on the macro is set to "SetValue", the Item is set to "[Visible]", and the Expression is set to "No".......which is exactly how the instructions read on how to set this up. However, everytime the macro tries to run, I get the following error: "You entered an expression that has an invalid reference to the property Visible. The property may not exist or may not apply to the object specified." Can anyone make any recommendations? Yes. I would recommend that you use code. You wish to make a form not visible using a command button on that form? On that command button's property sheet, select the Event tab. Click on the Click event line and enter [Event Procedure] Then click on the button with the 3 dots that appears on that line. When the code window opens, the cursor will be flashing between 2 already written lines of code. Between those 2 lines, write: Me.Visible = False Save the changes by exiting the window. That should do it. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|