Search results

Hi, I am using word automation to transfer info to Word documents. Two of my buttons for some reason when a user brings it up on XP in Access 2003 for some reason do not work. I can get it to work on my 2000 machine just fine in Access 2000. All my documents have bookmarks and open with the...

Code Hi Pat, I tried this and it seemed to work and I also took the code out of the other events and it seem to work so I think I got it. If Me.LockedId Then Me.LockedId = 0 Me.AllowEdits = True Else Me.LockedId = -1 DoCmd.RunCommand acCmdSaveRecord Me.AllowEdits =...

Response Pat, did you read my above post? Thanks.

Which event The click event for the button.

Yes but Ok, I am getting a VB error 2046 and something that you can't save now. Move it to before the IF and it got the rror when unlocking. Removed it and it doesn't lock but changes the value of the button. Go out and come back in and its lock but unlock it and try to lock it again it will...

Trying something Pat, I was going to try to put it in a button so it would unlock and locked based on the button like so and the field would manly be used for displayed : If Me.LockedId Then Me.LockedId = 0 Me.AllowEdits = True Else DoCmd.RunCommand acCmdSaveRecord Me.LockedId = -1...

Response My close button does this: On Error GoTo Err_cmdClose_Click DoCmd.Close DoCmd.OpenForm "frmSearch", acNormal Exit_cmdClose_Click: Exit Sub Err_cmdClose_Click: MsgBox Err.Description Resume Exit_cmdClose_Click

Ok Where do I get table def from it doesn't recoginize the data type.

oops I meant before update and its not working.

Reason I do want to lock the record but how would the user know the record locked. I thought grayed out boxes would be the result. But I did try it. One little problem I cannot uncheck that box to edit that record now. Hmm.. As far as my other post: I put this in the Form After Update event...

I guess the code goes in the click event of the button?

Does this gray out all the fields Does this gray out all the fields?

Ok I used the premise of capturing the current date in the afterupdate event of the form based on a post. Will this capture the date when the form was modified or the record. Because I exited out of one record on my entry form back to my lookup form to select another record,edited that one, went...

It was suggested in one of the posts to use the following code in Form Current event to disable all the fields on a form of the current record so when I click on the yes/no field it would disable the fields if yes or enabled if it was changed to no and stay that way unless clicked on again. I...

Question How do I do this: set the control bound to the field to true. I am trying to employ the same concept.

Followup What kind of field would this be ? Yes/No? Do you know how I would access Form update?

Is there a way to enable/disable or lock/unlock all the fields on a form for a record so if one person puts in a record, clicks the button and locks the fields and leaves the database and someone else comes in and brings the record up they can look at the record but cannot make changes to it...

I understand Doc Man, I understand the Case statement is the major hindrance in the whole code. I would be willing to redo the bookmarks at this point. I am just totally frustrated with the whole thing because if I knew the case statement was going to cause this much problems I would have...

Maybe I am confusing you. Hi Doc Man, I see what you are saying more clearly. Right the only difference is the numbering of the array entry and I see the validity of either option. Problem is using the recordset option is after the first set of code from above which has the bookmarks...

Followup I agree that the structure could be better. I guess the first thing in my head looking at the snippet of code I had a question about is one do I have to specify the same mentioned bookmarks over and over as before. I don't think so but I am not sure. Two, I don't see anywhere where it...