Search results

small positive update: it seems that when I set a recordsource on the subform based on a Access query with a formparameter: "select * from sqlview where ID=forms!frmInv!InvID" and do not use master/child (no need for of course) and never set any recordsource through VBA, the subform.current()...

as I said, I can dynamically set a recordsource on the subform f.e. in the mainform.current() event or even with a button just for testing but the problem remains. As soon as I do, the subform will fire twice on setting a rowsource on the combo I'm giving up; it has never been a problem for me...

I created a test; a mainform with - no vba - one combo with a valuelist (not even a recordset) - one subform with the same (slow) view as recordsource (same view as the subform mentioned above) - one button When I set the rowsource of the combo (to a simple value list like "1;2;3;4;5") by...

Of course I did. The subform does NOT use any of the combo's There is a lot of code in the FE, and I already deleted a lot of unneccesary "me.refreshes" (there are none left) and there is no reference to the subform ("me.subform.form.xxxx") anywhere in the mainform VBA. I also checked if f.e...

Ive been doing this for at least 15 years in all kinds of frontends, never had this occurring. It could be that this has always been the case, but I never had such a slow subform (as I said; I'm not the builder) so maybe it has never occured to me that the subform gets refreshed (and it's not a...

Some combo's are depending on others, f.e. after you choose the invoicereceiver, you have to choose one of the (1 to many) adresses that belong to that specific receiver (ánd only active adresses, not old ones). I have to limit the adresscombo to the adresses of the receiver, it would not be...

tnx for your suggestion. I could do a workaround where I copy the values locally, but that would require a lot of effort to keep the data synced with SQL (multiuser), and I'm fairly sure that setting the combo.rowsource on Enter/Exit to a local table would still get the subform to refresh. But...

Access-FE on SQL-db, multiuser. I have a mainform (invoices) with some 15 combo's in which user selects data (f.e. invoicesender, invoicereceiver, paymentterms etc) There is a subform (invoicelines) that is linked to the mainform (on InvoiceID, master/child). The recordsource of the subform...

I normally use decimal(18,3), but this program is not made by me. I'm supporting it. The problem is fixed by doing the field * 1,0 trick in the view, then refresh the link. After that, the view can be changed back to normal

I also tried numeric(5,2) which also didn't do the trick Float does not seem to help either And I tried your trick with the 1.0 but then the view is not updatable anymore which it needs to be since it's a datasource for a continuous (sub)form (or I'm forced to rebuild the form just for this)...

I have a table in SQL tblOrdOutput which holds an integer field. This field needs to contain decimals from now on, so I changed the field to "real" on SQL server. When I link the table directly, the field displays as numeric/single in Access. There is a view that read info from this table...

So after some testing, my final solution for this problem: strSQL = "select from vwProject WHERE 'some filterstring'" set rst = currentdb.openrecordset(strSQL) rst.movelast if rst.recordcount = 0 subform.recordsource = "" else subform.recordsource = strSQL endif This results in a...

Yes There is nothing in the Currentevent in both forms In short: subForm.Open() me.recordsource = "select * from vwProjects Where ProjectID=" & MainForm!ProjectID MainForm!txtSearch.AfterUpdate() strFilter = 'dynamically get some fields and build a strFilter like "[field] like '*value*' OR...

omg, of course :rolleyes: I removed all conditional formatting but it does not make a difference (also, with CF enabled nothing is wrong as long as de form displays records)

What's CF? (probably something obvious). The main form has no recordset so there's nothing to connect. I could set a recordset as a workaround, but how would I connect Master/Child to a "[field] like '*value*' OR [field2] like '*value*' OR etc" situation? Also, as I stated (but maybe not...

I have a MS Access client with a SQL database with linked tables and views. In some forms I display records from a SQL view which works good. The form is a main form with a subform. Mainform does not have a recordsource, the subform has a recordsource which is a linked SQL view that is...

I already used a tool like that to search for 'gebeurtenisprocedure' while working on an English environment/office setting, that helped a lot to quickly find all problempoints

No that's not true. 'Gebeurtenisprocedure' is what Access puts in the eventhandler when you a setup/assign VBA code to a event (button/form etc) in a dutch environment. Next to that, I do not use any macros, not even autoexec. The longterm fix was to set my Windows to English, open the...

I have a Accessclient/SQLserver setup running at a company where all users work on a RDP-server. Some users have their Windowslanguage set to English, some have Dutch (as have I). Every users gets their own client in their windowsprofile through a batchfile, ensuring everybody always has a fresh...

Well...sounds reasonable. I was not aware of the functionality of ( ) The second pass the code tries to add the same fieldobject and not the value to the dictionary which triggers the error. But what determines when the code interprets rstMeta!Metavalue as a value or as a field? I have not...