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

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

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

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

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

Hi, I have form which call an application (*.exe). Is it possible to have a pop-up form when my application is finish running? Thanks, Le

Hi, Is it possible to give other extension when you output a report? For example, in ".dat" format. I have try: OFormat = "dat" DoCmd.OutputTo acReport, stDocName, OFormat and a message tell me that I need a format in MS-words, Rich text.. How can I correct this? Thanks, Le888

Hi, How can I migrate this problem? I copy several cells from a Excel file then I paste to a memo field in a form. However, squares appear in the memo field. Is it possible to disappear these square automatically? Also, is it possible to use these square as alignment in the memo field. For...

Hi, How can you delete a row or a column if it is empty or equal to zero? I have a matrix 256 x 600, some of the rows or columns are empty or with a value equal to zero, so in this case I would like to delete them. How can you do it automately? Thanks, Le888

Hi, I have a matrix of 256 x 600. This matrix represents a half of the matrix. So, to have the full matrix, I need to do is to copy the row and past inversely. Please see the attachment. The red numbers are the result that I want. Thanks, Le888

Hi, What is the syntaxe to search in a list box? I have try this syntaxe but it don't work. On Error GoTo Err_TrapError Dim temp As String temp = "*" & txtSearch.Text & "*" If Not (txtSearch.Text = "") Then Me.lstPart.Column(2).Form.Filter = "PartName like '" & temp & "'"...

Hi, Is it possible to add two new items into a combo box into two text fields in the same table? The code below allow to add one new item to one text field of the table but if I want to complet my table which has two text field. How can I do it? Code: Assume the combobox named : MyCombo...

Hi, Does existe a command that auto expanded the width of a column of a combox? I have try something like this... Me.cmbBook.(col)2.Width ......But, is the rest of the code? Thanks, Le

Hi, I have a text box which contains a formula. When the text box is divided by zero, it appears #ERROR in the text box. I would like it to be invisible when it divided by zero and to be visible when it has a number. Any ideas? Thanks, Le

Hi, I have a form and in the form, I have a text box : Book Suject. Then I have a combo box which has all the tiltles of each suject. My problem is how can limite the choice which link to my book suject. For example: Book Suject: Sciences Combo Box: Physics Maths If my Book...

Hi, What is the syntaxe refering to a comb box column. I have a combo box which has 2 column and I would like to refere the column 2 to a text box. Example: In the text box Me.txtColName, the control source = me.combo box name.column.[2] However, this syntaxe doesn't work. Any ideas? Thanks, Le