Penny Arcade
The Trenches
PAX
Child's Play
Pinny Arcade
Sign In
Join Club PA
Penny Arcade
Comics
News
PATV
Podcasts
Archive
Forum
Shop
Best Of...
Sign In
·
Register
Penny Arcade Forums
›
Games and Technology
›
Moe's Stupid Technology Tavern
Quick Links
Categories
Recent Threads
Best Of...
The new forums will be named Coin Return (based on the most recent
vote
)! You can check on the status and timeline of the transition to the new forums
here
.
The Guiding Principles and New Rules
document
is now in effect.
Access Macro broken
1ddqd
Registered User
regular
July 2009
edited July 2009
in
Moe's Stupid Technology Tavern
I need help identifying wtf is happening with this broken Macro.
What I have is a report that I run. In it, I can click on a name and it *should* open a form with that person's information.
What happens is I get an error that says "Type Mismatch" and when I click ok:
Access online help says it's trust center related, but the database is opened in a trusted location (my T: drive, for reference)
1ddqd
on
July 2009
0
Posts
Aumni
Registered User
regular
July 2009
edited July 2009
Type mismatch means one of the fields in the tables you're working on has the incorrect data format.
Look at any math being performed - are all the fields numeric?
Look at any joins - are they being joined on the same data type?
Look at other conditions - are the quotes around values that should be text and so on?
Aumni
on
July 2009
http://steamcommunity.com/id/aumni/
Battlenet: Aumni#1978 GW2: Aumni.1425 PSN: Aumnius
0
1ddqd
Registered User
regular
July 2009
edited July 2009
Finally tracked it down. Why, in God's name, is there no error tracking? TELL ME WHICH FIELD IS BROKEN! It's not hard. Jesus.
1ddqd
on
July 2009
0
Sign In
or
Register
to comment.
Penny Arcade Forums
›
Games and Technology
›
Moe's Stupid Technology Tavern
Powered by Vanilla
Posts
Look at any math being performed - are all the fields numeric?
Look at any joins - are they being joined on the same data type?
Look at other conditions - are the quotes around values that should be text and so on?