Access database command function

[Maria]

Hello,

I have created a database and now I have been asked if it's possible that
once an entry form has been marked 'complete' to purge it into a query. I've
looked for a command, or something similiar, but it seems the 2003 version is
limited.

What I want this command to do is once an 'entry form' has been completed by
a USER, to have that particular entry removed and filed to a query, without
removing the incomplete forms.

What function or command do I use to get this done? I was thinking of
placing a 'button' command labeled 'completed' for the USER to press once
the entry is ready to be filed, and having the command execute the macro, but
I don't seem to find a command for that to happen. I'm not very good at
creating macros if this is what I need to do.

Could you please help?

Thanks,--
Maria

 

[pietlinden]

Hello,

I have created a database and now I have been asked if it's possible that
once an entry form has been marked 'complete' to purge it into a query. I've
looked for a command, or something similiar, but it seems the 2003 version is
limited.

What I want this command to do is once an 'entry form' has been completed by
a USER, to have that particular entry removed and filed to a query, without
removing the incomplete forms.

What function or command do I use to get this done? I was thinking of
placing a 'button' command labeled 'completed' for the USER to press once
the entry is ready to be filed, and having the command execute the macro, but
I don't seem to find a command for that to happen. I'm not very good at
creating macros if this is what I need to do.

Could you please help?

Thanks,--
Maria

What do you mean "purge" the entry? Delete it? Or mark it somehow?
or Move it to another table? I would probably just update the record
if certain criteria are met. You can do that with an update query and
conditionals in Macros. But I rarely if ever use them, so you might
be on your own on that part.