Data Transfer
Jan 24, 2007
Evening Gents.
I've created a database which is going to need a fair amount of data uploading into it (a long laborious procedure).
My initial plan to cut the work load for one person was to create 2copies of the database and split the upload in half (get two people to do it).
However, one of my tables is a parent to around 4 childs, therefore when i copy the information from this parent table in datasheet view from one db to another, it doesnt transfer it's associated data.
Is there anyway to get around this? Any advice/tips/hints would be much appreciated
(hope this has made sense, please let me know if clarification is needed)
View Replies
ADVERTISEMENT
Sep 8, 2005
Hi there,
This is my problem i am going to try and explain myself as clearly as possiable hopefull you will be able to understand me.
When i enter my data bank through Access, a mask opens or is it a form i am not too sure but i have sent an attachment with the sceen image.
Lets say i am looking for the data of John. I click on search and i find him. Now my Mask or form has sub forms in them for diffent information, i have made a large red circle on the attached picture to show what exactly i am talking about. These sub folders contain information such as gernerall information, bussiness information etc.
All this information ... data is part of john 's dataset or data record. SO what i want to do is take his data all of it and send it to john himself and he then can edit it and send it back to me and i want to check it and if i am satisfied with the data i can update the new information automatically into my database. and i want to beable to edit it myself too. i want all his data to be like a data book of john. The editing can take place it any problem such as Accesss itself or word or excell i just wan to be able to edit and transfer my data without damaging or loosing information.
My probles are as follows:
1) how to send john's information all of it
2) how to add it back to my database both automacticly and manuelly
3) how to edit his data as a whole, not bits and pices. as if it was one long report.
Thanks i hope i was clear enough
View 5 Replies
View Related
Dec 14, 2007
I need to set up an automated process to transfer data from about 25 tables from one database to another. This will happen on a weekly basis and I'm wondering what the best way to set this up is.
Both are Access 03 db files. The main database has data for a dozen or so clinics and I need to get the data for one clinic out and in to the the secondary db. The data in the secondary db will be replaced every week with fresh data from the main db. Once it is refreshed with new data the clinic will download the db from our site.
My first thought is to just export queries to CSV files and then import them in to the secondary db file. If run from a macro it could be a scheduled task. I could then import the CSV files. This could also be automated with a macro.
Any other ideas.
View 7 Replies
View Related
Sep 16, 2005
I am creating a Transport databse and got stuck into something.
I have created a master table " Vehicle Details " which inlcudes all the details of cars. Then i created two sub-tables " Vehicles in Garage" and " Vehicles assigned to Drivers". I will be using the forms ( ofcourse :) ) to enter and edit data. What now i want to do is from a master table i want to tranfer all details of a particular car either to " Vehicles in Garage" or " Vehicles assigned to drivers" tables/forms.
Is this possible ?
Thanks
P.S. I hope this is the right section for this .
View 14 Replies
View Related
Nov 4, 2005
Hi Guys,
Ok, all i want to do is that when i select a value from my combo box to be displayed in a text box, once its been selected, the value is then deleted from the combo box, any ideas????
View 3 Replies
View Related
Mar 23, 2007
I have a form with Driver details ie: Fields with Drivers Name, Payrole No,Vehicle Reg and Fleet No. When this form is filled in the form will be closed, the next forms in my db are vehicle defects which I want the vehicle reg and Fleet No: automaticly entered from the drivers detail form also a running sheet which I want the drivers name and fleet No: transfered to Automaticly. Is this possible??
Please Help
View 1 Replies
View Related
Oct 1, 2007
Hi guys, hows it going?, im hoping that someone can provide me with a solution to my problem i have spent many many hours trying to solve it, just cant seem to do it.Alright guys here it is, I run an entertainment company called Deejays Entertainment, we run over 18 and under 18 events, at these events we collect peoples details to put them on our database so we can keep them informed with new events, happenings etc etc. I currently have 1 database and inside the database is 2 tables, 1 titled "under 18s" the other "over 18s", what i want to do is have it so once a person turns 18 in my "under 18s" table it automatically transfers there data to the "over 18s" table and removes the data from the under 18s one. If someone could help me out i would be greatly appreciative and if you can explain the steps so i 5 year old could understand them that would be great as my knowledge about access is very little.Thanks in Advance.**Sorry forgot to add that i have there date of births in the database**RegardsDanny.
View 6 Replies
View Related
Nov 15, 2007
Hey everyone,
I am a complete lamen on this, I am finding. Here is what I want to do.
I have an access database file with two tables inside it: Distributions AND Plan Data
In both tables, I have the following fields:
CRS ID Number:
Plan Name:
Company Name:
Company Address 1:
Company Address 2:
Company City:
Company Zip:
Company Federal Tax ID:
Company State Tax ID:
I want to be able to type in a 3-digit CRS ID Number in my form for DISTRIBUTIONS and for it AUTOMATICALLY to find that CRS ID number in PLAN DATA and populate all these common fields using data from PLAN DATA, inserting it into the DISTRIBUTIONS table.
The reason I need it to pull the data from PLAN DATA and insert it into DISTRIBUTIONS table is because we are using some out-of-access features that require us to have all data in one table. Thanks!
View 1 Replies
View Related
Jan 16, 2008
I have imported a table from another database, and so I need to transfer data from the imported one, to another table in the database; only certain fields though. I have created the fields I want to copy the data into, in the second table. So I just need to go through all the rows in the second table, find the row in the imported table by ID, and take the data I want from it using VBA.
Does anyone have any idea what the code would look like?
View 1 Replies
View Related
Nov 4, 2005
Hi Guys,
This is my problem, i have a combo box with a list of values in it. When the user selects a value it is then displayed in a text box, but what i want is that when the value is selected is that its deleted from the combo box!!!! Is there a way around this?????
Thanks in Advance!!!!
View 3 Replies
View Related
Mar 28, 2005
Is it possible to transfer data over the internet if the BE is in one country and the FE is in another? If so, could someone explain how I would go about doing this? I'm in the Military and when we deploy it's normally to a far off country.
Thanks,
Scott
View 4 Replies
View Related
Oct 17, 2006
I have a list box which contains data about projects. It has the proNo and proName. I i want to be to select a project and tranfer it to anohter list box on the form using a command button.
I want to be to do this until i have all the projects I want in the second list box. I want to also be able to trnasfer projects back to orginal list box if i make a mistake.
You see this in some databases where the command buttons have < and > to transfer data back and forth.
How do I do this?
View 5 Replies
View Related
Jul 31, 2012
I am having a trouble figuring out how would I transfer data from one field to another. My dilemma here is that, I need to replace data in a field and replace it from another field.
That is:
I filtered FieldA to the data I want to replace then I want to replace it by the data in FieldB in the same row.
I have used query to transfer data from FieldB to Field A but all the data was replaced when all I want to replace are the "0" amount in FieldA. So how I'm I gonna do that?
Is there any easy and fast way? I've been doing it manual and it's around 600,000 records so it would take me forever to finish it.
View 1 Replies
View Related
Nov 7, 2005
Hey can I transfer data into a report wizard, to have the wizard use that data instead of the data in a table or query?? This data would come from a form.
View 14 Replies
View Related
May 6, 2007
PLEASE ANSWER ASAP!!!
I was wondering if there was a way to automatically transfer data from one table into another. Specifically, if I have two tables, one called Students and one Alumni, is there a way I can click a button or something to transfer a student's data file from the Students' table into the Alumni table? Without having to delete the student's file from Student and retyping it all into Alumni?
Also, is there a way to, for instance, type individual monetary amounts into a single entry in a table and have the total automatically summed? Like, if I have a table for Donors, and every time one person makes a donation, add that one donation to their personal information and have another field that gives the total amount of all of their donations?
Thanks!
View 9 Replies
View Related
Aug 23, 2005
This is a price check form so it doesnt need to be saved it just needs to display the part no info and quantities with price
If i enter a part no into a text box(PN1) on the main form it enters the data into a textbox(PN2) on a subform.
Im using a continuous form on the subform and the master/child link is the Part No text box.
is there a way to lock the first item to the first line and then be able to enter a second item to display on the next line.
I have made the size of the continuous form to one line in my subform but i am only able to enter one part no into the subform because when i setfocus to the PN1 textbox on the main form it clears the first line.
thanks
View 1 Replies
View Related
Mar 3, 2006
Dear All!
I'd like to ask you to help me in the following. The issue is basic I think, but not for me...
I'd like to transfer the data entered in the fields of a form into the fields of a table (that uses the same values). This table is connected with one to one relation to the table which the form bases on.
(An automatic data-transfer would be desirable. If it is difficult a button will do as well.)
Please write if you have got any good idea or solution.
Thanks in advance.
BR
xxyy
View 2 Replies
View Related
May 14, 2006
I have an on-going project and I am starting to have a problem with the DB. When open the form and search through the database I notice my total text box is not counting the options chosen.
I have radio buttons on my form that are suppose to enter an amount of money into a text box, if the radio button is clicked, and I have total text box that I set up, in a query, to add all the amounts of the various text boxes with cost informtion in them. As I scroll through the records on some of the records these text boxes are not showing, or adding values for the options chosen. Why would that happen on only a couple of records and not the whole database?
View 1 Replies
View Related
Aug 28, 2014
I would like to display a text entered in form1 (text box) to another combo box which is appearing in form2.
View 14 Replies
View Related
Jan 17, 2014
Below is the formula that I'm trying to get a value from an other Form (Pump Settings). But I keep getting an error message .
=IIf([Result1]<4.1,0,IIf([Result1]>6.5,([Result1]-[Pump Settings]![Target ]),IIf([Result1]>4<6.5,1,"")))
View 6 Replies
View Related
May 1, 2013
we have got a table with the vehicle details with a sub forms (main Vehicle Details, Subform Booking details)
we cannot allocate a car until a week previous to the dates required.
we are using a recored (To booked) that we can store all the dates in, the idea really is to have a button we can click that brings up the parameter requesting the REG PLATE for the car that when entered will cut and copy the booking details from the NOT BOOKED into the corrosponding vehicle is this possible?
I dont mind a button beside each record in the sub form but really needs to cut + copy the fields beside it
Field Names are:
FirstName
Surname
Date From
Time From
DateTill
TimeTill
Reason
View 4 Replies
View Related
Oct 30, 2013
I recently designed a new database according an old database in order to replace it. I found that I have trouble transferring the data from old to new database.
Only transferring data from one table to another
Database A: [table]![customer]
to
Database B: [table]![Client]
Field name on both are different
DatabaseA:
Table Customer:
Name,
PhoneNumber,
e-mail.
DatabaseB:
Table Client:
FullName,
HomePhone,
CellPhone,
E-mail.
How can I transfer from "Database A/table customer" to "Database B/table Client"?
View 3 Replies
View Related
Oct 7, 2014
I am working on an attendance file. I have created one MS access form and one excel sheet. On MS Access sheet I have Student ID, Date and Value. ON excel sheet I have Course, Student ID, NSN No and date.
I want data to be automatically appear on excel sheet from ms access form and after updating it or after transferring data i want these fields again empty and ready for next entry.
For example, If I type value .5 in ms access under 01-Jan-2014 for Student ID 1200001, value .5 should automatically appear in cell in ms excel sheet infront of same id (1200001) and under same date (01-jan-2014).
View 11 Replies
View Related
Sep 6, 2011
I recently added a field to one of the tables in my database. How can I transfer my existing data to the newly restructured backend?
Only 1 table has been changed to add a single new field.
View 1 Replies
View Related
Nov 2, 2011
I have one table with the following records:
Name Surname School Date1 Date2 Date3
John Smith London 12/12/11 11/11/11 10/11/11
Mary Wayne Harvard 11/10/09 12/10/13 10/11/11
I would like to design a Macro which can create another table like this :
Name Surname School Date
John Smith London 12/12/11
John Smith London 11/11/11
John Smith London 10/11/11
Mary WAyne Harvard 11/10/09
Mary Wayne Harvard 12/10/13
Mary Wayne Harvard 10/11/11
That is duplicate the records, and create another table, with all the records and each record with just 1 date.
View 2 Replies
View Related
Oct 24, 2013
Everyday I have to generate a report in excel format and I need it to be added to ms access database. I was hoping to do this on a click of a button. Basically, since i have a new data everyday it should be added to the table.
View 1 Replies
View Related
