Annoying popup messages

[Anonymous_354]

I have no idea wheather this is supposed to go in Queries or Forms, so feel free to move this to either.

Here's my problem:

I made a query that looks at three text boxes on a form. I'm not sure how to set up the buttons correctly so I just bluffed it (like always ). Every time I run the query it keeps wanting me to re-enter the data that it was supposed to look at anyway! If you need more info, just ask. Thanks.

Anonymous_354

P.S.: I'm really new at this. I just learned about Access a week ago.

P.P.S.: I use Access 2000

 

[boblarson]

The syntax you used to refer to the text boxes is likely incorrect and Access is telling you that by asking what the values are since it can't find what you told it.

 

[rainman89]

sounds like your query isnt referencing your form values
make sure u have
forms!frmname.controlname as the criteria for your query values

 

[Anonymous_354]

I've already done that. It still comes up with the same box. What special things do I have to do to the button?

 

[boblarson]

What wording, exactly, do you have in your criteria? And what is your form's name and what is your text box name and is this on a subform?

 

[Anonymous_354]

Criteria? [Forms]![OrdersbyProject]![LINE_JOB] as well as [Forms]![OrdersbyProject]![ORDER_NO] as well as [Forms]![OrdersbyProject]![ITEM_NO]. Form name: OrdersbyProject. The text boxs' names are LINE_JOB, ORDER_NO, and ITEM_NO. No subform.

 

[rainman89]

Think u need a period

[Forms]![OrdersbyProject].[LINE_JOB]

 

[boblarson]

The more I think about it I would really like to see what you are actually doing. Is there a possibility you could go to Tools > Database Tools > Compact and Repair and compact the database and then use WinZip (or similar) and zip the mdb file, then upload it here?

 

[Anonymous_354]

Uhh, a period doesn't change anything. The file is too big to transfer (unless you want me to send it via e-mail or 13 copies).

 

[boblarson]

How big is it after running the Compact and Repair and then zipping it?

 

[Anonymous_354]

5.75Mb. If you chop it into 13 pieces you can get it through here. Would e-mail work?

 

[boblarson]

You can send it to me. I'll PM you my email address.

 

[Anonymous_354]

Near 5Mb if you RAR it after you Zip and compress it in Access!

 

[WayneRyan]

Anonymous,

I think that maybe it's as simple as:

[Forms]![OrdersbyProject]![LINE_JOB] <-- [Line_Job] is probably the ControlSource

[Forms]![OrdersbyProject]![Text27] <-- Is probably the real name on your textbox

Check it in Design View.

hth,
Wayne

 

[Anonymous_354]

What's the difference between an ! and a . anyway?

 

[Anonymous_354]

Names are correct... I think. Bob, I sent you an old copy. Should I send you a new one?

 

[Anonymous_354]

Names are correct

 

[boblarson]

Names are correct... I think. Bob, I sent you an old copy. Should I send you a new one?

If you sent an old one, please do send the latest. Also, please include in the email a detailed description of where I'm supposed to be looking.

 

[WayneRyan]

Bob,

I think that "The names are correct" ... to a human.

I still think that his real form objects are "Textnn" and that's why Access
can't resolve them. That's the only time that it will prompt for a value.

Wayne

 

[Anonymous_354]

I gave a copy of the file to Bob so we'll see what turns up. I'm really new at this, so I wouldn't be too surprised if it was something REALLY simple.