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!

Register Log in
  • 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: *

  • Users: longmot
  • Content: Threads
  • Order by date
  1. longmot

    Got New Record Not Working.

    Hi, For some reason the code to select a new record (see below) has stopped working all of a sudden. Has it got something to do with references maybe? It has been working fine for months. command used: DoCmd.GoToRecord , , acNewRec Thanks
  2. longmot

    Call Access Routine From Excel..

    Anyone know how to call an Access routine from Excel. I can run queries and open recordsets etc. but not call routines.
  3. longmot

    Importing csv file into Access table

    Any ideas on how I can go about importing a csv file into an access 97 database by calling the routine from excel (2000)? I can populate the access table from an xls file via an excel macro but having trouble with the csv file which has too many rows for excel.
  4. longmot

    Dr Watson on Combo Boxes in Access 97.

    Hi, I seem to be getting a number of Dr Watson errors when using combo boxes. The database I have is has a split front end / back end. The dr watson occurs as I go to select the from the combo box but before it shows any of the dates. It occurs every time you do this once it starts. If I...
  5. longmot

    Opening CSV files in Excel with VBA.

    I am getting different results with different users when using opening csv files in excel from vba command. User 1. All date fields are open with dd/mm/yyyy format. The same when opening the file manually. User 2. All date fields are open with dd/mm/yyyy format when opened manually but when...
  6. longmot

    Null combo box then select all.

    Hi, I have a query where I want to select based on the value of a combo box on a form if it is not null else select all records. See below SQL which is not working as no records are being selected when the combo box is null. Could you help please..? SELECT...

Part and Inventory Search

Back
Top