Results 1 to 6 of 6
  1. #1
    valinistor is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2013
    Posts
    3

    Exclamation Error - form - after update event - don't understand why

    Click image for larger version. 

Name:	error.png 
Views:	5 
Size:	41.6 KB 
ID:	13009

    hello forum,


    I'm trying to design a form to mark the start date for log in and then use it to calculate the time between the login and the time the user finishes some work.
    they track it in an Access tracker.

    the thing is that i'm having an error with the on Update event I can't figure it out why.
    it took it step my step and I redone it 2 times already. it seems to be working but then when I'm closing and reopening the database i have this error - see inserted image.

    i would greately appreciate if you could take a look and advise.

    the form is frmTrackerPontaj and the error appears on the update event for NumeAngajat listbox
    i've added the database as attachment
    Attached Files Attached Files
    Last edited by valinistor; 07-10-2013 at 03:54 AM. Reason: file reupload

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    At the top of your edit page add Option Explicit.

    Then Compile.

    It shows you the errors.

    For 1 you call out a DAO Recordset without Diming it.

    Most of what I see at a quick look is that you are not Diming your variables.

    Try Dimensioning your variables and see what happens.

    Dale

  3. #3
    valinistor is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2013
    Posts
    3
    Hello Dale,
    I've done that but the error is still there - unfortunately.
    I would appreciate if you could take a second look.

    thank you

  4. #4
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    Did you Dimension all of the errors the compiler gave you?

    Dale

  5. #5
    valinistor is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2013
    Posts
    3
    yes. that seems to have fixed it.

    thank you very much

  6. #6
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    You are most welcome.
    Dale

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

Similar Threads

  1. Runtime error 424 on an After Update Event
    By maxx429 in forum Programming
    Replies: 3
    Last Post: 04-21-2012, 01:03 PM
  2. Replies: 3
    Last Post: 04-15-2012, 05:25 PM
  3. Replies: 2
    Last Post: 07-11-2011, 05:34 AM
  4. Split form event error
    By witooldas in forum Forms
    Replies: 10
    Last Post: 03-24-2011, 03:15 AM
  5. Form does not update after event
    By pedro in forum Forms
    Replies: 10
    Last Post: 12-23-2009, 07:54 AM

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