Search results for query: *

All, I have found the problem with my code/ data. The line below did not specify a path to the backend file. Therefore it was finding an old copy on my c:\drive which did not contain the latest records. Adding the full path has resolved my problem Set dbAcc = wrkJet.OpenDatabase("X_be.mdb", ...

Jerry, I have tried your suggestion, which confirms there are no records returned. So I removed the WHERE statement. This then returns different records as I can use .Movelast to poulate the DrawnBy field with a different name to that for .Movefirst. I have double checked there is a record for...

I have the following code to retrieve records from an access table in another database. If I run a query using a linked table it returns all records as expected. How ever with the sql I have below I recieve the error message 'No Current Record' when .MoveFirst is executed, i.e. recordset is...

I now have IE 6.0 SP1 loaded and checked that scrrun.dll is version 5.6 but this has not corrected the problem! Does anyone else have any ideas as to what the problem might be? Thanks

I have Internet Explorer V6 but I don't think it has SP1 applied I will try this or Scripting Runtime V5.6 (depending on IT's requirements) and let you know if this works Thanks

I have the following references currently:- Visual basic for Applications Microsoft Access 10.0 Object Library Microsoft DAO 3.6 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library Microsoft Windows Common Controls 6.0(SP6) Microsoft Forms 2.0 Object Library System.dll...

I am having problems with the following FSO code. Firstly it was not recognising the FileSystemOBject but this was curred by Referencing the Microsoft Sripting RunTime Library. I now get the an Auotmation Error Run-time error '-2147023782(8007045a)' A dynamic link library (DLL) initialization...

Thanks Herman, I will try a different approach!

Herman Sorry my mistake the 1 to many relationship is setup to another table. To clarify, users are first using the mainform to search for existing logs (AENumber) for a given project (ProjectCode), which is using Filter-by-Form, the sub-form then shows a list of existing logs against the...

I currently have a form with a subform which is set to view as a datasheet which shows mutiple records for the record set on the mainform (1 to many)I am trying to select a record in the subform and have the mainform update, which works with the following code. However the subform reverts...