Recent content by June7

Need a related dependent table to hold each estimate cost items. And use a subform.

I don't use Hyperlink field type. I use a normal text field and build correct hyperlink string. I don't see any code in your file. How do you expect Hyperlink field to be populated? Your hyperlinks in form work for me. That example uses Rich Text formatted textbox and href HTML tag. Access...

Is textbox set with Hyperlink formatting? Are you using Hyperlink field type or just a text field? You want the same hyperlink value in every record? This is not necessary. Can just build hyperlink string in an UNBOUND textbox ControlSource. Or set up a button with URL. Start another thread...

Usually BeforeUpdate event is used for data validation. I never allow empty string in fields so I would not set control equal to "", but to Null.

If instructor expects use of DLookup() then go with it but domain aggregate functions can cause slow performance in query and on forms with large dataset. Referencing combobox column is better - combobox RowSource has already queried the data, DLookup() is a second query for same data. As for...

Can you provide db for analysis? Follow instructions at bottom of my post.

Ask again, did you read post #6?

VBA certainly does accept brackets in most cases. But not in form name for either DoCmd method.

Review https://support.microsoft.com/en-us/office/introduction-to-access-programming-92eb616b-3204-4121-9277-70649e33be4f#:~:text=1%20If%20the%20property%20sheet%20is%20not%20already,macro%20that%20the%20wizard%20created.%20...%20See%20More.

It's in the general module and behind frm_ber_AanmaakBereiding. Posted code is not quite the same as either procedure. Laurens, can't use Me reference in a general module. That will trigger a compile error. That function is not called by another procedure, maybe a macro does. What steps...

I am not getting that error but as noted, not filtering. I found MajP's demo db (https://www.access-programmers.co.uk/forums/threads/search-as-you-type-with-in-combobox-instant-filter-combobox-itself.311342/#post-1691895) and it (as well as Allen Browne code) is designed to work with a solo...

Look the same to me. Instead of Eval() function and Is Not Null, use: Not IsNull([Forms]![frm_ber_AanmaakBereiding]![Rcp_Prd2])

This filter only applies to task_list_id field? Why repeat "task:"? I type a number and neither form filters, although I see flickering on both like something is happening. I've never used custom classes. May offer advantage because you want to filter subforms. So don't know if Allen Browne...

Advise not to use popup input parameters as cannot validate input. Refer to control on form.

So you tried Parameters? Exactly what issue did you encounter - error message, wrong result, nothing happens? Post your attempted SQL as text, not image. Are you outside U.S.A. using non-US date?