i am trying to delete some data but am having trouble.
First of all i am appending data in tblCustomers where the field "end of stay" (in a different table (tblBookings)) equals the current date.
Using the same SQL in a new query but changing the query to a delete query, should in...
im trying to achieve a command button which copies a record from one table to another and then deletes the original once it has been copied. The code i have used is as follows:
-------------------------------------------------------
Dim strSQL As String
strSQL = "Insert Into tblresults...
does anybody know how i can use a query or command button to copy a record from one table to the next at a given date? if its only possible without the given date bit then thats fine!. thanx
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.