I have designed a report named report by Recruiter. I have made a form called frmRecruitmentR eports, on this form I have created a pair of combo boxes .
1.Beggining Date (both are unbound)
2.Ending Date.
A query called recruitment query
The table being used is tblRecruitment the Field were criteria is initcontactdate
Argument:
Between [forms].[frmRecruitmentR eports].[BeginningDate] And [forms].[frmRecruitmentR eports].[EndingDate]...
eimbert
Last Activity: Aug 30 '07, 02:14 PM
Joined: Jul 18 '07
Location: DC
-
Printing From a Form Selecting drop down box
-
I have also used the Code for deleting a record and I get an error " The command or action Deleterecord isn't available now. -
Thanks for your patience and help . I used the code for editing you gave me. I created a Command button on the actual form the data entry is being done on and named it (Edit). I have used the code below to lock the form , and to be able to edit it. When the form is opened all the fields are locked(good) but when I click on the cmdEdit button the fields remain locked. I have saved and closed the form various times but records are still locked. I haven't...Leave a comment:
-
Im very new at access and I really don't know much of VBA programming. So Im just looking for an easy way to control the data entry process. Can I create a Command Button and lets say we call it (Edit) and from there you could work in edit mode for that form? A (delete) Button etc. I was thinking about running These command buttons from a Main Form Menu. I just dont know the language to make this work correctly. If you have any better suggestions...Leave a comment:
-
Thanks for the advise. I have used this code to lock all fields in current form. Once the first record is created the code doesn't allow any editing or deleting. The problem I have now is how to make changes to that record at a later time.
Any Additional advise will be highly appreciated
1. Private Sub Form_Current()
2. If Me.NewRecord Then
3. Me.AllowAdditio ns = True
4. Me.AllowDeletio ns = True...Leave a comment:
-
I have a similar problem , Could you pls write the code for unlocking the record so I am able to change data so I can save and update the record.
--------------------------------------------------------------------------------Leave a comment:
-
I have a similar problem , Could you pls write the code for unlocking the record so I am able to change data so I can save and update the record....Leave a comment:
-
How to lock a field in a record or make it read only
Hi, Im fairly new in the Access world. I would like to know how I can prevent users from changing data entered into a specific field of a record. Once I have completed the data Entry they should be able to see the information but not be able to change it.
No activity results to display
Leave a comment: