Search results

Thanks. First, where should I put this code and second, how can I use this code to call a pop-up form or where should I put instruction to call a pop-up form? Thanks, Le888

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

Can I do it automatically? Thanks, Le888

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

Yes, the squares represent the tabs in MS Words format. So is it possible to arrange these tab automatically in a memo field. Please attachement. What I have done in the memo field is I delete the tab and replace by a space. Is it possible to do this automatically? Thanks, Le888

Here is the out.txt file... 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...

Thanks, it works! But for the rows and columns which as zero, is it possible to delete them and also count how many rows or columns have delete? Thanks, Le888

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

See attachment... Le

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

Thanks, :) Le

Sorry, I don't quit understand. Here is my database. 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...

Thanks. ;) Le

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