Macro to open table and add records

[Michelle]

I want to create a macro that will do the following: Open
a table, allow me to add records, and then upon closing
the table open a query.

I have the first and last part, but I'm stuck on how I
can stop the macro from running until after the table is
closed.

Note: I do not want to use a form with a command button
for this.

Thanks in advance for any help!

 

[Steve Schapel]

Michelle,

Any particular reason for not wanting to use a form for data entry?
This is, after all, what forms are for, whereas tables are not at all
suited to this purpose.

 

[Guest]

Maybe you have another idea that I haven't thought of.
Most of the data entry I do is copying and pasting data
from Excel. It's easy to paste into a table, but I
haven't been able to make a form that will be just as
simple. You can't add command buttons to a form in
datasheet view, at least not that I know of. If I could,
then I wouldn't have any problem doing what I need to
do. Right now I have a table that I paste information
into. I then run a macro that performs a series of
operations (delete and append queries, etc.).

 

[Steve Schapel]

Michelle,

It could be that a TransferSpreadsheet macro/method may be a more
effective means of getting your Excel data into your Access table?