Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Strange - Need Help - Enter Parameter Value

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bhipwell - 16 Jul 2007 20:40 GMT
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 - 17 Jul 2007 00:28 GMT
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

> This is very strange and seems to be happening out of the blue.
>
[quoted text clipped - 28 lines]
>
> B
John W. Vinson - 17 Jul 2007 00:51 GMT
>This is very strange and seems to be happening out of the blue.
>
[quoted text clipped - 16 lines]
>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 - 17 Jul 2007 03:19 GMT
>>This is very strange and seems to be happening out of the blue.

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 - 17 Jul 2007 07:02 GMT
>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 - 17 Jul 2007 16:06 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.