Search results

Hi @arnelgp About event change remarks in microsoft site: Examples of this event include entering a character directly in the text box or combo box or changing the control's Text property setting by using a macro or Visual Basic. I think, i am getting risk if inside event change, i set value...

Again, the story is the BE's password can be retrieved by opening FE with text editor such notepad. I am not sure if new access (A365) can resolve this weakness. Anyway, Ms Access is not intended for high security application/program i think. btw: When sharing BE folder on network, we normally...

Hi Sr, Take a look at attached photo in #1, in the immediately window, the textbox is already has focus, but .Text is still not accessible. That's strange

Good addressing, I keep watching and curious to know the root cause too. Some time, my subform can paint the form without record, sometime it is totally blank, hope to know about them more clearly

I meant your code in other thread, they can solve the issue https://www.access-programmers.co.uk/forums/threads/help-with-dynamic-search-on-form-with-read-only-recordset.320126/page-2#post-1792689

Dear MajP Yes, it seem almost my case, my program has exact symptom of that topic. as @arnelgp suggested, I also tried on change event but it is same. The most strange behaviour is that the textbox is already got focus, but vba code insists asking for the focus to access .Text or .SelStart...

No, it stops at the yellow line of Txt_FnameFilter.SelStart while it goes through Txt_FnameFilter.Text without any error. But when i type ?Txt_FnameFilter.Text in immediately window the error also occurs.

Dear all I have an unbound textbox names: Txt_FnameFilter, it functions a search for each character keyed in via function: User_FnameFilterParameter (Txt_FnameFilter.text) This error occurs when no search result found. I have read about Error 2185, i understand that I can not access...

Hi theDBguy It works, The actual SQL in my case: SELECT SimpleCSV("SELECT [Designator] FROM TBLBOMDETAIL WHERE [BOMID]= 1 and [IKYPN] = '" & [IKYPN] & "'",", ") AS Designator_N, TBLBOMDETAIL.IKYPN AS PartType, Count(TBLBOMDETAIL.IKYPN) AS BomCount FROM TBLBOMDETAIL GROUP BY...

well noted for next time posting the question. Thank you.

The ID is not essential there, they can be changed, the desired data might store in a new table... The main idea is to combine the items having same type into single row with comma between.

Dear Plog, Thank for your notice, actually there data it was made in Excel, just for demo purpose.

Thank you very much, let me try these codes

Hi Everyone I want to build a query that group data as the attached picture. Can anyone please help me?

I meant I wanna add a text box on my form's header that has exactly same function to that default search box

Dear everyone. Is that possible to re-use the search box that appears on record navigation bar at botton of form? It is great as it jumps to fields on current record, and jump to next record that search criteria is met. Thank you!

Hi @isladogs Yes, In fact I have same idea and I already added a global flag to determine when we should call application.Quit on form unload (or form close). My particular app, I dont have many form, so it is easy to manage this flag. btw: Is there any thread on this site which is mainly...

Hi Isladogs, I tried your examples, they are useful. However, I found a little bug, when close your access program by right-click on access icon on taskbar (select close window), it no longer can open the example again, unless completely stop access by task manager. It seems the access...

Thank Arnelgp In fact with CJ's code earlier, I have developed my own set, and I am able to resize the box too. My trick is force user to press Shift key when they want to resize. It is not as great as yours but it is acceptable. I need to study alot more since I viewed your code but not...

I tried your db, it works like a champ. I initially had same idea, but somehow it was not working smooth. Will study our code. Thank everyone for helping me.