DataBase - refresh information
Asked By Jack
20-Nov-09 09:15 PM
I have a form with a subform. on the subform I put a text field that sums
some fields. On the main form I put a text field that shows the result.
Everything works fine when i move off of a record in the subform. I would
like for it to upgrade the amount in the main form when I move off of a field
in the subform.
--
Thank you, Jack
AcRecordsMenu
(1)
AcMenuVer70
(1)
AcFormBar
(1)
Sums
(1)
Weeble replied to Jack
Jack,
I had a similar problem and used the following code in the Lost Focus event
of my control.
'Update the menu with the new values, (Refresh).
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
y registro y querer guardarlo yo lo hago así : If Me.Dirty then DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 End If ¿es correcto o hay forma de hacerlo mejor? gracias Access Discussions AcCmdSaveRecord (1) DoMenuItem (1) AcRecordsMenu (1) AcSaveRecord (1) AcMenuVer70 (1) AcFormBar (1) - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - ¡Importante!: Colabora con el grupo.Contesta a este mensaje y dinos si te sirvió y registro y querer guardarlo yo lo hago así : If Me.Dirty then DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord,
blinking form afterupdate DataBase Hi, When i use this command: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 The form blinks with every update. Is there a way to prevent the form from Thanks, Pierre keywords: blinking, form, afterupdate description: Hi, When i use this command: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 The form blinks with every update. Is there a way to prevent t
strPlants = Me!txtPlantCode strYear = Right(DatePart("yyyy", TheDate), 2) Me!IDNum = strPlants & strYear DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 'DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 strKey = Me.txtKey.Value Me.IDNum.Value = strPlants & strYear & "-" & strKey DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 End If Me.cboProductType.Visible = True Exit
save record DataBase What is the difference between the command docmd.save and DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 both commands seem to save the record. (access 2003, vista) 10x - - Alu_GK Access Tables DB Design Discussions Alu_GK (1) AcCmdSaveRecord (1) AcRecordsMenu (1) AcSaveRecord (1) RunCommand (1) Alu_GKWith (1) DoMenuItem (1 AcFormBar (1) With the first option it is also possible to save other objects in the save, record description: What is the difference between the command docmd.save and DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 both commands seem to sa
refresh information in that form. In the event procedure I have the following: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Is there a way once I hit the refresh button it will place that current when I print it. Thanks in advance Access Reports Discussions DoCmd.DoMenuItem (1) Report (1) AcRecordsMenu (1) AcMenuVer70 (1) AcFormBar (1) DOLE (1) PJ, What event? Since you did not indicate the date field name Time field on your main form. Just add this line to your code DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 DOLE = Now - - hth Al Campagna Microsoft Access MVP http: / / home.comcast.net / ~cccsolutions