473,320 Members | 1,974 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Auto input Date, database slow

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
2 1996
puppydogbuddy
1,923 Expert 1GB
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
32,556 Expert Mod 16PB
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

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

Similar topics

12
by: Susan Cranford | last post by:
Please forgive, I have looked at so much info I can't figure out how to put it together even though I know it must be fairly simple. I have an array of input text boxes (txtDOBn) where n is...
2
by: buck | last post by:
I'm working on a helpdesk database - does anyone know how to auto enter the date in a new record; would it be soemthing like iif field is null auto enter?
8
by: John Smith | last post by:
Hello all: Is there a way to determine the auto increment id from a newly inserted record in the database? Thanks, John
5
by: Navillus | last post by:
Hey gang, I have a login form that is empty by default, but can be filled with values from a previous form: <input type=text maxlength="40" size="40" name="user" value="`usr`"> <input...
17
by: Liam.M | last post by:
Hey guys, Forgive me if my question my be alittle silly, but I would very much appreciate and assistance that could be given! My situation is as follows: I have created a Button, and set...
2
by: bsmith | last post by:
Having a little problem with a project my boss gave me. We have a web based hosting site that we have multiple databases that the users can connect to. Right now we have it set up that they can...
0
chumlyumly
by: chumlyumly | last post by:
Hello scripters - OS: Mac OSX Language: PHP w/ MySQL database I've created an insert page where a user inputs his info, which then goes to four different tables in a MySQL database. The...
6
by: awojciehowski | last post by:
I am working with a database now and need some guidance. I am attempting to input an auto calculation. I have the ability to enter a date in a text box on a form. I want to be able to have...
1
AaronL
by: AaronL | last post by:
Hello, First I would like to say thank you all for your help in the past. I am stumped again. I am creating an e-commerce system and I want to be able to upload images to the server and...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.