Search results

fantastic! thanks for your advice, all is working well now. rob

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

need help just trying to bump this query back onto the notice board as i am still really stuck. the guts of the problem is that with a split database i receive an errorthat the Object Type is not supported when I use the SEEK command to find a record in a table. see my earlier post for the...

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

Thanks for the advice - works a treat! Rob

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

Thanks, Pat. All worked well with the additional "OR" query.

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

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

Thanks, all is working fine.

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

Thanks for your help - you are quite correct. I did paint an OLE object on the form but it had no control source. My theory was to assign every important OLE property to this OLE control and then assign this to the OLE object in my table. It is this last step that doesn't work. Is there a...

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