13-type mismatch error

R

rigby

i know i have asked this before, but i cannot find the answer again.
i am in my main switchboard and try open another form. it comes up reading
"Error in module Form_Open" - '13-Type mismatch'. i have tried 'gems tips'
and still nothing helps. i need to figure out how to fix this please. i am so
stuck. HELP!

Thank you!
 
B

Brendan Reynolds

It would appear that there is an error in the VBA code in the Form_Open
event procedure of the form you are trying to open. You'll likely need to
post that code before anyone can tell you what the problem is.
 
R

rigby

Brendan
Finally, someone who can help me, what do you mean by post that code? i have
managed to change it so i dont get the same error message anymore. but
instead i get a new one, but i dont know VBA (i wish i did). this is the new
error message:
2465-Microsoft Office Access cant find the field 'Category 08_Label'referred
to in your expression

and then there's this other error message (i seem to be making a mess of
things):
....oh, actually its very similar but referring to the field 'Label 107'
instead. i bought this database online and wanted to customize it to our
company needs, but when i make adjustments, i create errors. please help me!!!

Thanks
Rigby
 
B

Brendan Reynolds

I'm afraid I can't help you unless you can provide the information that
would enable me to do so. There's no way for me to know what expression
might be causing that error message. Try to think about what you were doing
before the error message first appeared. Look at the things you changed. One
of those things has a reference to something called 'Category 08_Label' that
Access can't find - or can't find in the context of that expression.
 
R

rigby

I deleted some text boxes with their labels which were called 'category 08'
through to 20. i did my best to find them in all forms, tables, queries,
modules, etc and delete any reference to them at all. as far as my limited
knowledge can tell, there is still an expression somewhere referring to it,
coz, well, thats what the error message says. i realise you wouldnt be able
to help much unless you could see it for yourself, but is there no possible
location i am missing that still needs to be erased?
or have i gone about it all wrong and should not have deleted all existence
of these text boxes and their labels??

please, i still need help!?!?!? oh, do i need to know much about VB to do
all this too?

Thanks Brendan
Rigby Smith
 
B

Brendan Reynolds

Check the Filter and Order By properties of the form. You'll find them on
the Data tab of the Properties window in form design view. If you don't see
the Properties window, you can display it by choosing Properties from the
View menu.
 
R

rigby

I have found those properties, filter: [Company] = "Ibs" and Order By: Company
is this where my problem lies?
Now I know this is getting off the subject, but, another difficulty i'm
having is, when i enter info into a field, and i want it to be left the way i
entered it, like, not change the case of the words, but it keeps changing it.
i tried changing the IME sentence mode, is that right? there are no Input
Masks on these fields that i can find anywhere. i'm trying to locate any
reference to them in VB now
 
T

Tom Wickerath

Hi Rigby,
what do you mean by post that code?
Click to expand...
Brendan was suggesting that you post the code for the Form_Open event
procedure. Open the form in design view. Then click on View > Properties to
display the properties dialog if it is not already displayed. You should see
the word "Form" in the blue title bar of the properties dialog. If not, click
on the small black square in the upper left-hand corner of the form. Select
the Event tab of the properties dialog. Do you see anything listed on the
line labelled "On Open"? If so, click into this box. Then click on the
ellipses button (the button with the three small dots, which will become
visible as soon as you click into the box). This should take you to the
Form's Open procedure (macro, code or expression). If you find a macro,
record the actions for the macro and type them into a reply. If you find
code, copy the code and paste it into a reply.
this is the new error message:
2465-Microsoft Office Access cant find the field 'Category 08_Label' referred
to in your expression
Click to expand...

Here is a trick that may help you locate this control:

1.) Close this form, and any other objects (tables, queries, forms, reports,
macros, or modules) that might be open.

2.) Click on Tools > Analyze > Documenter

3.) Select the "All Object Types" tab. Click the Select All button. Click on
the Options... button. You want to select everything, so place checks in the
first three options, and select the last option button it the two remaining
groups. Click on OK to dismiss this dialog. Click on OK one more time to run
the documenter.

4.) When the documenter is complete, a report should be displayed. Click on
File > Export. Select Rich Text Format (*.rtf) in the Save as type dropdown.
Give the file a name and save to a folder.

5.) Find this new file using Windows Explorer. Open it in Word. Use Edit >
Find. Search the document for Category 08_Label. Make a note of any locations
that are found. Repeat the search, this time using Label 107 as the search
term.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Brendan
Finally, someone who can help me, what do you mean by post that code? i have
managed to change it so i dont get the same error message anymore. but
instead i get a new one, but i dont know VBA (i wish i did). this is the new
error message:
2465-Microsoft Office Access cant find the field 'Category 08_Label'referred
to in your expression and then there's this other error message (i seem to
be making a mess of things):

....oh, actually its very similar but referring to the field 'Label 107'
instead. i bought this database online and wanted to customize it to our
company needs, but when i make adjustments, i create errors. please help me!!!

Thanks
Rigby
 
Top