I have a secured database that I split. How come the security is only enforced on the front end and not on the back end? How can I enforce the security on both?
by adding this line, I get information on the first item in the mailbox....which is the oldest one. How can I get information on the last item in the mail box?
I am trying to understand how VBA in outlook works.
I created the following routine, which looks for a new message with the subject of %Test% and then displays a message box with the sender's name. But I get an error that says 'Object variable not set' What do I need to set?
Private Sub...
I have the following code in an Access 2000 database, it is designed to archive a table with the date.
Dim strSQL As String
strSQL = "SELECT tbl_BillingMaster.* INTO [archive" & Date & "] FROM tbl_BillingMaster;"
DoCmd.RunSQL strSQL
When this runs, the user is prompted with...
When I run the query, I get the following error: Query input must contain at least one table or query.
I asked the question to try and understand a concept, what I am trying to do is generate a query in code that will create a copy of a table into an archive table which will include the day's...
Assuming that I have a table called: tbl_Clients
and that I want to create a query that selects all records from tbl_Clients and save it as myQueryClients.
All of this will run as a routine.
How could I do that?
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.