Access 2003 - Basic Macro Help

[LPS]

Hi. Please bear with me... I have little experience with Access.

Question 1:
I have a client who has created a form, using fields from several different
tables, in Access 2003. He has a 4-digit field on the form in which he wants
to have an automatic and sequencial number generated each time the form is
used. So, when he (or another user) opens the form, the "Call ID" field is
automatically populated with the next number, 0001, 0002, 003, etc.

1. Is there a simple macro that can do this?
2. If so, how and where would the macro be entered?
3. What would the be macro be?

Question 2:
Same client, same form. He has several time stamp fields in which he would
like to have the system time entered, when he prompts for the entry.

1. Is it possible to create a macro and attach it to a button, so that when
he selects any of the time fields and then clicks the macro button, the time
is inserted into the selected time field?
2. What would the macro be?

Any and all help is greatly appreciated. Please keep in mind that I am new
to this application.

Thx,

 

[Steve Schapel]

LPS,

Question 1:
You don't need a macro for this. Just set the Default Value property of
the control on the form like this:
DMax("[Call ID]","NameOfTable")+1

Question 2:
You don't need a macro for this. Just teach the user to use this
keystroke shortcut:
Ctrl+:
or - Ctrl+Shift+;

 

[LPS]

Hi Steve. I had my client try both suggestions... he is working on the first
but when he tried the second (CTRL+ it did not work. Does he press these
keys while in the form field? Or does he somehow insert the action into one
of the field's properties? Does the version of the O/S make a difference.
He is either using Window 2000 or XP.

Many thanks, again.
--
LPS

LPS,

Question 1:
You don't need a macro for this. Just set the Default Value property of
the control on the form like this:
DMax("[Call ID]","NameOfTable")+1

Question 2:
You don't need a macro for this. Just teach the user to use this
keystroke shortcut:
Ctrl+:
or - Ctrl+Shift+;

--
Steve Schapel, Microsoft Access MVP

Hi. Please bear with me... I have little experience with Access.

Question 1:
I have a client who has created a form, using fields from several different
tables, in Access 2003. He has a 4-digit field on the form in which he wants
to have an automatic and sequencial number generated each time the form is
used. So, when he (or another user) opens the form, the "Call ID" field is
automatically populated with the next number, 0001, 0002, 003, etc.

1. Is there a simple macro that can do this?
2. If so, how and where would the macro be entered?
3. What would the be macro be?

Question 2:
Same client, same form. He has several time stamp fields in which he would
like to have the system time entered, when he prompts for the entry.

1. Is it possible to create a macro and attach it to a button, so that when
he selects any of the time fields and then clicks the macro button, the time
is inserted into the selected time field?
2. What would the macro be?

Any and all help is greatly appreciated. Please keep in mind that I am new
to this application.

Thx,