Search results

I realized that you are the author of the file FixCascadingCombos. I studied this file during weekend. I placed your transparent field over the combo and rearanged the positions of all controlls so that they are all on the same line. There is the same flicker. I can not post any changes made on...

I repeat - there is no difference. I already forgot about my database. I am talking about your case. For example the regular cascading combos are used in Northwind Traders Developer database. For example edition 2.3 in the form frmOrderDetails. This database was made by access developers so that...

They are dependent on each other in any case. But as I said before - even in the case of second file (cboxs) where there is a regular cascading combobox - there is a flicker. In order to observe it one has to create a new record and place the mouse pointer on any other record above.

If user knows the dependent but does not remember the parent then he can start typing the dependent and the dropdown will show it (if SAYT is intergrated into the code). After update of the dependent the parent will be chosen automatically (as shown in my database with SAYT). The original...

I think it has to be in the after_update, not click event. One does not want to clear dependents before updating parents. Another point - I don't think I have a regular cascading combobox since I want to be able to choose dependent by SAYT not only after but also before choosing parent. The...

I think in my tablet I used the first part of this sentence.

I do not know how this idea came to my mind. But it does remove the flickering. The idea was to separate the creation of a new record from its update or whatever happens to it. I do not understand my last sentence but it worked!:) Or maybe using recordset is a cure. I do not know.

Private Sub Form_Dirty(Cancel As Integer) 'On Error Resume Next If Me.CurrentRecord = 1 Then Exit Sub If Me.NewRecord Then Me.Recordset.AddNew Me.Recordset!ItemID = Nz(DMax("ItemID", "TestOrders") + 1), 0) Me.Recordset.Update End If End Sub I removed the supressor of errors by this new code...

I've removed the flickering from the continuous form, but I don't understand how it works. Perhaps there is another, clearer solution, or a different approach. I'll get to the details. I created a cascading combobox with a progressive filter (search as you type) in continuous form. However, I...

PS, For me it works even at the bottom. Maybe becuase I have a borderless pop-up form with a borderless pop-up child form. Also the code makes form corners square (not rounded). This is 100% replacement to MVF.

Thank you! After understanding your file it worked! I have to do some work to stop timer from repeating. On top: Dim t=0 On load: t=0 And in timer event: If t = 0 Then #If Win64 Then Dim hnd As LongPtr #Else Dim hnd As Long #End If hnd = GetActiveWindow If hnd <> Me.hwnd Then DoCmd.Close...

I do not understand how this code only would work. I attached it on my pop-up form timer event. Nothing happens when I click outside the pop-up. Please advise the solution.