Search results

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...

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 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...

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

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...

Changing color of records in a form Hi, Is is possible to change the color of some records in a form? I would like to change - for example- the color of every 10th record in my form. Daniel

Hi, I don't understand why, when I am opening some forms, I have at the button of the form a few boxes with filter, record and search and in other forms I don't have those boxes. Daniel

Hi, I have tried the following code: SendKeys "%(^U)" The purpose is to stimulate CTRL+ALT+U (all 3 keystrokes should be hold down together) but it doesn't work. What 's wrong? Daniel

Hi, I have in an access form a table with many records. Let say, I have a record with reference "abcde" in field 1. I have also an Excel file with the same references. I would like when clicking in my access form in field 1 on record "abcde" , that this record would be deleted in my Excel...

Hi, I have the following code in an form: Dim appExcel As Excel.Application the purpose of the code is to open an excel file. When I am running the form, I am receiving the following error: " Compile error user defined type not defined" Where is my error? Thanks for help. Daniel

Hi, I am exporting a Txt file with the following command: DoCmd.TransferText acExportFixed "MySpecsName",etc... It is working fine. But how can I edit the "MyspecsName" specifications. I can't find it anywhere. Not in saved exports, not in macros nowhere. Thanks for help Daniel

Hi, I am trying to insert into table 1 the fields "title" and "size" from table 2. I have tried the following syntax Set dbs = CurrentDb() dbs.Execute " INSERT INTO table1 (title,size)" & "SELECT * " & "FROM [table2];" But nothing happens. Thanks for help. Daniel

Hi, I would like to import a *.Dbf file in a new table in my program. The problem is that I don't need to import all the records but only those from record 120 till 180. Could somebody help me please. Thanks Daniel

Hi, I was using my program in Access 2003; since, I switched to Access 2007, I have the following problem: I have 2 printers attached to my computer. When I am using the command " DOcmd.printout", I can only print with one of my two printers. (It prints depending what is my default printer)...

Hi, I had in access 2003 the following macro in the autoexec module: Function copy database() Dim fso As Object Set fso = CreateObject("Scripting.FilesystemObject") Application.Echo True, _ "Copy of the database is made." fso.copyfile Application.CurrentDb.NAME, _...

Hi, I have installed Access 2007 and I have tried to run my program written in access 2003 and 2000. It seems to work with a few bugs but my biggest concern is about one particular form. When I open it, I can see the headers but no data. Of course the query from this form is not empty. At the...

Hi, I don't know if this is an access problem but since I am only encountering this problem in access, it could be. In access, when I am printing a report from within a form with the code : " DoCmd.OpenReport" , the printer begins to print immediately the first report but when I am trying to...

Hi, I have a *.csv file with 7 fields delimited by 6 commas . The code to import the file in a table should be : DoCmd.TransferText acImportDelim, , "abc", "c:\abc.csv". The problem is that I can import my *.csv file but in my new table , I have only one field "F1" with all my data (with...

Hi, I was using Access 2000 and WindowsMe. I have installed it with WindowsXp and I have encountered the following error : In a form, I have a date field with date() as default. When I was pressing the minus key or the + key, the date was changing with one day. Now it doesn't work anymore ...