Macro with sendkeys

  • Thread starter Thread starter Lupe
  • Start date Start date
L

Lupe

Hi,
I have a user that each year is doing a vacation project. For this project
the children participating should be of a certain age on a certain date.
I have created a macro that opens the table and enters the date(s), but I
have to change to macro(s) each year with the new date(s).
I want this macro to run and open the field for the user herself to update
the date. Afterwards the rest (saving and closing of the table) should also
be done via macro. Is this possible?
Regards, Lupe
 
Lupe,

So we can better understand your requirements, can you give some examples of
the dates you are using, and the details of the macro. Thanks.

--
Steve Schapel, Microsoft Access MVP


Lupe said:
Hi,
I have a user that each year is doing a vacation project. For this project
the children participating should be of a certain age on a certain date.
I have created a macro that opens the table and enters the date(s), but I
have to change to macro(s) each year with the new date(s).
I want this macro to run and open the field for the user herself to update
the date. Afterwards the rest (saving and closing of the table) should
also
be done via macro. Is this possible?
Regards, Lupe
Click to expand...



__________ Information from ESET Smart Security, version of virus signature database 4132 (20090604) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Hi Steve,
My macro (change date for kids) is as follows:
- opentable - table name: children, view: design view, data mode: edit
- sendkeys: 3 to go to the respective field of Date_for_Child to change the
default value
- sendkeys: to enter keystrokes: 27/07/2009, Wait: Yes
- close - object type: table, object name: children, save: Yes

This date is used in several other queries to calculate the age of the
children, wether they qualify or not. There are each time 3 dates to be
changed for other categories also.
I would like to have a pop-up screen that asks the user for the date(s) and
then to continue without the user having to go in the table itself.
Hope this gives you more insight in my problem.
Regards, Lupe
 
Back
Top