Search results

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.

Yes, much appreciated the issue is gone. About the images in gallery, some of them are still used by other forms, but some are not. I really forgot which one is using because they migh be similar name. Is there any way to check and remove unused images?

Thank Doc_Man Yes, that Close button was set with "Quick Style". The preset formats are nice, but it seems I have to get rid of them

Hi Everyone When navigating through records, the button Close is appeared with strange bold shadow. When I move cursor to this button, the shadow disappeared. Other buttons have no problem at all. I am using O365 64bit, window 10 Pro (19044.1348) I attached sample db, please help to take a...

Hi Somehow the RecordLock properties of form B is set to All record, that mighe be the cause. I have treid to remove it, it then works well without any error

Hi DB Please find attached db. The code is in form FrmSub_PhieuNX

Tested, it is not dirty

Yes, I am trying to copy a record from A to B. There must be something wrong elsewhere. This is not first time I encounter this problem The screenshot when subform B recordsoursei s not set not NONE Forms' properties

They are 2 different tables. Actually subform A (continuous) bounds to TBLPRODUCT, subform B (continuous) bounds to TBLTEMPNAME. Subform A has controls: Txt_ID, Txt_Qinfo_Code, Txt_Qinfo_Pname hold value of field ProductID, ProductCode and ProductName. Button on subform A is to select product...