Recent content by masa1

Good morning. Thank you for your work "pbaldy" and the code you have included!(y) I needed it, it works. Thanks to you I took the next step. Best regards.

Good morning. Thank you for the clarification, "Gasman".:) Best regards.

I know this solution ... "I know I could get this by changing the combo box property - bound column, but it's not an elegant solution." In this case, I would populate the table with the full names and I would like to stay with "ID".

Hi everyone. I have a form with a subform. The subform has cascading combo boxes cboNazwa1, cboNazwaEtapu, cboName3 and the Send Email subform. In the vba code of the Send email subform I have a string; strNazwa =...

'Hi to all. 'In my earlier post I was overly optimistic. I thought everything was good. 'However, I didn't notice the error. 'What is my problem? 'Well, I'm trying to apply the criteria to view the continuous form. 'I want to use TWO multiselect list boxes and TWO date ranges for this...

Thank you for waking me up. It was enough to remove AND ... If Not IsNull(Me.txtEndDateFinish) Then 'Less than the next day. strWhere = strWhere & "([DateFinish] <= " & Format(Me.txtEndDateFinish, strcJetDate) & ") " 'AND End If Thank you and best regards.

Hi. Thank you for reading about my problem. ...when both list boxes are empty and only dates are selected, I get an error and no results. ...in the Immediate Window; ([StartDate] >= #01/01/2019#) AND([StartDate] <= #12/30/2019#) AND([DateFinish] >= #01/01/2019#) AND ([DateFinish] <=...

Hi to all! In the database I'm trying to create, I need to apply filtering using 2 multi-select listbox and 2 date ranges. In this forum I found a code that largely meets my needs. However, I can't modify the way I would like! i.e. when I select element the ListEngineType, ListReparType ...

Hi. I could not solve the reported problem to get the result I wanted ... As a reminder I had MainForm> SubForm> SubSubForm to enter data. Then I created a continuous form through which other database clients could view the content in a short version. I wanted to use a button or text field in...

Hi Cronk. I am sorry that I took a break in activities but it caused current other matters. Thank you very much for your work. Now about the effects I got ... I tried to follow your instructions very carefully. However, the effect I obtained is still unsatisfactory. As before, if I select a...

Hello, hi Cronk. Thank you for joining the topic. I am sorry that I did not write anything about myself in the introduction to the case. Well, I'm not very familiar with database design, and actually I don't know much about it! My interest was caused by a colleague who was doing something and...

You're right, the forms work correctly, but I want to access the record from another form. And here is the problem. I want to open THIS form for editing from ANOTHER which I use as a browser! In the attached illustration, if I click cmd (1) it is OK because ID_SubForm is the first ID created for...

I hope that the attached illustrations will solve the problem.

"...or just" it opens as I would only like if first ID_MainForm > (first) ID_SubForm > (first) ID_SubSubForm but when I want to open another one ID_SubForm or ID_SubSubForm the same opens (!) ie. ID_MainForm > (first) ID_SubForm > (first) ID_SubSubForm The first version has the same effect.

Hi, I have a continuous form with a command button. I'm trying to write a command to open another form containing the main form, a subform, and a subsubform and access the record represented by ID_MainForm > ID_SubForm > ID_SubSubForm Here is my code: Private Sub cmd158_Click() Dim strMainForm...