Search results for query: *

Hi to all, not sure this can help in your case, but as you mentioned you were ready to change the message, here's a link that may be interesting for you. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vb98/html/vbprooleserverbusytimeout.asp I have never needed to modify this...

Oops, I missed out the first line of code. Even if you add the Listimage to the ImageList.ListImages collection, you should run into a "Duplicate Key" or "Duplicate Index" error as the Add method is called within a Loop and you have fixed the Index to 1 and Key to "Question". Droops

Hi Shaun Unless I am misreading the code, you seem to be trying to assign a ListImage object to a ImageList (imgvar) As you are not using imgvar elsewhere in the code you provide, wouldn't it be easier to simply call the Listimages.Add method without assigning the result to a variable ? Or...

I am not sure whether this property exists in your environment, but can you try : objworkbook.Saved = True just before objworkbook.Close Hoping this helps. Droops

Hi, just for next time. Once you have referenced the Common Dialog Control (in this case). Press F2 to bring up the Object Browser. Top Left of the screen allows you to browse for properties,methods,constants for all objects referenced in your project. Hoping this may help. Droopy

Hi, rsinj is right ! The link he provides will bring you straight to the point. IMHO : just to be on the safe side, and if you want to use other file formats, it would be safe to check the CanSave property of the FileConverter before invoking the SaveAs method. Using the code rsinj sent ...

Hi IDTstudios1, the following link should help you achieve this : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woobjfileconverter1.asp Hoping it does help. Droops.

Hello, you may try this MSDN link to get a few examples of the File System Object : MSDN - FSO Object Model The "Working with Files" section may be interesting. Or use "File System Object" as keyword for a search in this same forum. Hope this helps. Droops

Hello to all, thank you for the star, I am glad this helped someone. :-) Tek-Tips Forums have already pointed me in the right direction a number of times : It's nice to be able to give a little and not just take. Take care. Droops.

Hi, is the remote database (XFER.MDB) password protected ? If so, you would have to mention it in the : .Properties("Jet OLEDB:Link Provider String") = "MS Access" turning it into something like : .Properties("Jet OLEDB:Link Provider String") = "MS Access;Pwd=myLinkPassword" Droops

Hello, maybe (probably) a stupid question : have you tried compacting the database ? Droops.

Hi, try running a keyword search in this forum with search text "ADOX Catalog". You should get something to start on. Hoping this helps. Droops.

the ADO Connection Object has an Errors collection. When an error raises, it is in fact, a certain number of errors that are stored in this Collection. Some will stop the current process, others won't (warnings, information, ...) Usually the first error in the collection is enough to determine...

Hi, I may be answering a bit quickly here, but wouldn't the NativeError property return a valid (and consistant) number for your Error Handling routine ? Droops

RecordCount will always return -1 when the CursorLocation defined for the Connection object is either left blank or set to adUseServer. set it to adUseClient when opening the connection and test the RecordCount property once the Recordset is opened. Careful however, it may have an impact on...

Hi to all, may I ask what error message appears when the program is run ?

Hello, Wouldn't it be safer to read the registry to get this information ? HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\FullInstallVer. You would not be bothered if your customers use Non-english systems. Take care, Andrew.