Form Properties

[Waqas ali]

Hi All,

i am new developer in access. before i have developed in excel different project as my office requirement now i started developing in access 2007.
kindly cooperate with to get professional skills in access. thanks to all

i want to know form tital bar property settings, from which property we can set it. hide or unhide to title bar, minimize button, maximize button and close button how can i set them.

second: how can i prevent text fields or combo box fields to update any changes on single form all controls from users. if any user want to update or change any field data when user close it one msg should appear to save the changes if yes than change in database if no than no changes should be update in database.

regards

waqas

 

[Waqas ali]

hi
access experts pls reply soon at my below query

thanks

 

[HiTechCoach]

For Q2: I use the Form's Before Update event.

Example:

Private Sub Form_BeforeUpdate(Cancel As Integer)

 Cancel = False


' perform data validation
If IsNull(Me.CompanyName) Then

   MsgBox "You must enter a Company Name.", vbCritical, "Data entry error..."
      
   Cancel = True

End If


If Not Cancel Then
  ' passed the validation process

    If Me.NewRecord Then
        If MsgBox("Data will be saved, Are you Sure?", vbYesNo, "Confirm") = vbNo Then
            Cancel = True
        Else
            ' run code for new record before saving
        
        End If
    
    
    Else
        If MsgBox("Data will be modified, Are you Sure?", vbYesNo, "Confirm") = vbNo Then
            Cancel = True
        Else
           ' run code before an existing record is saved
           ' example: update date last modified
            
        End If
    End If

End If


' if the save has been canceled or did not pass the validation , then ask to Undo changes
If Cancel Then

    If MsgBox("Do you want to undo all changes?", vbYesNo, "Confirm") = vbYes Then
        Me.Undo

    End If
    
End If



End Sub

 

[HiTechCoach]

Q1: About the Title bar ,etc.

Look at the form's property sheet under the format tab. Scroll down to Border Style. Starting with this property down to the Moveable property you can set then to meet your needs.

 

[Waqas ali]

hi all,
thanks very much.

i got minimize, maximize and close button on title bar with pop up property setting to yes.

kindly guide me about the difference between allow edits and data entry property.

i want to do when form is called or loaded user can not edit in any field but user can edit by clicking edit button. i want to put some code in button click event. how can i do kindly guide me.

 

[HiTechCoach]

date entry = Yes means that you can not see any existing records. You can add records and view the records added since the form was opened. The mode is used you wan the user to only add records.

I use the form's Con Current Event to set the form's allow edits to no. When a user clicks the edit button it sets the allow edits to yes. The After update event can then set it back to No.