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 Replies
ADVERTISEMENT
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
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
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
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
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
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
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
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
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
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 4 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
Jun 1, 2013
I was wondering if deleted records to be copied to a new table?
View 2 Replies
View Related
Mar 28, 2005
;) Hey everybody,
I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...
Thanks
gunwax
View 9 Replies
View Related
Aug 4, 2013
I have a DAO.recordset called "rsSQLIn". This comes from a csv file by:
Code:
strSql = "SELECT * " _
& "FROM [Text;Database=" _
& strFolder _
[Code]....
While the validation runs a boolean keeps track of validated input and errored input.
After validation the validated input is dumped in the table.
Now what I want is de saving the errored record from "rsSQLIn" to be copied to a new .csv file.
The problem I have is that I cant seem to get the current record from the recordset "rsSQLIn". How do I reference this? I need the complete set of 24 fields being the same within "rsSQLIn"
View 3 Replies
View Related
