Auto input Date, database slow

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jl2886
    New Member
    • Mar 2007
    • 83

    #1

    Auto input Date, database slow

    I have three questions:
    I have a variable that is going to be input with a monetary amount and upon update of that variable i want another field in the form to be populated with the now date. I keep getting a cursor error:
    Code:
    Private Sub Client_bid_ARM_AfterUpdate()
    Me.Date_of_Bid_ARM = Format(Now(), "MMDDYYYY")
    End Sub
    Next question, my database is sitting on a server and it is running extremely slow, why woud it run so slow?

    After I am finished with creating the database, there will be multiple users. Will multiple users be able to use the same form?
  • puppydogbuddy
    Recognized Expert Top Contributor
    • May 2007
    • 1923

    #2
    1.try the code syntax below and see if it helps. If it doesn't help, please provide more details as to what you mean by cursor error.
    Me![Date_of_Bid_ARM].Value = Format(Now(), "MMDDYYYY")

    2. There could be any of a number of reasons for slow performance. The following links are for two sites that have good diagnostic tools or procedures for you to follow:

    [color=#6b6b6b]http://www.ssw.com.au/ssw/PerformancePRO/[/color]
    [color=#6b6b6b]http://www.granite.ab. ca/access/performancefaq. htm[/color]

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32669

      #3
      Originally posted by jl2886
      I have a variable that is going to be input with a monetary amount and upon update of that variable i want another field in the form to be populated with the now date. I keep getting a cursor error:
      Code:
      Private Sub Client_bid_ARM_AfterUpdate()
      Me.Date_of_Bid_ARM = Format(Now(), "MMDDYYYY")
      End Sub
      Is the [Date_of_Bid_ARM] control bound to a field? If so, how is the field defined?

      Comment

      Working...