By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,595 Members | 3,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,595 IT Pros & Developers. It's quick & easy.

Auto input Date, database slow

P: 83
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:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Client_bid_ARM_AfterUpdate()
  2. Me.Date_of_Bid_ARM = Format(Now(), "MMDDYYYY")
  3. 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?
May 4 '07 #1
Share this Question
Share on Google+
2 Replies


puppydogbuddy
Expert 100+
P: 1,923
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]
May 5 '07 #2

NeoPa
Expert Mod 15k+
P: 31,494
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:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Client_bid_ARM_AfterUpdate()
  2. Me.Date_of_Bid_ARM = Format(Now(), "MMDDYYYY")
  3. End Sub
Is the [Date_of_Bid_ARM] control bound to a field? If so, how is the field defined?
May 5 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.