Search results

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

Hi @arnelgp , I meant end-user wants to change the background. They just need to click on a button, browse to picture location and OK. So they have no ability to change form's background color.

Hi @Arn Nice trick, It works very well if piture background is same to form's background. But if i want option to change background on the fly, then how I should do?

Thank Mike. The random number is just for example. The name list will be imported from an excel file, but I have not done that part yet. Let me study your code. I much appreciated your helps.

Dear Arnelgp. Let me check it out soon. I know your solutions are always great.

Thank you so much. Let me study yours in detail

The background image size is only 163Kb which i think small enough. I have tried to use Application Echo, but it does not work. My friend (and me as well) thought this is easy task, but surprisingly I dont have good solution for now