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.
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 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.
The answer is probably in here, but I can't find it... so I have two questions.
1) On a form, I have a field with Company Legal Name and Company Trade Name, most cases the company trade name is the same as the legal name. So what I would like to do, is add a button next to the Company Trade Name field so when clicked it would automatically copy the text data from legal name to trade name.
2) Same scenario as above but with mailing and shipping address if it is the same.
I have got a form with our company's representives. This form has a subform with clients certain representives aren't allowed t contact. I would like to have a 2nd sub report with all the customers listed and their addresses with the ability to highlight one or many customers, click a button and have the customer IDs and names update to the first subform. Has anyone done anything like this?
Ok so here is the problem I need help with, I have a prices table that stores all the different price changes for each part I have in my Parts table what I need to figure out how to do is to copy the "Last" price for that part from the price table into the Price field of the Parts table or have some way of updating it automatically either by macro or what not - example:
Price Table:
PriceID (PKey) PartID (Connected to Part Number ID) Price Price Added( Date & Time when price was added so I can groupby "Last" or "Max" in the Price Query I have made)
------------------------
Parts Table:
PartID (Pkey) Part Number Price
-------------
Now how do I take the value my Price query gives me for "Last" or "Max" Price using the last date for that parts price and have it automatically get copied into the Parts Table price?
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.
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?
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.
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 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.
Ok, I'd like to appologise first as I wasn't sure that this question/problem would fit appropriately into the "Forms" forum, and also for the length of this post.
In the database I'm currently building, I have a form that is used for adding new product purchases for a given customer. So far, after much googleing and and head racking, I've managed to get everything in working order, save this one problem I can't solve.
The form uses the following SQL to populate its field list;
SELECT Products.*, [Expense Codes].[Montant de Paquet] FROM [Expense Codes] INNER JOIN Products ON [Expense Codes].[Expense Code ID]=Products.[Expense Code ID] WHERE (((Products.[Commencez Date])>=Date()));
Sorry for the french text, this is for use by a French company
On the form I have a combo box that lists the product packages available (combo 1 for reference), Prod 1, Prod 2 and Prod 3. This is a field in the products table which is linked to a seperate table called Expence Codes. This table holds my master list of product codes, and their off the shelf price in a field called 'price'. By using the above SQL, I have the price field ("field 1" for reference) on my form auto update when ever the value combo 1 changes. This is working as I would like it to.
Now for the issue I'm having. I would like to take the value from field 1 to be copied to a field in my payments table, this is to facilitate a final billing value being correctly calculated and invoice being created. However, I'm at a loss as to how to acomplish this.
I have thought of using an update query to add this information to the payments table, as the relivent record will already be created, but Im not sure if this is the right way to go. So any ideas on what I'm doing wrong, could do better or need to do are more than welcome.
Thanks for reading this far and I await any replies :)
I have linked a SQL table to my ms access database. In order to view the SQL table as read-only and still be able to update the access table I have setup a form with a subform. I know it would be a dublication of data but is there a way thru code of copying the data on the subform to my access table. I was hoping I could put a button on the form that would copy this data. My idea is after the copy is done all the information I need will be in my access table. I'm new to this linking idea and am worried I will only have half the information I need if the link breaks etc. Thanks