Results 1 to 4 of 4
  1. #1
    cpbittner is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    11

    Angry type mismatch after update


    I am losing my mind. I have an event procedure attached to the after update event of a date field. When I revise the date field it executes the code, and if I tab between fields it is fine as well, as soon as I click in another field I get a Type Mismatch error, which is crazy since I have commented out all of the actual code. The error makes reference to the expression may not result in....or [Event Procedure] - which the date field is obviously using - so perhaps that is an issue, but the code works (when uncommented) and does not generate an error unless I click in another field (versus Tabbing).

    Click image for larger version. 

Name:	type-mismatch-error.jpg 
Views:	3 
Size:	117.7 KB 
ID:	15625Click image for larger version. 

Name:	event-procedure.jpg 
Views:	3 
Size:	53.4 KB 
ID:	15626

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    When encountering weirdness, corruption is often the cause. Build new form. See if the issue replicates.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cpbittner is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    11
    I found the issue. Out of frustration I decided to say the hell with it and deleted the event procedure all together to get to the point where I could click between fields and not have the error. To my surprise the error still triggered, then on clicking the date field I saw old code I had added previously still present which I was not seeing, it is as if the event procedure code was overlaying the old code, but the event was still cascading down. Once I deleted the old code, then readded the event procedure it worked fine.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Weird corruption. Glad you found it.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 11-19-2012, 03:23 AM
  2. type mismatch
    By Compufreak in forum Access
    Replies: 5
    Last Post: 08-08-2012, 11:00 AM
  3. Type Mismatch....WHY?!!?
    By jgelpi16 in forum Queries
    Replies: 9
    Last Post: 03-07-2011, 09:18 AM
  4. Type Mismatch
    By Alex Motilal in forum Programming
    Replies: 10
    Last Post: 02-13-2011, 05:42 AM
  5. Type Mismatch - HELP!
    By jgelpi in forum Programming
    Replies: 3
    Last Post: 07-17-2009, 03:53 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums