Search results

Hi, My property sheet has disappeared I don't know what I did. How can I make it reappears? I have try by pressing the SHFIT key but it won't work. Also, I have created a new database and open it, the property sheet isn't appeared. The icon are still there but when I press on it, it does not...

Hi, Is it posible to hide the ''quick tool menu'' beside the big microsoft button(open file, close file,etc.)? Because when I run my database, if the user click on it, the user can change my settings and even access to my database. Thanks, Le

Thanks, it works. :) Le

Hi, I have the same problem in converting my database 2000 to 2007. When I open my database in 2007, I can see all my tables, forms and reports. When comes to save the database in to 2007, I click on the file menu there were only close database or Exit database and on other options. There were...

Thanks, but where should I put the code? I have try to put after the "Application.SheetsInNewWorkbook = UserSheets". However, it did not also, I have try to put in different place. But, it don't works. Thanks, Le

Yes, I want mysheet(myTabName). I would like that Excel do automately name the tab Name. For example, I would like my tab Name : first tab (vel_01), second tab (vel_02)... Thanks, Le888

Hi, I have written a code to import data and created a new Excel work sheet. Is it possible to name the sheet`s name instead of the default name (sheet1,sheet2,..)? Here is the part of the code: Private Sub CmdImportData_Click() ' Create new workbook with three sheets UserSheets =...

Hi, I have try : If (DoCmd.OutputTo acReport)= vbCancel Then MsgBox "Cancel",vbOkOnly Else End If And it don't work. I want to replace the interne message that Access gives when the action is cancel. Is it possible? Thanks, Le

Hi, When I export a report and if I don't specified a pathway, Access suggests a pathway to export my report. And, the pathway that it suggests is c:\My documents Is it possible to change this default pathway to c:\Access\tasks Thanks, Le

Hi, I have export 3 reports to the same pathway (same folder) and I have programmed automatically. The code below works fine. DoCmd.OutputTo acReport, stDocName1, acFormatTXT, "C:\Access\Tasks\project1.txt" DoCmd.OutputTo acReport, stDocName2, acFormatTXT, "C:\Access\Tasks\project2.txt"...

Thanks !!! ;) Le

Still don't work!! Here is the code: DoCmd.OutputTo acReport, stDocName, MS - Dos, "C:\Access\Tasks\Projet1.txt" Still message shows that the format is missing. Le

Thanks, I have put in the blank : DoCmd.OutputTo acReport, stDocName, MS - Dos, "C:\Access\Tasks" This don't work, the message is that the format is not right. So, what is the syntaxe of this command? Le

Thanks, I have add the quotation marks and it gives me the message say that "Microsoft Access cann't saved this output data in a file that I have selected." Le

Hi I have a button that I click on it and it export my report. However, is it pssible to identifier a pathway automatically. I have try this code but it gives me an error message. DoCmd.OutputTo acReport, stDocName, , C:\Access\Tasks What is the problem? Thanks, Le

Is it possible when you click on the button intead just click on the program, it possible to double click on my program. I think my program is actived only on double click. Thanks, Le

Hi, I have created an executable button and it calls the program *.exe. However, it doesn't execute my program. My program is fine when I click directly on the program. Any ideas? Le

Thanks, not a bad idea !!! ;) Le

I want is to copy the last row (ex. row 60) of "sheet1" and past to the first row of "sheet2", copy the before last row (ex. 59) and paste to the second row of the "sheet 2". etc.. See The attachement. Thanks, Le

Hi, I have create a macro by save all the steps that I want do to. So, I can see what are the codes behide. Unfortually, I repete manually the same step and the code is very long. So, I wonder if someone can rewrite the code more compact and more flexible. The following code comes from the...