Copy And Append A Record

Feb 28, 2012

I have followed the development of Access from the early beginning, and even before the early beginning with databases like Q&A, Foxbase etc. I have survived with Access 2002 for a long time. However, the unavoidable string of events has given us more and more complex systems (for the noble purpose of making life easier, I assume). In my particular case I now have an up-to-date system (Access 2010) that I do no handle. My impression is that also the experts have trouble. I am now close to discard Access 2010 as too complex for my simple needs.

Here follows an example of a database that was easy to construct in Access 2002 but which I have major problems to reconstruct in Access 2010: The database in question shall keep track of expenses. The database have fields like date, project, type of merchandise, description of merchandise, price, name of store, notes, hyperlinks.

On opening the database I want a search screen (a form) that is exactly identical to the records I am going to produce (except that all fields are empty). On the search screen I put a search topic (e.g. the name of a store), and then initiate the search by pressing a fast key. The search result generates a number of records, I move on to the last one, I copy it, and on the copied record I do the necessary adjustments. The whole operation is done in a matter of seconds. The procedure is functional, and it gives me what I want.

I have made some "work around" procedures that bring me to the final touch, namely to copy/paste the record.

View Replies


ADVERTISEMENT

How To Copy Linked Records (append Query?)

Jan 16, 2008

I have attached an image of the 2 tables concerning my question.

The main "transaction" table is the tblAssessments and a linked table tblRisks drives a subform - showing multiple Risks per assessment.

The field "OccupantID" identifies the facility where Assessments are done (there are other tables, of course).

I am using an OccupantID "00000" to store templates - pre-filled assessments with most common options selected.

I am trying to develop code and/or query or SQL that would do this:

copy all templates (records from OccupantID 00000) and corresponding sub-records from tblRisks into the same tables, but under a different (selected by user) OccupantID.

I have no problem just using an Append Query (actually a SQL statement in VBA with variable parameters), but that only lets me copy into 1 table - so I can copy just the tblAssessments records.

but how do I then copy the tblRisks related records and make sure I attach them to the correct AssessmentID?

View 5 Replies View Related

Copy Button In A Form To Copy Fields To Other Fields In The Same Record

Sep 23, 2005

Hi there,

Can someone help me on this issue?

I want to copy Postal Address Information to Visit Address Information wthin the same record, in my Contact Database that I am building at the moment.

I want to copy 4 fields to 4 other fields within the same Record.

This the current code I use for the Copy-button:

---

Private Sub cmdCopyFields_Click()

Dim v1 As Variant
Dim v2 As Variant
Dim v3 As Variant
Dim v4 As Variant


v1 = Me!Field_a.Value
v2 = Me!Field_b.Value
v3 = Me!Field_c.Value
v4 = Me!Field_d.Value


RunCommand acCmdRecordsGoToNew

Me!Field_e = v1
Me!Field_f = v2
Me!Field_g = v3
Me!Field_h = v4


End Sub


---

The underlined part (acCmdRecordsGoToNew) is false part of this code, because it copies the Adress Info to a new record, instead of copying it in the same.

-Is there someone that can help me with this problem, to make the copy-button in the Form run properly?

-Are there other options to achieve te same?

I have put in a attachment, to give you guys a visual example of what I mean.



Thanks in advance,

Quinten

View 3 Replies View Related

Copy Record In DataSheet And Then Jump To New Record

Apr 26, 2007

I am running A Form.
I have created it that I if I Double Click on one of the fields, it automatically creates a copy (which is run from a Query).
That all works fine.
My problem is that my Table has 500 Records and I want the Form to jump straight to the New Record after it creates it.
Here is my Code:
Code:Private Sub USName_DblClick(Cancel As Integer) DoCmd.OpenQuery "Copy_Drug" Me.RequeryEnd Sub

View 2 Replies View Related

Forms :: Copy Existing Record To New Record?

Dec 24, 2013

I have the employee data record... I want copy of the same record to insert in table but with different employee id and Site through forms. StaffNo is the primary key.

For example

existing record
StaffNo, Site, Name, hiring date, etc
AKA-111, 10, John, 25-10-13

new record
StaffNo, Site, Name, hiring date, etc
ALM-123, 14, John, 25-10-13

View 13 Replies View Related

Tables :: Copy Table Record To Another Record?

Mar 18, 2014

I have a database for staff to request checks to be cut. I have one table with a group of regularly used payees & addresses. A second table stores data for each individual check request. I need to be able to copy a record from the addresses to the check request. I do not want to add all addresses to the address table, as it is only for commonly used payees. So from the check request table, I am able to lookup a payee, which opens the address form to display the address. I need to be able to copy the displayed address to the open check request form.

View 3 Replies View Related

Copy From One Record To The Next

Jul 10, 2007

In the attached db I have a form I use in datasheet view to show data. I have an attached subform that the user updates. The user opens the subform by clicking on the + sign to open the subform, the updates the fields clicks the + sign again to close the form. Then repeats for the next record. What I would like to happen is when the user clicks the + sign again to go to a new form is to have the data from the fields below to auto popualte the new form instance. I could do this with a continuous form and it worked but the users would like to see the data in a datasheet design. Is this possible? Thanks...




Me("Type").DefaultValue = """" & Me("Type").Value & """"
Me("Severity").DefaultValue = """" & Me("Severity").Value & """"
Me("EventStatus").DefaultValue = """" & Me("EventStatus").Value & """"
Me("AdminDate").DefaultValue = """" & Me("AdminDate").Value & """"

View 1 Replies View Related

Copy Record

Aug 5, 2005

I have this form that contains a good number of bound fields. The behaviour I would like to add to this form is, upon the press of a button, a new form would pop open (same form) as a copy of the current. This would make entering in multiple items with very few differing fields much easier.

I don't know a good way to do this. I mean I could list out each control, enter it in a new row in the database, and then open the new form pointing to that record, but that seems ridiculous. That would be like 500 lines of just gathering the data and inserting.

So I decided to cycle through all the controls, pick out the types I need, such as textboxes etc, and then get the value from that and put it in a new entry. So I would end up getting the name of the field in a variable, (named field), but I am unable to extract the value from the form from this string. Something like _ Me. & field & .Value _ really doesn't work. Anyway I can use a variable to get the value of a field?

View 3 Replies View Related

Copy Record

Dec 9, 2005

Hi,
I have a form ('A') for editing new records in table 'T' . I want to be able to copy data (just some fields) from another record to this new record.

This was my plan:
On this form 'A', I made a button "copy another" that opens a form 'B' that should show all the records from tabel 'T'. User select a record and then all the necessary fields will be copied to the new record in form 'A'.

However, the first error starts when I open this form 'B'. I get the errornumber 3211. The err description is (I have to translate because I have a dutch versoin). "The database engine can't lock the table 'T'. Table 'T' is in use at the moment by another user or proces".
How can I make this work? I understand that the table is in use, because form 'A' is using the same table.

greetings
Nelleh

View 3 Replies View Related

Copy Record From 1 Table To Another

Aug 29, 2006

Hi Everyone

I wonder if anyone can help me with code that i can use to copy a single record from table1 to table2

that i can use in a subroutine.

Thanks in advance to anyone that may offer some help

Kindest regards

Tony

View 1 Replies View Related

Creating Copy Of A Record

Feb 8, 2006

Hi,
I have a Edit Form, where users edit the customer information. I want to add a Button which creates another copy of the same record in the table.
How Can I achieve that? any suggestions?
Regards
-KJ

View 4 Replies View Related

Copy And Create A New Record

Dec 5, 2006

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!

View 14 Replies View Related

Copy Some Data From Previous Record To Next

Apr 12, 2006

Hi
I need to copy some data from last record to next(New record), when a user clicks a button on a form. I don't want to copy all the data.

An example would be booking in items from an invoice:
Company would be the same
Invoice number would be the same
Product code would be different
quantity would be different

Hope this makes some sence, and i'm not being stupid:rolleyes:

Andy

View 1 Replies View Related

Copy Current Record To Different Table

Dec 4, 2006

Is it possible to copy the current record on a form to a different table?
Example:

Form Name = Training Orders bound to a table with the same name.
2nd Table Name = History

I need to export certin fields from the Training Orders Form into the History Table. Below is the way I am trying to make it happen, but it does not work.

With Me.RecordsetClone
.AddNew
![Forms]![History]![Last Name] = Me.[lastname]
.Update


Me.Bookmark = .LastModified




End With


End Sub

View 1 Replies View Related

Copy Part Of A Record As Value In Another Field

Dec 14, 2006

Im using the UPDATE Query in Access

UPDATE MAT_Clean SET FCODE = 'BC', NOTES = 'HC RAMP'
WHERE FCODE='BC HC RAMP';

Instead of typing what needs to go into NOTES everytime, how can I specify whatever comes after 'BC' to go into NOTES? Use 'BC *'?

Thanks!

View 5 Replies View Related

Copy Info From Previous Record

Jul 20, 2005

Suppose I have a customer database. Is there a way if I click on a button, it will create a new record and copy some of the info from the previous record?

View 1 Replies View Related

Sending A Copy Of A Record To Another Table

Jul 20, 2005

Is it possible to send a copy of a record to another table already created? if so what is the sql statements to do so or any other ideas that you might have.


THANKS!!!!!!!!!!!!

View 1 Replies View Related

Forms :: How To Copy Fields From 1 Record To The Next

Aug 6, 2013

I have fields on a form for the Date, the Start time and the Finish time. These won't change for the next 120 records. So, upon opening a new record, I'd like the Date and times to appear there already. But here is the crux: After about 120 entries, the date and Time changes, for the next 120 entries. So, once the 'batch' is finished, or I close access, the values do not need to be remembered until I enter a new record.

I copied something like the following from a book and tried running it with various modifications, just for the Date to start with, but no luck. (It did strike me as too simple for something, clearly, as unbelievably TRICKY as my problem...) I did find quite a few posts on this here but none seemed to work for me, or made sense to me in the slightest. (I did mention that I'm a complete rookie, didn't I?)

Private Sub Acquired_date_AfterUpdate()
Me!Acquired_date.DefaultValue = "'" & Me!Acquired_date.Value & "'"
End Sub

View 7 Replies View Related

Modules & VBA :: Copy Record From One Form To Another?

Nov 14, 2013

ok so I have two forms open: One is a SP Bookings form with a subform SPDetails Query subform. The other form is the not connected/related SP Contacts Query form, to which users enter Full Name weight age ect. Need to copy the names of the new customers Full Name to the Lookup Contact Column in SPDetails Query subform. I got this far, with my trial runs are commented out. The only thing it does when I click on the button is move to new record on Sp Contacts Query Full Name and Copy the previous record. How do I get the button to copy the Full Name from form SPContacts Query.Full Name to the SPBooking Query.subform SPDetails Query Subform.LookupContact

Code:
Private Sub Command52_Click()
Me.Full_Name.SetFocus
DoCmd.RunCommand acCmdSelectRecord

[Code].....

View 3 Replies View Related

Forms :: Copy From Previous Record?

Jun 2, 2015

I found and pasted some code which copies records from the previous record on the form. Seems to work well, but I was wondering if there is an issue with the copying of the first field which is a combo box?

View 10 Replies View Related

Forms :: Copy Data To New Record

Jul 4, 2014

Currently I have created a data base and form. I am at a point where I need to copy data from one record specific field to a different field in the new record all while creating a new record.

Create a new record

Copy field in LastWeekInfo current record
to
New record ThisWeekinfo field

View 3 Replies View Related

Forms :: Copy Record Within The Subsorm

Mar 26, 2014

I have uploaded a small database. I keep track of payments for people who receive a language proficiency allowance. Usually the members receive this allowance for two years. Sometimes they receive it for one year.

Lang Level DateQuaFrom DateQuaTo DatePd From DatePd To
Hindi Inter 15-Dec-12 14-Dec-14 15-Dec-12 14-Dec-13
Hindi Inter 15-Dec-12 14-Dec-14 15-Dec-13 14-Dec-14

There is a field called NoOfPays . If this field value is 2 in the first record then I want it to insert a second record as shown above. How do I do it. I tried to append but it is not working.

Now copying the record with the maxID is not correct.

View 7 Replies View Related

Forms :: Using Combobox Value To Copy Whole Record?

Dec 3, 2014

Let's say, I'm updating a record, and I have a combo-box that says transfer and another combo-box that states "where to?" - or words to those effect.

Each record has a field for credit value and a field for debit value.

When I've finished entering the current record, I want to run code that fires the event, so, copies all the data from one record, to create a new record, BUT...

1) changes the "where to" from the old record to "From" in the new record.
2) changes either the credit or debit value, to the opposite in the new record?

I would like to do this from a sub-form. I can copy a whole record, no problem, but can't seem to change field values.

View 2 Replies View Related

Tables :: How To Copy A Record From Table A To B

Mar 16, 2015

I have a form to edit records on table A and i would like to be able to put a button on the form to copy that record from table A to table B. The code i have on the button so far is as follows:

<UserInterfaceMacro For="Command55" Event="OnClick">
<Statements>
<Action Name="OnError"/>
<Action Name="RunMenuCommand">
<Argument Name="Command">SelectRecord</Argument></Action>
<ConditionalBlock><If><Condition>[MacroError]=0</Condition><Statements>

[Code] ....

I want someone to be able to search a product for an order, edit it to reflect how many they are taking but at the same time have a button to copy that record to table B. Then after all the products have been found and copied to table B, they can print of the report based on table B and give to the factory floor so they can find the stock, run a query to clear table B and start on the next order.

I have everything working but copying the records across.

View 1 Replies View Related

Copy Deleted Record To New Table?

Jun 1, 2013

I was wondering if deleted records to be copied to a new table?

View 2 Replies View Related

Append Same Record

Dec 19, 2005

I know when you see these you will think, "What are you doing?" So, I will tell you. I have to append certain records to another table multiple times. I have a field that stores the number of times the record needs to be appended. I thought that I could do it with SQL and a loop, but I can not get it. Any ideas?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved