Search results

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.

Wow, amazing, he can even resize the textbox in his video. Regret that no source code.

My friend is working at event organizer, he wants to change position of company name or logo on the backdrop. The backdrop is actually an access from.

Hi all I know it is weird but I would like to know if any example or solution that able to change position of a form's control by mouse click and drag in form view mode? I studied about on mousemove event and try to set new position when event fired, but it seems to be exhausted... My end-user...

Well noted and thank you very much It works like a charm

Dear buddies Thanks for your quick helps, but seem the results are not correct. The duplicated values are not exclusive. As per manual check as below, ClassA has 3 students( A001, A007 and A008) while class B has 2 (A002 and A004) Here is your results, they are incorrect

Hi everyone I have the tables and relationship showed as below. I want to have query that shows number of student not pass (point <5) first round of exam per class Can anyone please help me? The db is attached. It is prefer to not use more than 1 query.

Bravo. I saw alot of your hard work. Much appreciated your efforts Let me study your code. (I really like your picture of angel :))

Yes, I dont allow end-user to make any design change. I just provide the ability to change a form background and certain textbox color, those changes are made via user-friendly interface such as button, colopicker with underlying VBA code. In conclusion, I will need a local table to store the...