Search results

Hi Rx, Thanks a lot for your explanation. I found that there was a problem with my Excel file. I have modified it and now it works. But again thank you very much. Daniel

It is set elsewhere but it works with another Excel file

No it exists . I have checked it twice. I have tried the same code with the other Excel file and it works. I think this has something to do with my Excel file but I don't know what.

Hi, Hi, I have written the following program code: Dim xlApp As New Excel.Application Dim xlwrkBk As Excel.Workbook Dim xlSheet As Excel.Worksheet Dim strXLS As String strXLS = "c:\Access\Myfile.xls" Set xlwrkBk = xlApp.Workbooks.Open(strXLS) Set xlSheet...

Thanks for your advice. It works. I didn't know that you can Format a String.

Hi, I would like to convert a number in a string keeping two decimals . It works except when the two decimals are "00". For example , to convert 3.00 in a String will give 3. Even keeping 3.00 as number will give 3 I need to keep the two decimals, even if they are "00" because I have to use...

Hi, I would like to open Windows Live mail 2011 in the "New Email Window" and automatically attaching a file " The purpose is when clicking on a record in my table, this record is attached and ready to be send. I don't need to send the file automatically, because I would like to add in WLM...

Hi, I have the same problem; I have a saved import from an excell file into a table but I don't see how to edit the saved import. The problem is that I created this saved import long ago and I don't know anymore the specifications. Where can I find back the specifications of this import...

Thanks very much It is working Daniel

Now I am receiving ( after having merged the 2 queries in one query) the following error message :"The number of columns in the two selected tables or queries of a union query do not match" What I don't understand is that the 2 queries are identical, the only difference is the direction. In...

I have tried but it gives many unmatched records twice Daniel

Hi, I have two tables let say "A" and "B" . I would like to compare all the unmatched records in both tables I know ( with the query wizard) how to find unmatched records but the problem is that the wizard gives only unmatched records in one direction and not in both directions. With one...

Thank you for your answer When I click export (in "Browse for a directory module") it is exporting a report (*.rtf extension) to a directory but the report is almost empty. There is only-inside- a rectangle and the name of the directory. but not the names of the files of this directory. Daniel

I have referenced to "Microsoft Scripting Runtime " but it still doesn't work Daniel

Directly when clicking "Find Files" I have the error in VBa at this point "With Application.FileSearch" ( is in yellow) I don't understand what you mean by "Have you looked at your tools and references to make sure you are all referenced up" Daniel

Thank you very much but it doesn't work. When I am clicking "Find files " , I am always receiving the following error message: "Run-time error 2455" . You entered an expression that has an invalid reference to the property FileSearch. I have tried different possibilities: with or withoiut...

Hi, I have a folder with different files. I would like to import the name of those files in a specific field of an access table . Thanks for help Daniel

Thanks, I will try it. Daniel

Hi, I am multiplying Field "A" (2 decimal number) by Field "B" ( 4 decimal number) . The result is field "C" ( of course sometimes a 4 decimal number); Even if I use the function Round ("C",2), Access still stores "C" as a 4 decimal number. I have tried in my table to format "C" as a Fixed 2...

Hi Mike, Thanks a lot, it works .I have looked at the conditional formatting and have understood it Have a nice day Daniel