User Profile

Collapse

Profile Sidebar

Collapse
prncstela
prncstela
Last Activity: Nov 1 '08, 11:34 PM
Joined: Oct 30 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • prncstela
    replied to Increase value by 1
    in Access
    I am now receiving a syntax error? I apologize for being a pain.

    Also, does it matter if I am putting this on the VBA for the form or the table? I am putting it in the one for the table (wasn't sure if that made a difference).t...
    See more | Go to post
    Last edited by prncstela; Nov 1 '08, 11:16 PM. Reason: Add info

      Leave a comment:

    • prncstela
      replied to Increase value by 1
      in Access
      Thanks, Nico. With the code you suggested I'm getting a Compile error: Expected: end of statement

      Any ideas??...
      See more | Go to post

        Leave a comment:

      • prncstela
        replied to Increase value by 1
        in Access
        Ok... sorry about that.

        Right now I have (thanks to Nico's post)
        Code:
        Private Sub Entry_Number_DblClick(Cancel As Integer)
Me.Entry_Number = Val(Left(Me.Entry_Number, 5) + 1)
DoCmd.RunCommand acCmdSaveRecord
End Sub
        So, when I double click the Entry Number field on the Account Transaction List form it increases what is currently in the field by 1 each time it is double clicked (so, I could do it...
        See more | Go to post
        Last edited by prncstela; Nov 1 '08, 03:30 PM. Reason: Add more info

          Leave a comment:

        • prncstela
          started a topic Increase value by 1
          in Access

          Increase value by 1

          Hi. I am fairly new at Access and am in need of some help...

          I am trying to use the database located here:
          http://office.microsoft.com/en-us/te...CT101428241033

          On the form Account Transaction List I would like for the Entry Number field to start with 08001 and then increase by 1 for each new entry.

          How do I make this possible?

          thx

          tel...
          See more | Go to post
          No activity results to display
          Show More
          Working...