Search results

  1. R

    After splitting the DataBase I get the error - Object isn't supported

    My database worked fine before I split it using the MS Access DB Split Wizard. However, now it produces the following error message in one of my forms: "Operation is not supported for this type of object". It occurs at a SEEK statement StudentICASelectionstbl.Seek StudentICASelectionstbl is...
  2. R

    After Splitting DB error - Object isn't supported

    My database worked fine before I split using the MS Access DB Split Wizard. However, now it produces the following error message in one of my forms: "Operation is not supported for this type of object". It occurs at the statement StudentICASelectionstbl.Seek and StudentICASelectionstbl is a...
  3. R

    Trapping External Errors from hyperlink text fields

    I know how to trap standard MS Access errors where the error trapping code searches for a particular MS Access error number. However, how do you get a list of all possible MS Windows error codes so that external events can be trapped and resolved. My specific problem involves atext field that...
  4. R

    Adding "All" to a combo box

    I have a User Interface form for a user to select an author to find all books written by an author. The combo box, cboAuthor, is unbound on the User Interface form but sources data using the following SQL: SELECT tblPersons.AuthorID, tblPersons.AuthorName FROM tblPersons; A report is then run...
  5. R

    Trapping External Errors from hyperlinks

    I know how to trap standard MS Access errors where you can ahve the error trapping code search for a particular MS ACCess error number. However, how do you get a list of all possible MS Windows error codes so that external events can be trapped and resolved. For example, I ahve a hyperlink...
  6. R

    Popualting a List Box from an Array

    In my form, I have 4 key controls, one text box to allow the user to add a Product description, one command button to kick off some validation specific VBA, a list box that is initially empty and a batch update button. The user has the option of creating 99 Product descriptions before hitting a...
  7. R

    Cannot create an OLE Linked field in a recordset using VBA

    My goal is to programmatically set the OLE datatype field in one of my tables to the OLE object selected by a user via the Open File Dialog Box ie. if the user selects "c:\my documents\Demo.xls" I want to set the 'Multimedia' field in my 'DataSetDetails' table to 'demo.xls' I have painted a...
Back
Top Bottom