Search results

Changing BE extension looks great trick. btw: How do you hide tables in BE? If someone has BE PWD, will he be still able to access BE hiden tables? Thanks,

Hide Navigation menu, Hile acToolbarNo, Disable SHIFT key. Anything else, PAT?

Dear all. I have structure (type) in VBA and an array Private Type Item_property Itemname As String ItemMaterial As String End Type Dim ItemArray() As Item_property And I expect to init ItemArray like: ItemArray = { ("Knife", "Steel"); ("Ruler", "Plastic"); ("Ring", "Gold")} but It...

Ah... not every keystroke make data change, ex arrow keys. So the change event is the best to use

I just realized it, yes, it does search when paste data by mouse.

Hi @MajP I have applied your code to my application, it works and help to avoid the error 2185. However, I would prefer a blank window on my subform if filter returns no record. So in my case, i found a solution that is moving the searchbox to parent form and apply filter like...

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?