Search results

Sorry, but it is not works. I uploaded a new one DB_v3 with the last code. Could you please, check it? Private Sub Form_BeforeUpdate(Cancel As Integer) If Not Nz(Me.cbopsdCode, "") = "" And Nz(Me.numberOfpsd, "") Then MsgBox "Please enter the number of products!", vbInformation...

I apologize for the late reply but I was at work. Тhese two codes works, but they are only the half of the task. If Not IsNull([cbopsdCode]) Then [CODE]If Not IsNull(Me.cbopsdCode) And IsNull(Me.numberOfpsd) Then MsgBox "Please enter the number of products!", vbInformation, "Atention!"...

Thanks for you help bob fitz, but still does not works. The text box numberOfpsd is not require to be completed if I have chosen from combobox "psdCode"

I am trying and trying but it doesn't work. I created а simple DB to explain what I need. In the picture I have attached I want to make it so when I have a value entered in What I want to do, shown in the photo, is remember to enter value into numberOfpsd if I got selected into psdCode. The same...

My text box is Data Type - Number. The point of what I need to do is to dont forget to enter a value in text box if I have chosen value in ComboBox. Any ideas and suggestions please

I added this code: Private Sub cboCode_BeforeUpdate(Cancel As Integer) If Not IsNull([cboCode]) Then MsgBox "Please enter the number of products!", vbInformation, "Atention!" End If End Sub It is works, but when I choose from cbo the message appears. I need when I forget to add in...

Thanks for the tip and the code correction, Micron! :)

Hi, all On the form I have combo box and text box. I want to do this: If Not [ComboBox] Is Null then, MsgBox: "Please, add in textbox" When I have chose in ComboBox and try to add something else in the subform or close form before I add in the text box I need warning message MsgBox: "Please, add...

OK, What I need to do is to create a form with cobobox to Filter data in query. when I load the form in want to be blank form. When I choose an Еmployee in the combobox I need to load all records for this Еmployee I'll look at that and try to figure it out. Thanks

Would you try to open now the DB, please?

I am talking about fm_Activity Уou don't even see a fm_Object in my demo because I did this demo for a minute so I could describe what I was talking about.

Hi, theDBguy. As I said I need to disable Record button New (blank) record on Navigation buttons on the form June7, could you please give me a little more description

Hi all, I have Filter combo box FormA with subformB. The VBA code I use for combo box is After Update even: Me.Requery The subform is with RecordSorce with SQL: It is works well, but I want to disable Record buttons New (blank) record, because if pressed I can not add new activity - The form...

Until I found the right place to put the syntax........, it was a big mess!.....(build, Criteria... build, Criteria, build, Criteria). Finally I did it! I will definitely remember this lesson! 😊 Тhank you very much, pbaldy!

Thanks,pbaldy. I looked through the table, but I can't figure out how to do it. Is it possible to illustrate with an example to make it clear , please?😌

Hi all, I have a form "FormA" with 2 comboboxes - cboMunicipality and cboCity. The cboMunicipality on Event After Update hase Me.cboCity.Requery. The cboCity on Event Row Source on Build has 2 tables : SELECT tbl_Cities.City, tbl_Municipalities.Municipality FROM tbl_Municipalities INNER JOIN...

Thank you, Uncle Gizmo! :) It is done!

I still can not do it :unsure:. Мaybe i can't explain correctly. Here's a Database to explain correctly. When I press the button "New" in Form1, I want the text box City in Form1 automatically to fill City in Form2 (new activity)

Would you give me a little more info command "Me.subform.form.txtBox2 = forms!fMainForm!txtBox1" on the button On Click "New Activity" to be placed ?

I have MainFormA with field name txtCity. With my comand button On Click "New Activity" I open popup FormB and want to add new activity but my txtCity on the FormB want to be auto populate with info from field txtCity in Main Form. How can I do that? Thanks