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 TouchToneTommy 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: RayProud
  • Content: Threads
  • Order by date
  1. RayProud

    Select Count very slow in Access 2003

    I've converted an Access 97 database to Access 2003 and the performance when using Select Count is dreadful. I've had to revert to FindFirst which is much much faster. I don't understand this because in Access 97 it was just the opposite. I'm holding data in a local table on the front-end and...
  2. RayProud

    Storing values from form in query

    I have a problem with a query that works in Access 97 but doesn't with the same database converted to Access 2003 (SP1). I display a form that requests two pieces of info from the user - a Start Sequence Number and End Sequence Number. These are entered into text boxes. The user presses the...
  3. RayProud

    Reading Outlook Inbox using Access 97

    Hi, I'm working on an Access 97 database and one of the requirements is to read the Inbox on the PC where the database is located and to send a reply to the sender. We're using Outlook 98. I have managed to send a message from Access but I can't work out how to read the Outlook Inbox. I'm...
  4. RayProud

    Sorting records after ApplyFilter action

    Hi all, I'm using Access97. I have a form where the user enters either a staff number of part of a staff number and I then use the ApplyFilter command to retrieve the matching record(s). But, I can't find how to sort the returned records. The form is bound to a query where the sort order is by...
  5. RayProud

    Which DLL or OCX controls DoCmd.TransferSpreadsheet

    I have a module in an Access 97 database that contains the command DoCmd.TransferSpreadsheet. When this is actioned it fails with the following error message - "Can't update. Database or object is read-only. (Error 3027)". I believe this message is a red herring because the spreadsheet trying...
  6. RayProud

    TransferSpreadsheet no longer works in Access 97.

    An Access97 database than has been in use for several years has suddenly developed a problem when running VBA code. The command 'DoCmd.TransferSpreadsheet' fails with the error message "3027 - Can't update database or object is read only". This command is creating an XLS file on the user's C...
  7. RayProud

    TransferSpreadsheet command no longer works in Access97

    An Access97 database than has been in use for several years has suddenly developed a problem when running VBA code. The command 'DoCmd.TransferSpreadsheet' fails with the error message "3027 - Can't update database or object is read only". The only thing that has changed is an update on user's...

Part and Inventory Search

Back
Top