Copy and Create A New Record

[lklp]

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 --> and create a new record with a new Record Number using the current record. This will allow the user to avoid entering in the same information again. For confirmation purposes, I would like to have a SAVE button to verify and save to the DB.

Does anyone have any inputs on how I can do this? If you would like to see the program, please let me know.

Thanks in advance for all your help and suggestions!

 

[RuralGuy]

In a properly normalized db, data *only* exist in one location and ForeignKeys are place in other tables to point to this one location. Do you have a design issue?

 

[Dreamweaver]

Copie All required Fields to varables
dIM Straddress As String Declair all varables hear

Straddress = Me![address]
Other Varables as needed

Create your new records Hear
DoCmd.GoToRecord , , acNewRec

Then Assign The Variables To There Controls Like
Me![address]=Straddress
Saves don't really use them Much but when I have had too I set a variable true\False to true if they have saved the record by pushing the button otherwise they can't move without either undoing or saying It's quite complex take a look in the examples forum

Mick

 

[lklp]

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!

View attachment Screen Shot.zip

 

[Dreamweaver]

Also totally Agree with RuralGuy.

 

[RuralGuy]

If you want to post your db, someone may offer some suggestions.

 

[lklp]

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!

 

[KeithG]

First zip it, then goto manage attachments and upload the file

 

[Dreamweaver]

This may be a lot more than you want or need but All the comboboxes relate to other tables the main table only stores the ForeignKeys.

Hope it gives you a few Idea's

Mick
http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=15627&d=1164997758

 

[lklp]

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!

 

[RuralGuy]

Either import the tables back into the FrontEnd or highlight both the FE and BE when you zip and they will both be there. It needs to be < 393 KB zipped.

 

[Dreamweaver]

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!

It was just a thought As I said all the combo boxes are related tables thought you might be able to see how it gets it's data from different tables the field names show what each related table is for each combo Just didn't work out the way I had thought IE Combo Box = Related Tables record.

not to worry

Titles Table
Towns Table
Counties Table
Types Table
Contacts
Countrys Table
CompanyTypes Table

These All Have ForeignKeys In The Main Address Book Table



mick

 

[lklp]

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?

 

[RuralGuy]

Did you do a Compact and Repair first? If it is still too big then send it to Rural Guy at Wild Blue dot Net and I'll look at it. Be sure and include specific instructions on where to look.

 

[boblarson]

Make sure to Compact the database before zipping. And, to get around the 393kb limit, just zip each part separately and do a separate post for the frontend and a separate one for the backend.

 

[lklp]

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

 

[boblarson]

Or just send to RuralGuy, as he requested. He'll help you out.

 

[RuralGuy]

Compact and repair both the FE and BE and zip them up separately and if they are < 393 KB then post them in two different posts on this thread as was suggested earlier. Or send to me. That's ok.

Edit: I'll post them back here so Bob can help too.

 

[boblarson]

- -------