Search results

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

Dear Ranman. Unfortunately, the image is must. I surprised that the form needs to redraw whole thing (and its image as well) while only few small changes in textboxes...

Hi everyone My friend is asking me to help him making small Access project for luckydraw like this vid: Virtual Digital Lucky Draw System - YouTube I have built a similar one (attached db), however i got issue with form flickering. It is actually textboxes flashing when new values are writen...

Dear Pat. I hope i got your all meaning with my poor english. If you simply rename your FE from accdb to accdr, what if someone renames back from accdr to accdb? They got access to everything even VBA code too? I am not sure about "accidents" you mentioned. But just 2 weeks ago, my customer...

Thank CJ, it seems I have got only 1/2 bit of access knowledge because I dont know how to bypass it. I have disabled Access sepecial keys (Alt+F11), hide Toolbar with command: DoCmd.Showtoolbar "Ribbon", acToolbarNo ' Hide main database window The only weakness of FE accde I know, that is BE...

Dear Pat I actually lock shift_key and hide all menu/navigation panel. They are only accessible when logged in with Admin account. Let me play around with accdr... Infact, I dont (dont know) distribute FE by copy the new FE each time db open. I am curious, if FE is downloaded from server to...

Yeah, wait for him to confirm I already tried. With the link in my #3, i can only download the file with size of 7Mb. Thus, I believe it still need internet for downloading the true Access Runtime file.

My first snow falling wrote in Pascal. Random character * at the first line, insert a new line with random * again, and so on... :))

Thank CJ_London for your useful info. I develop everything on my PC will full Access, thus I will go ahead with accde. Yes, MSA means for Microsoft Access. What if my customer is already installed with full access version let says A2013/A2016 and I insist to install A365 runtime. Will A365...