Recent content by le888

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