clear a table after clicking the command button

[Guest]

I have a button that let me submit a table when clicked. Now, how do I clear
the same table after that? I ran out of ideas, so I need your help please
Thank you

 

[Allen Browne]

If you want to delete all the records in Table1:

dbEngine(0)(0).Execute "DELETE FROM [Table1];", dbFailOnError

 

[Guest]

Thank you Allen for your help. This is what I needed.
I have one more question though. This made me realize that I was not
including the current record on my email. How do I add the record first to
the table before submitting it?

If you want to delete all the records in Table1:

dbEngine(0)(0).Execute "DELETE FROM [Table1];", dbFailOnError

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a button that let me submit a table when clicked. Now, how do I
clear
the same table after that? I ran out of ideas, so I need your help please
Thank you

 

[Allen Browne]

If you have a form bound to a table, and you want to force the save of the
record currently being edited, the safest code is:
Me.Dirty = False

If the form has focus, you could use:
RunCommand acCmdSaveRecord

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thank you Allen for your help. This is what I needed.
I have one more question though. This made me realize that I was not
including the current record on my email. How do I add the record first
to
the table before submitting it?

If you want to delete all the records in Table1:

dbEngine(0)(0).Execute "DELETE FROM [Table1];", dbFailOnError

I have a button that let me submit a table when clicked. Now, how do I
clear
the same table after that? I ran out of ideas, so I need your help
please
Thank you

 

[Guest]

rock on.
It works now. Thank you

If you have a form bound to a table, and you want to force the save of the
record currently being edited, the safest code is:
Me.Dirty = False

If the form has focus, you could use:
RunCommand acCmdSaveRecord

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thank you Allen for your help. This is what I needed.
I have one more question though. This made me realize that I was not
including the current record on my email. How do I add the record first
to
the table before submitting it?

If you want to delete all the records in Table1:

dbEngine(0)(0).Execute "DELETE FROM [Table1];", dbFailOnError


I have a button that let me submit a table when clicked. Now, how do I
clear
the same table after that? I ran out of ideas, so I need your help
please
Thank you