Search results

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

Hi Everyone. Do you know where to get this offline installer? I am distributing .accde file, but I am not sure if end-user has/dont have MSA, so I want them to install Access 365 runtime. Some of their PC dont have internet access. So I wish I could send them offline installer file via USB...

Thank DB, it works for me too.

No kind of this property

Hi DB I have just found something, if you set control source as above code, the image does not show up when form open. But when you input into control source an expression: ="C:\Users\Admin\Desktop\" & "1.jpg" It shows up

Hi. Sorry, I was looking on wrong form/code. Actually I set the photo path in Control Source as below picture (I did not set Image.Picture = "C:\Users\Admin\Desktop\1.jpg") Now I want to read back the control source by VBA but I dont know which property to read, so i try to read at...

Hi Everyone. I am using unbound image (linked type) to display a product photo. To display, I set it to photo path such as: Image.Picture = "C:\Users\Admin\Desktop\1.jpg" But when I try to read the path back: Pathstr = Image.Picture I always get result: Pathstr = "(none)" How can I get the...