Search results for query: *

Thank you very much, I will try this. I do have some dumb questions about this. Where do I put this code? How do I set the check box so that it starts this code?

I have a form that I want opened when a y is clicked in a y/n box. This subform would allow them to fill in details of the incident. I have a button to close the form, but can't get anything to work to have it open automatically. Also, I would like it if this subform could present information...

I do have a field with a unique number that is autonumbered, and as long as it makes a distinct copy, I assumed it would be autonumbered to the next record.

No, I just want a button that will make a duplicate entry, that the user can then edit the few items that are different. I can use VBA or anything else you think is appropriate.

You were dead on right! At the very top of the code, was a NEW RECORD line. Not sure how it got in there, but you had to scroll up to see it. After I deleted it, the button worked fine. You the MAN!

OK, here is the code. And thanks for all the help. Private Sub Command127_Click() On Error GoTo Err_Command127_Click DoCmd.GoToRecord , , acNext Exit_Command127_Click: Exit Sub Err_Command127_Click: MsgBox Err.Description Resume Exit_Command127_Click End Sub Private...

Thanks for your help. I actually took a programming course 4 years ago, that used VBA as the programming language, but I can't seem to get the code into the macro builder. I think I understand what the code is trying to do, but I can't get it entered in the right place.

Thanks. I tried that again, but it failed. What I didn't mention before, because it is something I tried over a week ago, was that I have used the button wizard, and made a button that did add new record. After I save it and click on the button, it says the button click produced and...

That sounds more advanced than I am right now. Thanks for helping me. I am thinking about that advice and if I can impliment it.

Thanks for helping me, I tried that but, it did not work for me. I tried putting that code in expression builder, but it kept telling me it was invalid. I am using Access 2000.

I want to create a button that has a macro that will make a duplicate of the last record, and then the user can change one or two items? This is to save them a lot of data entry. Is this possible? I would use VBA also if that helps.

I need help in protecting my old records. Is there a way to lock old records after they are entered so that they can't be overwritten?

I am really new at macros. Can someone tell me how to make a macro button for a form that will jump the user to a new record? My form opens up into existing records and they are getting overwritten. And the users can't seem to get the little buttons down on the bottom of the form.

Thank you for your help. I think I need to be more specific. To further clarify, it is a lookup column, that gives a dropdown list of choices.

Hi, I am a pretty new Access user who is creating a financial tracking database at my work. Since I am the most technical, it became my job. I have a table with a pull down list of items. Is there a way to have multiple items selected from that pull down list?