Search results for query: *

Hi Geoff, the content of the cell A1 was yet a hyperlink in my previous test. So, we have to fing another way. Anyway, thanks for your help. Best regards, J-L

Hi Geoff, I tried the following body text variable setting. bodytext = Sheets("Sheet1").Range("A1").Value The cell A1 in Sheet1 was containing the hyperlink. Unfortunately, this doesn't work. The hyperlink address has been considered as text in the Notes message. Other...

Hi, I would like to create and send a Notes message using Excel VBA that is including Hyperlink instead of using attachments. I have yet been able (thanks to Tek-tips) to create a Notes message with attachments and send it to people but this is an heavy solution for the Notes Server disk space...

In some MS Access 97 applications I developped in the past I was using a VBA code to create a ODBC linked table. Here is the MS Access97 code. Dim tdfLinked As TableDef Dim ConnectString as String ConnectString =...

In some MS Access 97 applications I developped in the past I was using a VBA code to create a ODBC linked table. Here is the MS Access97 code. Dim tdfLinked As TableDef Dim ConnectString as String ConnectString =...

Hi, I finally had my problem solved by copying the file "mscomctl.ocx" in WINNT/system32 directory. I don't know why that file was not installed previously. I will keep your comments in mind but how do you implement your recommendations in case of a mde type file. That was my case...

Hi, I have developped an Access application that is using the Format and Chr functions in his code. That application works perfectly well on my PC. Unfortunetely, on some PC's, the program stops and shows an error message saying that the function Format is not recognized or unknown. I cannot...

Dear Astrid,Reedew, I finally used an "on error / Resume" statement to loop until the table is available in order to avoid opening the form while the query is not fully completed. Thanks for your help, vaneujl

Sometimes an error occurs in my application when I open a form which is showing the records of a table. That table has been created just before I open the form using a create table query. It seams that the make table query execution is not completed when the user try open the form. Is there a...

How can I control the backcolor of a field of a continuous form according the value? It works when this is a single form using the 'on current' event. It works also in a report using format event. But using a continuous form, the back color will be the same for all records whatever the value of...