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

1ddqd1ddqd Registered User regular
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:Macro-2.jpg

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

Posts

  • AumniAumni Registered User regular
    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
    http://steamcommunity.com/id/aumni/ Battlenet: Aumni#1978 GW2: Aumni.1425 PSN: Aumnius
  • 1ddqd1ddqd Registered User regular
    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
Sign In or Register to comment.