Recent content by AccessDev

  1. A

    SELECT SQL Query with variables

    I have tried the following now I get another error. Run-time error 3129 Invalid SQL statement; expected DELETE,INSERT,PROCEDURE,SELECT or UPDATE
  2. A

    SELECT SQL Query with variables

    Dear All, I am trying to perform a SELECT query in access vba to show me customer account numbers in a msgbox. I get a Run-time error '13': Type mismatch. I would appreciate any help. Please see below for examples of my code. 'CustomerID is a Global Variable that gets it's...
  3. A

    Advanced Search Form

    Dear All, I need to create an advanced search form. I need to search for. Customer Or And Ref Number Or And Product Or And By date range If someone could help me I would be most grateful.
  4. A

    Connection String

    Many thakns for your reply
  5. A

    Connection String

    Can smeone please give a complete connection string using DAO. I then need to open a connection in turn a recordset and perform a dlookup. many thanks for any help
  6. A

    Report Printing

    Cheap PDF software There is a piece of software called Cute PDF you need to download the Ghost Wirter and the Cute PDF Printer this will install a PDF printer in you printer list. File >> Print>>Cute PDF Printer Hope this helps
  7. A

    Page Breaking Issues

    :mad: I have a logistics database that shows a report with all drops relative to the vehicle. I have a form that filters the query that is behind the report. This shows me all drops that are selected from a multi select list box from a form. I need to print each drop on a seperate piece of...
  8. A

    Filter query by multi select listbox

    Dear All, I am just starting out in Access Development. I have a database that runs a logistics department. This was working fine until the users wanted a little more tweaking. The report prints out the vehicles with all corresponding drops. This comes out all on sheet. Is there a way that...
See more
Back
Top Bottom