Search results

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

Hi Pat Nothing special, it is just because I was not well-aware about the recordset. I thought once new-record inserted, form's recordset points to the newest one. Anyway, I got what i want with Me.ProductID. Thank everyone for your supports.

Yeah it is clear now. I have learnt new thing for today. Btw, you said: AfterUpdate event does NOT advance to the next record. What did you mean by "next record"? Could you please more elaborate. I did not really get it.

Is that the one displaying on my form? To manipulate current record on form, I normally have to access via Me.Recordset!ProductID (seem this is a critical mistake of me), or control Textbox_ProductID if this control bounds to field ProductID. I dont even know Me.ProductID is a valid syntax...

I dont think the new record is saved to table on BeforeUpdate event. Anyway, I have followed your suggestion that using "Me.", the result surprised me: I set: rs = Me.Recordset then I got: rs!ProductID = 9, but me.ProductID = 10. Why is difference btw rs!ProductID and Me.ProductID? Anyway, I...

Hi Everyone The table PRODUCT has field image to store its image name (supposed i already have folder with images). The ProductID is an auto-number field The default image is "Default.JPG", when I edit anything on form, the image field will be set to ProductID.JPG such as 1.JPG, 2.JPG... This...

Thank bro, let me manually check and remove them as per your suggestion.