How to add List of Names by One Click

[bronson_mech]

Hi Guys,



I need a help i have created a simple database for time sheet entry, in that i want to add list of names by 1 click. ie) if i click the button it should automatically add all the names in the entry sheet which i have in my table.....

please help me out.........

[pbaldy]

I'd probably create an append query and execute it from the button.

[ranman256]

the form button would run a macro "after update" event: like "mRunAddEntry"

the macro "mRunAddEntry" would have the action
docmd.openquery
"qaAddNewTimeEntry"


the query "qaAddNewTimeEntry" would have like:
Append * from tNameList


(or like that)

[June7]

Probably need an INSERT SELECT action.

In VBA, something like:

DoCmd.Execute "INSERT INTO EntryTable(EmpID, EnterDate) SELECT EmpID, Date() FROM Employees;"

[pbaldy]

I guess you can't say the same thing too many times.

[bronson_mech]

Thanks Guys it is Working perfect......

[pbaldy]

No problem.