Without knowing what the database is doing when the error's raised, there's
really no specific advice we can give you as to how to overcome the error.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"rigby" <ri...@discussions.microsoft.com> wrote in message
news:7A09BD28-75ED-434A...@microsoft.com...
> I am very new to access. i downloaded (and paid for) a database template
> which very closely suits this company's needs. i am now trying to
customize
> it. all i did, was move a textbox in design view of a form from the bottom
of
> a list to the top. then, when ever i opened the form, i would get the
error
> message "13-type mismatch"
>
> Can anyone help me fix this. i do have a backup copy which is fine, but i
> still need to make changes without disrupting the database's operation. i
> know nothing of 'modules' and 'visual basic' . do i need to?
>
> Thanks
You might try searching your database code for references to "recordset", as
in "Dim rst As Recordset" (rst is the name of the variable; it can be a
different variable as well). To search the code, open your database and then
press the ALT and F11 keys together. Then click on Edit > Find... and enter
the term "Recordset" (without the quotes). Select Current Project as the
search option. If you find any lines similar to:
Dim VariableName As Recordset
then determine whether you need an ADO or a DAO recordset. If you see code
that declares a database variable, as in Dim db As Database, and then sets
the recordset like this: Set rst = db.OpenRecordset, then this is definately
DAO code. Here is an article that might be helpful for you:
ADO and DAO Library References in Access Databases
http://www.access.qbuilt.com/html/gem_tips1.html
There are other methods that are common to both libraries as well. The
downloadable database includes a query that lists the common methods.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
I feel way out of my league here. I have tried, Tom, to find the 'Recordset'
which i found and it read: 'Dim rs As Recordset' and then above it, it read
'Dim db As Database'. i am unclear as to what i need to do to change it?
Thank you for your time.
Rigby
i'm honestly not entirely sure what i did, but i followed what that 'gem
tips' site said to do, and it worked, the error message didnt come up again.
you are legend, man. thanks
i will definitely look you up again if i have another problem (which no
doubt i will)
cheers
rigby
I'm glad to hear that you got it to work. Thanks for letting us know.
Good luck on your project!
Thank you!
--
Brendan Reynolds
"rigby" <ri...@discussions.microsoft.com> wrote in message
news:EA8D745F-847C-4B4F...@microsoft.com...
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
--
Brendan Reynolds
"rigby" <ri...@discussions.microsoft.com> wrote in message
news:FFFB2FD1-48B9-4D6E...@microsoft.com...
please, i still need help!?!?!? oh, do i need to know much about VB to do
all this too?
Thanks Brendan
Rigby Smith
--
Brendan Reynolds
"rigby" <ri...@discussions.microsoft.com> wrote in message
news:27EE1288-799B-46DF...@microsoft.com...
> what do you mean by post that code?
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
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
__________________________________________