Search results

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

No, they are bound controls on other subform (call it subform A). My correction: The button is not on mainform. It is on the subform A.

Hi Everyone I have a continuous subform (call it subform B) bound to table TBLTEMPNAME. There is a button on subform A what is to insert new record to TBLTEMPNAME therefore to subform B. However, before running InsertSQL I normally have to remove the recordsource of subform B to NONE , if not...

Oh, now I understand about OpenArgs, I have never known and used it. A great learning for today. Much appreciated your helps.

Thank Arnelgp I also have other button to open the form FrmProduct not in newrecord mode. Thus, how to differentiate them? Should I make a global varibale so that Load event can perform according. My bad habit is always try to minimize number of global variable unless it must...

Hi Everyone My table TBLPRODUCT have a number of records. I want to addnew record but it requires to open form FrmProduct with full records from table. So I tried with code: DoCmd.OpenForm "FrmProduct" DoCmd.GoToRecord acDataForm, "FrmProduct", acNewRec You can imagine it requires two steps...

You are an expert... it is so simple and effficent