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.
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?
Let's say that there're 2 workers: Worker A, and Worker B, and they are fixing some engines. There's 2 different engines: Engine A, and Engine B. And these workers are fixing these engines for all day, and in the evening they have to register how many engines they've fixed.
And my job is to design Access database for them. I thought it will be very easy to do; I've created table with columns: Date, Worker, Engine, Quantity - so every day Worker A and Worker B can register, that they have repaired some amount of Engines A and Engines B.
But there's a problem that I also have to register how many Engines have arrived to the factory, and how many of them weren't repaired on time (E.g. 15 Engines A have arrived, Worker A fixed 5, Worker B fixed 5 so there's 5 engines left for tomorrow)
I've figured out that I should somehow create table IncomingEngines with columns Date, Engine, Incoming, Fixed, Undone (field Fixed should be completed automatically every day for every engine - it would be a sum of engines A and engines B fixed by worked A and worker B - so I could fill Incoming field manually)
It's easy to create this kind-of Query, but I can't add column to querry, or edit it.
I am new in using MS Access. We have this thesis that checks the attendance of the professors and then sends the ID number of the professor to MS Access. I am using smsenabler as the software to encode the ID numbers to the database.
The problem is that, I want to transfer the ID numbers to specific table for the professors name. I don't know how to do it. And I can't make the ID numbers as primary keys because it duplicates every time the professor scans his/her ID.
I have two tables set up and am trying to transfer a record between two. I understand that the best method is to maintain one table and use fields to make the record appear in either based on the field but at the moment need to maintain the two until I have more time to merge etc.
I am receiving the following error: Syntax error (missing operator) in query expression 'Cardsmaintainedbyfacilities.33CAccessCard'.
Code: Private Sub Command151_Click()On Error GoTo Err_Handler Dim strSQL As String strSQL = "INSERT INTO ExitingStaffData (ExitingStaffID, ExitingStaff , SupervisorDetails , ExecAccessCard , IDAccessCard , 33CAccessCard )" strSQL = strSQL + " SELECT Cardsmaintainedbyfacilities.id, Cardsmaintainedbyfacilities.ExitingStaff ,
[Code] ....
Works fine for all other lines (especially when I delete the line from the code). Just gets stuck on that line. I have checked both tables and the table and all associated data match - its a yes/no data type (same as Execaccesscard and IDCard). Just that one line crashes.
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.
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)
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.
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????
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
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.
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!
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?????
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.
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.
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.
I'd like to to import some large oracle tables from a remote server using "DoCmd.TransferDatabase..." on a daily basis. Currently, the system works, but my database is getting quite large (800 Mb) and I'd like to split off the tables to a back end database.
Is there a way to import directly to the back end database? The postings that I've seen seem to imply that one must first import the tables into my front end, then export them into the back end. Does that sound correct?
I'm at home right now, but will give it a try when I get to work. It just seems like there's got to be a more direct way!
Jon Mulder Department of Water Resources Red Bluff, CA
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.
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?
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.
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.
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?
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
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]
