i need help regarding copying previous data in a table (as a cloning method).
i have a form with continous records. near each record, a button was created that opens in another form which contains various fields.
in order to facilitate time, i created a button on the second form to be able to copy previous data for the respective records on the first form.
but the problem happens if there are 3 fields all of them have to be filled in to be able to perform the copy operation.
for example:
port = rs!port
vessel1= rs!vessel1
vessel2 = rs!vessel2
rs.movenext
rs.edit
all fields must be filled that is port, vessel1, vessel2...and if only port and vessel1 field is filled, this cannot be copied for the other records.
can anyone give me suggestions about how can i make it in a way that it copies data irrelevant of what fields have been entered.
I would like the text from the previous field Invoice_Contact copied into the field Invoice_Contact of each new record created. I think I can use CTRL ' - but would like it done automatically if possible.
Field location: Form = PatientUpdate - Subform = F_Invoice - Field = Invoice_Contact
The form and subform are linked through: Pat_ID
The subform is based on the table called Invoice with Invoice_ID as the primary key.I tried several variations of this DLookup from examples I found on the web but the field comes out with "error" in it and its flashing!
Hello there, I'm having a problem very much like the one described by this user (http://www.access-programmers.co.uk/forums/showthread.php?t=113742&highlight=SQL+blank+spaces) where an SQL statement I am using to read data from one table and copy it to another is filling the remaining field space with blanks.
I didn't notice until a VBA module I worked on later on which was to read data from the new table and copy the selected record into a form said it could not find the records. The code:
Do Until blnFound = True Or rs.EOF 'DEBUG: answer = MsgBox("ok", vbYesNo) 'DEBUG: MsgBox rs("Account Name") If rs("Account Name") = strAName Then MsgBox "DEBUG: FOUND " & rs("Account Name") blnFound = True End If
rs.MoveNext Loop
The record selector just goes straight to EOF because rs("Account Name") never matches strAName (as strAname has all those damned spaces after the useful data).
I wondered if perhaps there was some way to use the code in the other thread to read the length of useful data and then chop off the garbage spaces afterwards, but I'm worried it would be incredibly slow when running through the thousands of records. Also, the field has legitimate spaces in between words (most of the account names are two or three words in length).
strASQL, strField and strValue are arrays and this SQL statement runs in a loop, as this is part of a search form for multiple possible entries. It all works fine except it always adds those damned spaces :D
I am cloning records in Access 2000 and once a record is cloned, I want to give a record number such as if I clone record with autonumber = 23 the cloned record will be = 23-a and if I clone 32-a will be given id of 23-b. This should be for any record within the database. Right now when I clone a record is given a new unique autonumber. Is there a way to acomplish that? If so how? I think this maybe done through vba but I have no clue how and where to start.
Can someone help me with this... I've got a main form with 6 subforms. The main form is associated with the "one-side" table. Each subform is associated with its own "many-side" table. What I would like to do is be able to click a button on the main form to make a copy of the record and all associated records in the "many-side" tables, but obviously with the new records having a different primary key. What is the best way to go about doing this?
Newbie Need help !!!!!! downloaded a template from microsoft for contacts played around with the form to suit myself... the problem i have is when i enter any thing in the text box this is cloned to all records this is happening with all text fields im not a programmer so plz go easy!!!!!! thank you
Newbie Need help !!!!!! downloaded a template from microsoft for contacts played around with the form to suit myself... the problem i have is when i enter any thing in the text box this is cloned to all records this is happening with all text fields im not a programmer so plz go easy!!!!!! thank you
im creating a fault logging databse, i have a form that shows all the "machines" details, (including its previous faults in a subform) i have another form for inputting new faults. what i want to be able to do is when you click on the "log new fault" the form will open up with some of the same details as the machine i was just looking at. e.g. it will auto copy over the "machine number" and "machine serial" thanks
I am creating a database where I want to have a table that has references to another table.
I have an ID field in both that are linked. I want to be able to on creation of a new record in this new table have it grab the ID field from the other table.
I am trying to copy the data from one table into another table. I then wanted to update the table where it is copied from. This data i then wanted copied into that table in another row.
I have already asked this question before, but only one person responded, and it was not what I was looking for.
I would like to create a code that takes(copies) each record's data from a field and paste it into another existing field within the same table. I have about 2000 records... Your help will be highly appreciated.
It will have to be a VBA code or macro because I have to alter the strings that are copied before they are pasted into the other field.
Hi: I am looking for some guidance in doing the following: I have a tableO that contains a list of objects that have associated attributes, specifically a list of system_names (object) and the associated attributes (additional fields in the table) that include port_name, port_direction. Think of each one of the records as a template that will supply data to another table, called the Instance table (tableI). The concept is that the user can populate the template with various objects and associated ports, and direction. The table cols are; PK|FK|system_name|port_name|port_direction|
The data for this table is manually entered via an associated form.
At some later time, the user want to make a copy of an object(e.g. a record in tableO) by populating Table I (the instance table). The first few fields of tableI are named identical to tableO. Table I contains additional fields that further refine the template, by adding a object_property field, and a port_direction_property field. Table I looks like: PK|FK|system_name|port_name|port_direction|prop1|p rop2
The forms interface allows the user to fill in the fields in the TableI (intance table) directly, or, lets the user scroll through the list of objects in the template table, and chose a template, copy the fields:system_name|port_name|port_direction into the same fields in table I, and then add values to prop1 and prop 2 manually.
I made the combo box control that will list the objects from the object column of the template table (table O) and make the desired selection. I have a radio button adjacent to the combo box that when clicked, will copy the selected record and designated fields from the template object table (tableO), into the same fields of the instance table (table I). The instance table is displayed on an adjacent form.
After the fields are copied to the instance table, the user can type in the data into the additional fields (e.g. prop_1, prop_2), and complete the record.
I do not know how I can do the 'copy' from tableO to table I when the radio button is pushed. I know to allow an action when the radiobutton is 'clicked'. Table O and tableI are not currently related.
Can you provide some guidance? Thanks a lot for your time J
I'm looking to include a button on a form that opens a new entry in another table and copies some field entries from the first table into the second table. I tried an append query, but it seems to be unable to be displayed in a form. I just want to copy data from one form to another. Thanks.
Hello All, Does anybody know a away of copying access data into other applications without the header row. An example being if you copy access data into excel it includes the header row in the spreadsheet. I often have to copy access data into industrial application software but usually paste into excel first (to get rid of the header rows) then from excel into the application. I would like to eliminate this step if I could but not sure how to copy without the header row.
I have a form on which I have asubform. This form is based on a query. I would like the user to be able to add/and update information from excel to this form. When I try to copy from Excel and paste them or try to overwrite the eisting data, I get the following error: " You cannot add or change a record because a realted record is required in tabel "benchmark".
Can anybody tell me how to fix this? thank u.. Stacey
i have a form THE OREDER FORM and on it there is a subform that stores a list of codes and corresponding products for a particular order.
Now what happens is that sometimes ORDERS have the same product codes, so what I wish is to see if it is possible in same way or another to copy the data on the subform to create the next record as the previous one, and thus avoiding re-choosing all the products.
This is surely just going to be a simple dim statement or code.I have 2 forms, one is plancontrol and the other is contacts. The plancontrolform holds a record of contacts for different forms - the contacts form is merely a seperate form to choose which contacts you want to add. (it was to messy keeping it all on one)The contacts form uses cascading combo boxes to choose a contacts. This all works fine but after a contact has been chosen, i want to (through a command button) add it to a viewable list. Once the user has selected all the contacts they want they can close the contacts form. The names will be automatically entered into the plancontrol form. This is not my normal type of database as it is linked to Otulook, therefore some of the rules i abide by i cannot!!Any ideas? Should i (and how do i) keep adding the names to plancontrol as i go along, or just do it all in one go at the end? p.s. plan control is a continous form.thanksKev
I have an invoice set in a lovely form using Microsoft Access. Each of the invoice there is an option on the top called Paid, ones I check the paid it will stamp it as paid, how do I make it such as, it will copy the paid ONLY record into a summary cheat, which is a report? It have to be copied into a table of course, but I want to copy from the entire invoice which include
Invoice numer, data, name, addres,s blah blah, all I want to be copied is just the number, the name and the total balance and I want that information only to be copied into the table by clicking the Paid check on the form. My other question, how do I delete THAT PERTICULAR record that was copied from the invoice into the new table? Thanks in advance.
Please if possible? Could you explain it as easy as possible with me with as much as examples and easy to read? I am a little slow, thanks. I thank you all again for your help in advance.
We have saved image in the database as OLE Object. It is showing “Microsoft Photo Editor 3.0 Photo / Package” in the table. We want to save these pictures as external file in Jpeg format. Please help us to solve this problem.
Does anyone know, when having selected the filepath of a MS Word file in a textbox, how to copy the contents of the Word file and place into a memo field of a table?
TBLInvoice which contains to fields relative to the question UseDefaultDescOfServices = Yes/No Type DescriptionOfServices = Long Text Type with Rich Text Enabled
And second table called TBLCustomerPOs which contains a field DefaultDescriptionOfServices = Long Text Type with Rich Text Enabled
What I am trying to do is if the UseDefaultDescOfServices = Yes then copy the data in DefaultDescriptionOfServices to DescriptionOfServices and make the field read only and turn off the boarder on the field. If it set to no then the user can enter his own data, turn on boarder and make the field editable.
However I am failing at the first hurdle, i.e. I cannot copy the data. Below is what I have tried to do but it doesn’t do anything.
If [TBLInvoice]![UseDefaultDescOfServices] = -1 Then [TALInvoice]![DescriptionOfServices] = [TBLCustomerPOs]![DefaultDescriptionOfServices] End If
I have a field that has a description of the project I'm working on, which has client information on it. I want to take all 600 of those records and copy them to fields in the same table, so that I can remove the client information, which will allow me to pull whichever of those two I need when I run a query.
I want to be able to copy the data within a selected field and then place it into a fresh database is this easily done?
my second questions is i have several fields which need to be merged into one 'Address' field as currently i have data with Building Name, Number, Line1, Line2, Line3, County, Town, Country. This is required to be merged into one field how would i do this?
Not all fields have data is there a way to put a space between each of the current fields when merged as well?
I am using access 2007 and cannot seem to find in the field properties.I need to input data in one field in a table and it appears in a field within a different table.
I have two identical access databases. I copied the master file to my desktop to work on it while someone else was in the shared file. I edited about a hundred rows in the Data Entry table (the records exist in both files), and now I want to copy those changes back over to the master file without messing up any of the other data. I'm not sure what the other people changed in the file, I just know what records I have that need to be copied over. Again, they exist in both files, I just want to overwrite the records in the other file with my updated records without affecting other data.
