If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record protecting
hey pros,
I have a record protection question. If a user enters data in a subform that is a continueous form of records i wanted to lock that particular record after the txtDate is entered. Does anyone know how I can overcome this?? |
#2
|
|||
|
|||
Record protecting
Hi
I'm only a beginner here but I use some thing like this. In the OnCurrent [Event Procedure] set the txtDate field and as may others as you need to disabled if it meets criteria. 'example Private Sub Form_Current() If Me.txtDate.Value = True Then Me.txtDate.Enabled = False Me.Otherfields.Enabled=False Me.Otherfields.Enabled=False Else Me.txtDate.Enabled = True Me.Otherfields.Enabled=True Me.Otherfields.Enabled=True End If End Sub You could use either the Enabled or Locked Values for the fields. HTH John "TimT" wrote in message ... hey pros, I have a record protection question. If a user enters data in a subform that is a continueous form of records i wanted to lock that particular record after the txtDate is entered. Does anyone know how I can overcome this?? |
#3
|
|||
|
|||
Record protecting
Hey John thanks for your response.
I am using a continueous form as a subform and I would need it to disable these fields as the user navigates from record to record. So that way if they should come onto a record where the date is populated they would not be able to edit it. But if they come accross one where the date value is false, then they could..... ...ya know? "John" wrote: Hi I'm only a beginner here but I use some thing like this. In the OnCurrent [Event Procedure] set the txtDate field and as may others as you need to disabled if it meets criteria. 'example Private Sub Form_Current() If Me.txtDate.Value = True Then Me.txtDate.Enabled = False Me.Otherfields.Enabled=False Me.Otherfields.Enabled=False Else Me.txtDate.Enabled = True Me.Otherfields.Enabled=True Me.Otherfields.Enabled=True End If End Sub You could use either the Enabled or Locked Values for the fields. HTH John "TimT" wrote in message ... hey pros, I have a record protection question. If a user enters data in a subform that is a continueous form of records i wanted to lock that particular record after the txtDate is entered. Does anyone know how I can overcome this?? |
#4
|
|||
|
|||
Record protecting
Hi Tim
The example provided does exactly that. Use locked instead of Disabled tho, its not greyed out. Regards John "TimT" wrote in message ... Hey John thanks for your response. I am using a continueous form as a subform and I would need it to disable these fields as the user navigates from record to record. So that way if they should come onto a record where the date is populated they would not be able to edit it. But if they come accross one where the date value is false, then they could..... ..ya know? "John" wrote: Hi I'm only a beginner here but I use some thing like this. In the OnCurrent [Event Procedure] set the txtDate field and as may others as you need to disabled if it meets criteria. 'example Private Sub Form_Current() If Me.txtDate.Value = True Then Me.txtDate.Enabled = False Me.Otherfields.Enabled=False Me.Otherfields.Enabled=False Else Me.txtDate.Enabled = True Me.Otherfields.Enabled=True Me.Otherfields.Enabled=True End If End Sub You could use either the Enabled or Locked Values for the fields. HTH John "TimT" wrote in message ... hey pros, I have a record protection question. If a user enters data in a subform that is a continueous form of records i wanted to lock that particular record after the txtDate is entered. Does anyone know how I can overcome this?? |
#5
|
|||
|
|||
Record protecting
This will work on a single form, but I cannot get it to work on a continueous
form that is set up to look similare to a datasheet. "John" wrote: Hi Tim The example provided does exactly that. Use locked instead of Disabled tho, its not greyed out. Regards John "TimT" wrote in message ... Hey John thanks for your response. I am using a continueous form as a subform and I would need it to disable these fields as the user navigates from record to record. So that way if they should come onto a record where the date is populated they would not be able to edit it. But if they come accross one where the date value is false, then they could..... ..ya know? "John" wrote: Hi I'm only a beginner here but I use some thing like this. In the OnCurrent [Event Procedure] set the txtDate field and as may others as you need to disabled if it meets criteria. 'example Private Sub Form_Current() If Me.txtDate.Value = True Then Me.txtDate.Enabled = False Me.Otherfields.Enabled=False Me.Otherfields.Enabled=False Else Me.txtDate.Enabled = True Me.Otherfields.Enabled=True Me.Otherfields.Enabled=True End If End Sub You could use either the Enabled or Locked Values for the fields. HTH John "TimT" wrote in message ... hey pros, I have a record protection question. If a user enters data in a subform that is a continueous form of records i wanted to lock that particular record after the txtDate is entered. Does anyone know how I can overcome this?? |
#6
|
|||
|
|||
Record protecting
In design mode,
Access the properties of the subform and enter the details in the OnCurrent field, Event Procedure. Regards John "TimT" wrote in message ... This will work on a single form, but I cannot get it to work on a continueous form that is set up to look similare to a datasheet. "John" wrote: Hi Tim The example provided does exactly that. Use locked instead of Disabled tho, its not greyed out. Regards John "TimT" wrote in message ... Hey John thanks for your response. I am using a continueous form as a subform and I would need it to disable these fields as the user navigates from record to record. So that way if they should come onto a record where the date is populated they would not be able to edit it. But if they come accross one where the date value is false, then they could..... ..ya know? "John" wrote: Hi I'm only a beginner here but I use some thing like this. In the OnCurrent [Event Procedure] set the txtDate field and as may others as you need to disabled if it meets criteria. 'example Private Sub Form_Current() If Me.txtDate.Value = True Then Me.txtDate.Enabled = False Me.Otherfields.Enabled=False Me.Otherfields.Enabled=False Else Me.txtDate.Enabled = True Me.Otherfields.Enabled=True Me.Otherfields.Enabled=True End If End Sub You could use either the Enabled or Locked Values for the fields. HTH John "TimT" wrote in message ... hey pros, I have a record protection question. If a user enters data in a subform that is a continueous form of records i wanted to lock that particular record after the txtDate is entered. Does anyone know how I can overcome this?? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Next Record keeps making new record even if nothing entered on for | Groucho | Using Forms | 4 | November 1st, 2005 12:49 AM |
Access and appending records | rmoritzky | General Discussion | 2 | October 20th, 2005 11:58 AM |
Copy/Paste Record Problem | Rob Parker | Using Forms | 4 | May 12th, 2005 09:24 AM |
printing label for record that has focus on the form | babs | Setting Up & Running Reports | 0 | February 4th, 2005 06:01 PM |
A problem opening a form so it doesn't add a new record | John Doe | New Users | 1 | January 10th, 2005 03:38 AM |