Stop Pop Up Boxes?

[Parra]

I am working on a database someone else created. I am making copies of queries and reports and modifing them. The problem is that when I make a copy the Pop Up Boxes that are in the criteria of the queries pop up. Its annoying, Does anyone know how I can stop them from popping up. I'm not running them, just copying them and modifying them.

Thanks

 

[Corticus]

Hi Parra,

These boxes are popping up because the querries have criteria in them that can't be found, so they are requesting the value from you.

Say you have a select query, well you can set one of your criteria to something like [Forms]![FrmMain]![sfrmmain].[Form]![lst01] to have it filter the query on that field by [lst01].

Now if you move this query, and don't initiate it from the form containing the control [lst01], the query will not know what to use for this value, and prompt you with a pop-up.

You can also go to a query, and type in the criteria field something like:
[Enter Data] and when you run the query, a pop-up will appear saying:
Enter Data:

What you should do is find the query giving you trouble, open it in design view, and then look at all the criteria fields and see if there is one that has a criteria referring to a control you no longer have in this database, since you imported it from elsewhere, and relace this criteria with a control that is in this database.

edit: I see that you are not running the querries, only moving, though you still should get rid of the criteria if they refer to objects you no longer have. Also, if you click on the view icon, and set your query to design view before you open it, in other words, select the query icon, and then select the view icon and set to deesign view, you can keep Acces from trying to run the query, and go right into the design.

You also might have referenced fields that no longer exist.

HTH,

 

[Parra]

Hi Corticus,
The copying is done in the same database.
Example: I copy a query that has a popup box in the criteria of the Transaction Date.

but I copy the query and change the criteria to the Received Date.

I understand what you wrote and I agree with it, but this is happening in the same database.? I don't know why?

So I copy it, and paste in the same database and the popup boxes appear.

 

[Corticus]

Is the criteria from a form?

If you normally initiate this query from a form, the value will be in the control for the query to refer to. If you work on the query and the form's not open, it won't know what value to use for the criteria, and prompt you. Even in the same db.

HTH,

 

[Parra]

Thats a Good Idea, but its not in a form. Just a query and a report thats based of it.

 

[Corticus]

Perhaps the report needs a value from the query? Or vice versa?

I think your problem stems from Access looking for a value (the value for which it prompts you) and not finding it. Not sure there's much you can do to avoid it beyond what I suggested.

Might I suggest a 12-gauge?

My computer has responded well to this in the past (well at least the pop-ups stopped)...

HTH,

 

[Parra]

I like your suggestion on fixing the problem. One alternative I am looking into is changing management. They are asking for several reports, but they won’t do anything with them but print them and then file them away. I could be giving them false unrelated numbers and they won’t even notice.

Parra

I can't wait till I'm at the top asking for stupid reports.