Search results

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...

Yes, I have never used VBA to open the form in design view mode.

My customer wants to change the form's background color overtime, so the text color should not be fixed. I seem I have to store these colour values on a local table. btw: Any difference bwt DoCmd.Close acForm, Me.Name, acSaveYes and acSaveNo I usually use acSaveNo when closing forms

Hi Everyone, I have simple task but I have not configured how to do it efficient. I make color picker box for end-user to change a textbox color in any color they want by vba code Textbox1.ForeColor = 'somevalue' This color should be kept on next time the form open, so I tried to save it...

Hi Mike Currrently, there is no need to remove the winner ID. I actually didn't think about that, but it would be great if we can consider it as an option. let split the work into 3 parts: 1. Generate 5 uniqued ID (ID1 to ID5). They could be 5 random IDs, or one random ID and 4 ID are "nearby"...

Dear Mike Thank for spending your time on this topic. I know Dlookup function takes long time. How do you think about step 2 and 3 in post #17 ? I am doing the code to check them out.

@arnelgp . Much appreciated your helps. I tested with few images, the flickering is minimal, i think it acceptable. btw: To select and dispaly random subset from TBLNAMELIST, I think about steps: 1. Generate 5 unique ID number from 1 to N with N = Dcount("*", "TBLNAMELIST") - Run rand() 5...