Unwanted parameter message
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I am trying to open a form and now it keeps asking me for a parameter value:
Service.[Service_ID]. The thing is I have no idea where, in the code, Access is looking for this value.
It seems to be doing this prior to the onset of my form load& before any form events happen (e.g., when I walk through the code, the parameter popup appears before any of these events are kicked off: Open Load Resize Activate Current). Prior to any these aformentioned events kicking off, I make attempts to open a form like so:
DoCmd.OpenForm "00160_Clone_Service_Level_Contacts", acNormal, , , acFormAdd, , strArgs
As soon as I step through the DoCmd.OpenForm line, a message box pops up asking for the parameter value, shown previously: Service.[Service_ID].
So, its looking for Service_ID from the service table, but the form is unbound. So when does it check for this value? And how can I stop it from doing this
In more detail:
I created a query where I have a pop up parameter box that asks for the start date and another asking for the end date. The parameter is written in the criteria as follows:
Between [start date mm/dd/y] and [end date mm/dd/y]
When I run the query, the parameter query works beautifully.
So then, I ran a crosstab query based on the (first) parameter query hoping that it would pull the parameter query forward, but it didn't, I got the error message instead.
Is there such a procedure for providing a message box when the teacher enters a class into a parameter query and the form is empty?
I would like to display a message box that informs the teacher that the class does not exist rather than load a blank form.
but if I set the code for two parameter values the mean second form it works but it gives another message that like form open action was canceled.
How I can put the parameter value directly from the form, without dealing with the message box report asking me the parameter value again?
The result should display: "Old account with more than [Parameter_value(from the form, not the query)] days"
Note: The form closed once it display the report.
Build Date______ Weeks Left: DateDiff("w",Now(),[Build Date]) ______ Priority: IIf([Weeks Left]>7,"Low",IIf([Weeks Left]>3,"Medium","High"))
These are the different columns in my query design, and every time I run it, it always ask for a Weeks Left Parameter Value. Although if I just click OK on the box, the query will still show the correct output. The dialogue box just annoys me a lot though. I checked the spellings and they are all the same. Anyone can help me out
This all works fine to prevent unwanted backend access, but if the user doesn't have rights to the backend, an error message comes up that allows them to see the vb code by selecting debug.
How can I have this message not show up or at least not allow the debug option? I tried just placing docmd.setwarnings = false , but that just makes itautomatically go to the debug screen with no error message.