Topics Search

Unwanted parameter message

Unwanted parameter message
Views: 44
I created a report that has a parameter for each month so it only pulls up records for the month entered. The report works fine but when I go to print it, it asks for the parameter again twice. How can I get rid of that?
Sponsored Links:

Similar posts...

 

Parameter Queries in Crosstab Query

Parameter Queries in Crosstab Query Icon
I created a parameter query, and then I created a crosstab query based on the first parameter query. I keep getting an error message that says: "The Microsoft Office Access database engine does not recognize '[start date]' as a valid field name or expression."

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.
 

No data for result

No data for result Icon
I have two form base on query. where I one has a parameter another has two parameter

[CODE]

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.
 

Displaying a message box when a form is blank

Displaying a message box when a form is blank Icon
I have a parameter query that opens a report. I have a parameter query that opens a form. I am aware of the On No Data property available for providing a message box when a teacher enters a class into a parameter query and the report is empty.

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.
 

Parameter value from a Form into a Report

Parameter value from a Form into a Report Icon
I have a form that open a report once I enter the parameter value for the query. Now I want include the parameter value into the report; but when I insert a textbox with=Report![Report_name]![Field_Name] the report start a loop, and give me an error.

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.
 

Passing Parameters to a Query Without Parameter Prompts

Passing Parameters to a Query Without Parameter Prompts Icon
I have a query that requires a parameter to work. I need to pass a form field (entered by the user) to the query as the parameter, but I don't want the parameter box to pop-up asking the user for input when the button is clicked to run the parameter.

I tried using DoCmd.RunSQL, but, if I understand correctly, this can't be used for a select statement. I used it with updating and inserting with no problems.

I'm trying to use qdf.Parameters() now, but I still get the popup. Is there a way to pass parameter without the parameter prompts?
 

Parameter Query with DSum

Parameter Query with DSum Icon
I have a query which calculates a groups % of the total. I am using a Dsum to calculate the % but when I introduce a date parameter I get the error message "The expression you entered as a query parameter produced this error: Access can't find the name 'Enter start date' you entered in the expression". The % column is null in the query results.

Without the parameter the dsum returns the correct value. Below is the sql :
 

Rogue Resource Parameter

Rogue Resource Parameter Icon
I think this came about because a renamed a form in a windows application. Now whenever Itry to run the application I get the error message: -

Error 1 The item "obj\Release\DvdDatabase.frmDVD.resources" was specified more than once in the "Resources" parameter. Duplicate items are not supported by the "Resources" parameter. DvdDatabase

frmDvd is the one I renamed to frmMain.

Try as I might I cannot seem to find the "Resource" parameter mentioned in my IDE, VS Pro 2005,
 

Error 3061 Too Few Parameters Expecting 1

Error 3061 Too Few Parameters Expecting 1 Icon
I think there is something I need to do with 'resolving' the parameter in my query, but I'm not sure how to apply the changes. I have what I think is 3 parts, a Function Module, a Query, a Button on a form, with VBA calling the function.

The query works fine when run via access queries. The problem starts with the use the criteria of adding a [enter parameter here] option to the Query Grid. When I run the query via the button on the form I get the message.

(if there is no parameter in the query it works, it's just when I have the parameter it fails.). Here is the SQL view of the query - I'm using [EnterRegion Here], for the Region ID:
 

Added form as subform Enter Parameter Value

Added form as subform Enter Parameter Value Icon
I have a form that uses a value list as the row source for a combo box. This works fine. I then added this form as a sub form of another form. When I open the form I get an error message to "Enter Parameter Value". Why is this happening and what do I need to do to remove the error message?
 

MsgBox with Office Assistant

MsgBox with Office Assistant Icon
The Program uses the default Office Assistant Setting for Message Boxes. By adding a few Functions in a Global Module of your MS-Access Project helps to make use this feature, wherever you need them. Some of the very commonly used Functions are created separately for ease of use limiting the maximum Number of Parameters needed for the Functions to two and the 2nd Parameter for Title is Optional. First Parameter for Message Text and the second one for Title. Button Type and Icon Type is already added to the Function.