MySQL Forums
Forum List  »  Microsoft Access

Re: Converting Hyperlink Fields from Access to MYSQL
Posted by: Lisa Anderson
Date: January 11, 2006 01:16PM

Hi Sebastain,

*** Answered my own question ***
I'm using Access 2000 and the FileDialog object will not work with it, you need to be using Access 2002 for it to work. From another newsgroup, I now see that you must use the API to perform this function. Here's a link to some sample code:

http://www.mvps.org/access/api/api0001.htm

Darn the luck, the FileDialog option sure looks a lot simpler.

*****************************************************************

Thanks for your comments. I'm close, but not working yet. I found the Microsoft Office 11.0 Object Library and clicked on it and inserted the code you suggested.

When the code runs, I get a message "Compile Error - Method or Data Memeber not found", and FileDialog is hilighted in the code. I think my machine is not really accessing that library, although, it is still checked off when I look at the References again.

Do you have any idea of what I might need to try to get the code to really 'see' that Object Library?

Thanks,

Lisa



Edited 1 time(s). Last edit at 01/11/2006 03:01PM by Lisa Anderson.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Converting Hyperlink Fields from Access to MYSQL
2704
January 11, 2006 01:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.