Results 1 to 13 of 13
  1. #1
    billmark is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    13

    Problem in DIM, ME command

    Hi
    I try to write the code by using DIM, ME in the private sub. When I type DIM or ME, they turns red and can't add the space to continue. However, when I type docomd, it let me go. I have to write the code in word, then copy & paste back to the access. Please advise what is wrong and how to fix.

    Regards

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Is the dim inside a module?
    a form?

    ME does not work inside a module.
    Last edited by ranman256; 08-29-2016 at 06:30 AM.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Perhaps if you told us what you are trying to do in plain English, there may be some options for how to do this in Access.
    I think you'll agree that this doesn't tell us much about what.
    using DIM, ME in the private sub
    .

  4. #4
    billmark is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    13
    Hi
    I tried to write codes in the Delete button in the form. When I select the event procedure in the 'On Click', it goes to the class modules which includes other Private Sub.

    In this case, it happens as follow. It can't let me leave a space to continue.


    Private Sub DeleteRecord_Click()
    dim
    End Sub



    Regards

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    How would you describe what you are trying to do to an 80 year old grandmother?
    I tried to write codes in the Delete button in the form.
    Why? Tell us WHAT you are trying to accomplish in plain English. Forget database, Access jargon for the moment.

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Is there a form open with a timer event running?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    This is very bizarre. I have never seen it.

    check in the VBE menu, tools, references.
    is anything checked that says MISSING on it?

  8. #8
    billmark is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    13
    What I want to do is to update the audit trail table for any add, edit or delete in the input form. There is nothing missing in the tool, reference. The only thing is to write on word document and then copy & paste to the access.

  9. #9
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Should I repeat the question about a timer event running?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  10. #10
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Quote Originally Posted by pbaldy View Post
    Should I repeat the question about a timer event running?
    Good thought. Apparently the behavior has been experienced elsewhere if the form being edited has a control that is linked to another form that is open in form view.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  11. #11
    billmark is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    13
    It works after closing the form with timer. Thank.

  12. #12
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  13. #13
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I marked this thread as *Solved* for you using the *Thread Tools* at the top of the thread.
    https://www.accessforums.net/showthread.php?t=1828

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

Similar Threads

  1. Command Button Problem
    By dccjr in forum Programming
    Replies: 13
    Last Post: 01-22-2013, 08:44 PM
  2. Replies: 4
    Last Post: 08-08-2012, 10:27 PM
  3. Problem with Update Command in Access
    By anunat in forum Queries
    Replies: 3
    Last Post: 06-27-2012, 03:03 PM
  4. Command Button Problem is Subform
    By Lupson2011 in forum Access
    Replies: 3
    Last Post: 08-25-2011, 08:39 AM
  5. Set command problem in legacy system
    By ch875299 in forum Programming
    Replies: 8
    Last Post: 02-02-2010, 04:59 PM

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