Search results

Thanks, MajP, but can I build this controls in a main form?

Here is the new db v1 guys

Thanks MickJav, I will look at it

Sorry, now I will create new DB

hi, theDBguy. Thanks for replay. The file is absolutely new. I made it just for the example. If I set the Navigation Buttons to "Yes" (Property Sheet) everything works perfect. P.S. Is there another way to load a blank form except Data entry set to "Yes"?

Hi аll, whenever I try to use this code and set Navigation Buttons to "No" (Property Sheet) it says record 1 of 1 no matter how many records there are and the nav buttons do not work. What is wrong with the code and can it be made working? Private Sub Form_Current() Me!txtResult =...

I admit it. I hadn't tried that. ☺ Thank you, arnel !!!

Hi, I am trying to changer the background color of unbounded combo box when when a selection is made. The form is in Default view - Single How it possible to be done. I am trying with Conditional formatting, but I fail.

No, I need this form to by Single. Thank you for your help,June7. I will try to find out where my mistake is with the NavigationButtons property

Тhank you for the advice, June7. Now it works. I have another similar problem with another filter form with combo box to filter into subform. The subform is not linked to main form. On the Main form I have only unbounded combobox with the codes: Sub SetFilter() Dim LSQL As String LSQL...

Hi, all I use that code http://allenbrowne.com/ser-62.html to filter my subform. It works great, but I want to make some additions: 1 - On Property Sheet I want to set "Navigation Buttons" to "No", because I want them hidden; 2 - I make custom buttons with text box to display the records with...

The error is 2465 - MS Access can not find the the field "fm_PSD" referred to in your expression. Yes, arnelgp, I am trying to add new record to the sub form This part of the code highlights in yellow

The form "Inspection" has a subform tab control page "fm_PSD" with control "Code". I need this control name be filled with my selection from combobox in 1st form "Type" - If Me.Type = "KP" Then Is that possible?

Hi all, I am tring with a cobobox (afterupdate) when I make selection to open another form "fm_Inspection" with where condition and I need to apply OpenArgs to subform "fm_PSD" on the opened form with this code: If Me.Dirty = True Then Me.Dirty = False End If If Me.Type...

I thinking about it. You're right, Colin. The new record is not saved. Thank you, Colin! I add at the beginning of the code: DoCmd.RunCommand acCmdSaveRecord and it is works Thank you to you too, vba_php

Here's a simple one DB_v1. I made it up now. Тhe names are different. So when I make selection on combo box "TypeOfCheck"on the subform "sumfm_tbl_Inspections" and choose "By Registration" I want to open form "fm_tbl_Object_Inspection" to the new created record

Hi, all I'am trying to create a record on a form, make select on the combo box and then open another form with this code: Private Sub Combobox_AfterUpdate() If Me.Combobox = "Name1" Then DoCmd.OpenForm "fm_Inspection", , , "[InspectionID]=" & Me.InspectionID Exit Sub End...

Here is my big mistake. I didn't realize I had to remove Default value from the table! I am I am sorry about that! Now the code is works perfect! One BIG thanks to you, Micron!!! 🤗

I dont know whats going on but this code doesnt want to work. It will completely break my nerves. Here is the DB with the last code: Private Sub Form_BeforeUpdate(Cancel As Integer) If Not Nz(Me.cbopsdCode, "") = "" And IsNull(Me.numberOfpsd) Then MsgBox "Please enter the number of...

My mistake. I forgot to add And Nz(Me.textboxName,"") = "" but it still doesn't work