Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mmartinez74

    Security on a split database

    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?
  2. mmartinez74

    Outlook Application_NewMail Problem

    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?
  3. mmartinez74

    Outlook Application_NewMail Problem

    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...
  4. mmartinez74

    populate a combo boxes list with items from a folder

    I have a resource folder full of images. Is there a way to populate the list items of a combo box with the items in this resource folder?
  5. mmartinez74

    Running a query with a confirmation dialog

    Thanks! You were a huge help!
  6. mmartinez74

    Running a query with a confirmation dialog

    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...
  7. mmartinez74

    How do I create a query in code?

    Nevermind...I found the problem was with a syntax error in my code...thanks a bunch!
  8. mmartinez74

    How do I create a query in code?

    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...
  9. mmartinez74

    How do I create a query in code?

    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?

Part and Inventory Search

Back
Top