Search results

Тhank you, arnelgp, bob fitz for your help and helpful advice!

Тhank you again, bob! I may not have explained correctly, but what I want is when a new entry is entered in my Main form then I must enter data in my Subform (in my text fields, that are on mine). If I do not enter data and do not create a new record in mine Subform, then I will receive a...

Thank you for the advice, bob fitz. Another thing I need is a warning message if I try to leave the Main form without making a record in the subform textbox.

Hi all, I need some help, pleas. I have main form with name "frmMain" and linked subform with name"subfrmSubForm". I need to make the subform "subfrmSubForm" and my filed "txtField" on subform required I . So if I have created new record on my main form "frmMain" I am obliged to fill in my...

Thank you for your help. I appreciate it!

Hi all, I need to marge 2 queries while removing duplicates My first query "qry1" has 3 fields: "id", "name" "hm". My second query "qry2" has the same fields as "qry1" I need to marge these two queries while removing duplicate records in field "id"

Thanks, arnelgp. I added the code you wrote to me, fixed my typos and now the code works!

arnelgp, you are correct. I added in the code: Cancel = True If answer = vbYes Then Cancel = True me.numbeрOfPproducts.setfocus I need to do one more thing whit cbo_PSD (which is located on subform "fm_PSD") and cbo_TypeOfProducts (which is located on sub sub form...

Cronk, thanks for the help and advice you gave me.

I want to have a second option that allows the user if he made the wrong choice to be able to go back and not save the current record. Because if I only have the first part of the code: If Not Nz(Me.cbo_PSD, "") = "" And Nz(Me.numbeрOfPproducts, "") = "" Then MsgBox "Please, enter the...

Hi, all. I need some help, please! I need to combine two messages with the corresponding commands. First I want to execute this command: Private Sub Form_BeforeUpdate(Cancel As Integer) If Not Nz(Me.cbo_PSD, "") = "" And Nz(Me.numbeрOfPproducts, "") = "" Then MsgBox "Please, enter...

Thank you very much for your help and for the advice you gave me, CJ_London, pbaldy I don't know why I tried to do some sorting in mine VBA when it is so logical to sort in my query from which the report is generated! I fixed the mess I had created and now everything is working properly! ☺️...

Hi all, I need to Sort my report by 2 fields. Now when I open my report it is sorted by date. But I want next to sort by second field sort "name" I filter my report with this code: Private Sub cmd_Report_Click() 'On Error GoTo Err_Handler 'Remove the single quote from start of...

Hi, arnelgp. Thanks for the reply. My Rowsource type of combo is Table/Query Thank you for the advice and help. I changed my SQL and I added the part of the VBA code and now it works perfectly!

Hi all, I need some help, please. I have list with names in the combobox and a search button. When I press the search button it shows me a report of all the names with this code: Private Sub cmd_SearchClick() 'On Error GoTo Err_Handler 'Remove the single quote from start of this line...

Wow. Thank you, theDBguy. Тhat is exactly what I need!

Thank you, theDBguy. Аnother adjustment needs to be made to work properly. When filtered as an example the name Paul on RecordCounter shows just 2 records, but when you move to next record it is load fourth, fifth .... record. And how to load blank form with no records showed into RecordCount lable?

I need to hide the nav counter because it just looks better visually. Тhere is no other reason.

I made another DB with this code, but here the problem is that when you make filter selection it select record but the Record counter label shows all record http://www.utteraccess.com/forum/index.php?showtopic=242748

My DB is 2019 version. Is this db v1 does not work again?