Search results

Not quit understand what you want. Can you put in red the field with problem in your database. Give me an example what you want to do, I can find the vendor part number (in which table). Le

Can not read your database... Le

Is this what you want... Le

See if this help... Le

How do you open your form2 by a button? If yes, then put DoCmd.Close at the end of the instrustions. Le

Can you post your database?? Le

Don't quite sure what you want?? Ansentry's cade is corrected. If you enter a new record in the company name "ABC" then you click on company addresse details, a form pop up with an ID 4 where the main form as also an ID 4. So, what is the problem?? Le

You have to put a condition. Private Sub LstBox_DblClick(Cancel As Integer) On Error GoTo Err_LstBox_DblClick Dim stDocName As String stDocName = "Rpt_Route_MAIN" stLinkCriteria = "[field you want to match]=" & Me![text box you want to match with the field] DoCmd.OpenReport...

Try this... In your main form, put Me.subform name.Visible = False in the open form event. Then, create a button where you can put Me.subform name.Visible = True. So, each time you click on the button, the subform will appear. Le

O.K. , thanks for asking this question. This brings the light up. Yes, I can put 'do nothing' like an empty space in my condition statment. Thanks a lot. Le

No, I cannot remove or put it in a remark. In certain condition I need the click event of the texte box. Le

No, I have try it. Locked doesn't disable the click event. Le

Hello, How can you disabled a click event on a text box ? I don't want to use ENABLE = false because the background of the texte box comes gray. So, any alternative solution? Thanks, Le

Not sure but try this. Put on the purchase order form close event: Forms!name of your main form.name of your combo box. Requery Le

Here is an option, leave the label. Create a button and put on top of the label. Then goto the propriety of the button and put it on transparent. It is important that your button control is on top of your label otherwise, this would not work. Try it. Le

See attachement... Hope this help, Le

Hello, First, I'm very glad the web site had came back, Youpi!!! My question: Is possible to stop the Return key function at the end of a jump page? In my form, I have servel pages and I put some jump page (which separeted one page to another) . Each time, I enter data and press return key...

A combo box don't need code behide. The important is the combo box is link to the subform. This is very strange, yah, I have the same problem with the format date, but if you create the combo box by wizard. It gives a good result. See the attachment. Also, I have created a new column...

Try this ... MsgBox "Hello" & "," & """ Worlds """, vbOKOnly Le

Not quit understand what you want? See attachment if this help? Le