Search results

Hi Chergh, If the name of my Excel file is "myfile.xls" , what is the name of my worksheet ?( I have only one worksheet in this file) Daniel

Hi Chergh, Thanks a lot, it works Have a nice day Daniel

No , I have no idea how to do this. 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

I am using access 2007 but I have found a solution: I can change the specifications when I am importing a Txt file. (I have there the "advanced tab" Btw thanks for your help Daniel

This is where I have a problem. When I am exporting a file, as for example a .Txt file , I have the first message box with " select the destination for the data you want to export". I click "ok" and I am receiving after a small message box with the following text : "choose the encoding for...

Thanks for your reply but: I have exported it manually but where can I find the "design/manage export specs?". In "saved exports", I can only edit the name and there is no other button

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

Thanks, it works Daniel

But the names "Title" and "size" are the name of the fields in my table. 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 Aikea, No, it doesn't work. I still have the same error message. Daniel

Thanks for your answer but I have still another problem: I am trying to import a DBF file from this directory: "c:\Internet\Download" . the name of the file is "Peardat.dbf" and the name of the table in access should be Peardat . The command is :DoCmd.TransferDatabase , "dbase IV"...

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 Bob, Thanks, it works Have a nice day Daniel

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 Bob, The .db is too long but I think that I have found the solution: I have added in the code: "Me.FilterOn=False." I don't know why because it was working without this code in access 2003 Daniel

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