Recent content by lklp

Here is a sample of the fields on this form (see below). Ideally, I would like to have a Duplicate or Create New button that would copy the RED fields to a new order. That way the user don't have to re-enter the same information all over again. Hope this make sense, let me know if you need...

I have a database and I wish to be able to copy 10 out of about 20 fields into a new record automatically using a command button on a form. Similar to the way the Duplicate button or the Create New button would work but only with these selected fields. None of the fields I wish to duplicate are...

Actually I just zipped the mdb file. Should I just zip up the FE only?

I just zip the program and it is 565 KB, so I guess I can't upload it to the forum, right? Any other choice?

Hi Dreamweaver, When I click on your link, I only see an image. There is nothing for me to read. Did you meant to post something else? Thanks again!

Hi RuralGuy, This is probably a dumb question, but I am new to Access. I have already splitted the DB. How would I attach it to this forum? Thanks!

Attached are Some Screen Shots The program works fine currently, I just need to enhance it so the user can copy from any current records to avoid entering in the same type of information. Thanks!

I have a program that you can search all or a specific record. Once you find the record, you can double click on it and another form will open up with only that record's information. What I need is to have a button that will copy this record's name, address, phone number, contact info, and etc...

Thank you so much Paul! It works like a charm.

Thanks Paul, but I only see Page Footer and Report Footer. I don't see Group Footer. Can you explain further? Thanks and appreciate your help!

I have a report with Amount and Grand Total on it, but I don't know how to do Sub Total Amount by Magazine. Please see attachment for the screen shot and the report details.

Thanks for your help!!!

Hi Ted, Thanks, it works like a charm. Is there anyway, the user can select Yes or No from the Message Box? Right now, it only has an OK button. Thanks again! Private Sub cmdSave_Click() On Error GoTo Err_cmdSave_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...

Hi Ted, The codes are already in the On Click [Event Procedure], I wasn't sure how to add a message to the current codes when a user press the button the message pops up. Sorry for the confusion. Thanks!

This is probably very simple, but how and where do I add codes to the button where a confirmation message pops up? Like, "Are you sure you want to save?" or "Are you sure you want to exit?" For Example: Save and Close button Private Sub cmdClose_Click() On Error GoTo Err_cmdClose_Click...