13-type mismatch error

R

rigby

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
 
D

Douglas J Steele

Error 13 (type mismatch) occurs when the program is looking for data in one
format, and you provide data in a different format (such as it's looking for
a numeric value and you give it a text value)

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.
 
T

Tom Wickerath

Hi Rigby,

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 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
 
R

rigby

Thanks you both Tom and Douglas.

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
 
R

rigby

HEY!!! IT WORKED!!!

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
 
T

Tom Wickerath

Hi Rigby,

I'm glad to hear that you got it to work. Thanks for letting us know.

Good luck on your project!


Tom

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

:

HEY!!! IT WORKED!!!

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
 
Top