vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

  

Home  Contact Us

Order Software
Search vb123

 Smart Access  
The Magazine that Access Developers loved to read and write for is back
Article Index Here or
Purchase Here

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Sign up here

Get Good Help
If you need help with a database, our Australian Professionals could be the answer
Read More

  The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and zip backups, change startup options,  compile, shutdown database
Read and Download

Access > SqlServer 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

Like FMS Products?
Purchase them from us and get a free Workbench or Smart Access  More

The Toolbox
Libraries of software that we regularly import into our projects.  More..
Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...


 

 
Next Tip    Confirming Changes To Records

Users will sometimes make changes to important data and not be aware that they have made those changes.  The following subroutine can be used on most forms to come up with a confirmation message.

Open the form in design view

Select the menu item View ... Code

Go to the very bottom of the code and cut and paste the following

Private Sub Form_BeforeUpdate(Cancel As Integer)

' Confirm with user that this record is to be modified

  Dim updRecord As Byte 

  updRecord = MsgBox("Confirm Amounts record change", vbOKCancel, "Record Modification")

  If updRecord = vbCancel Then 

    Cancel = True   

  End If 

End Sub

You should now get a message every time you change or add a record.

Try out our popular Access shareware Graf-FX  
 http://www.vb123.com/graf/

 

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals