Strange - Need Help - Enter Parameter Value

[bhipwell via AccessMonster.com]

This is very strange and seems to be happening out of the blue.

I have a form (Form A) that has a button that opens another form (Form B).
When you click this button, Form B is supposed to populate a list box based
on a text box on Form A. A simple query was created in row source property
using the wizard.

I am now getting a message to Enter Parameter Value referencing Forms!FormsA!
TextBox. I know that this is the error as when I go into the query and
delete that specific criteria, the form will work. I cannot understand how
this doesn't work since the wizard created the criteria in the first place.

I am knowledgeble about Access and am truely stumped.

On the same token, I now also get a Run Time 13 Type Mismatch error for any
line of code on the OnOpen event of Form B referncing any Text Box on Form A.


This form was working just fine as I have been working and testing it all day.
All of a sudden these two issues popped up and nothing that I have done
recently would impact these two errors.

Any help would be appreciated.

B

 

[UpRider]

I would compact/repair, get out of access, reboot and see what happens.
If that doesn't fix it, try creating a new empty database, import the forms
and see if they work there. If not, recreate the forms one at a time. You
can copy/paste the code from each form's module in the original database.
If they work, import everything else and see if it still works.

HTH, UpRider

 

[John W. Vinson]

This is very strange and seems to be happening out of the blue.

I have a form (Form A) that has a button that opens another form (Form B).
When you click this button, Form B is supposed to populate a list box based
on a text box on Form A. A simple query was created in row source property
using the wizard.

I am now getting a message to Enter Parameter Value referencing Forms!FormsA!
TextBox. I know that this is the error as when I go into the query and
delete that specific criteria, the form will work. I cannot understand how
this doesn't work since the wizard created the criteria in the first place.

I am knowledgeble about Access and am truely stumped.

On the same token, I now also get a Run Time 13 Type Mismatch error for any
line of code on the OnOpen event of Form B referncing any Text Box on Form A.


This form was working just fine as I have been working and testing it all day.
All of a sudden these two issues popped up and nothing that I have done
recently would impact these two errors.

You may have some database corruption! Have you tried Compacting, or creating
a new database and importing everything? Another possibility is a broken
reference: try opening the VBA editor and selecting Tools... References. If
any are marked MISSING, uncheck that reference, close and open Access, recheck
it, and use Debug... Compile <your project>.

Perhaps you could post the code of your button event and the SQL of the query;
maybe someone could spot a problem (although if they worked before and don't
now that seems unlikely).

John W. Vinson [MVP]

 

[bhipwell via AccessMonster.com]

Posting the code won't help much, you're. Very simple code that I know is
correct. I compiled, repaired and compacted. You name it, I did it.

I hate to rebuild this form as it is quite time consuming. Anyway to fix the
corruption that may be out there?

B

 

[John W. Vinson]

I hate to rebuild this form as it is quite time consuming. Anyway to fix the
corruption that may be out there?

Check the suggestions at Tony's website

http://www.granite.ab.ca/access/corruptmdbs.htm

if you haven't done so already. About the only other suggestion would be to
use the ill- or non-documented SaveAsText operation. Make a backup of your
database. Open the VBA editor and in the Immediate window type

Application.SaveAsText acDataForm, "FormName", "C:\SomePath\FormName.txt"

Then delete the form, Compact and Repair, and do the same thing using
LoadFromText to reimport the form.

John W. Vinson [MVP]

 

[bhipwell via AccessMonster.com]

WOW! I think I should win this year's Darwin Award for Access programming.
I actually had a list box named "Forms." So, anytime I had code such as:

If Me.Forms = "Whatever" Then
All Heck Breaks Loose

What do they say about those who do the same thing over and over again and
expect different results?

Thanks for your input, it did help me walk through a number of
troubleshooting processes.

B