Help Transfering Data From On Form To Another

Jan 24, 2006

I have a tbl called table1 which has 3 fields. i have a form called form1 which list field1 for all records in table1. when i double click on field1 i want to open form2, retrieve the data from table1 using field1 as input and display the results onto form2. can this be done just using Access or do i need visual basic? i am new at Access and have not ever used visual basic. i do know java. can you tell me how to do this or suggest a book which could explain it. the access book i have does not go into this type of detail.


thanks
brian

View Replies


ADVERTISEMENT

Transfering Data, Can Any 1 Help

Feb 9, 2005

I am currently studying for my A levels and need some help with microsoft access. What I want to do is transfer information from one table in my database to another. When it transfers however, I want it to alter under a certain validation. This is what i want to do;

Admission numberArt
011649
011650 F
011651 B
011652 C
011653

This is an example of the information. The letters regard to a GCSE result. I want the grade to be transfered to a table called "point score". Each grade has a value, A* = 8 points, A = 7 points, B = 6 points and so on. When the data is transfered to the point score, I want it to just state the point score and not the grade. Can anyone help?

Cheers

View 1 Replies View Related

Transfering Data

Apr 29, 2005

Hello everyone,

I am still trying to solve the following problem:
I am trying to transfer data from one table to the other in a different folder using the follwing command:

Private Sub Commandtransfer_Click()

DoCmd.TransferDatabase acImport, "Microsoft Access", "D:DBSsewertvinsp.mdb", acTable, "tblSanTV", "tblSanTV"

End Sub

By using the above command I could be able to transfer "tblSanTV" table from D:DBSsewertvinsp.mdb to another table in a different folder but it transfer the table and data together. But that is not what I want to do. All I want to do is to transfer the new data from one table to existing data in another table. These tables have the same names but different field names.

I tried the following command to solve my problem, but I end up with more problems than solution:

PPrivate Sub Commandtransfer_Click()

DoCmd.TransferDatabase acImport, "Microsoft Access", "D:DBSsewertvinsp.mdb", acTable, "tblSanTV", True, "INSP#; MAINLINE ID#;US MH ID#", "tblSanTV", True, "INSPNO;MAINLINE; SAN_MH_FROM"

End Sub

In the above command, I was trying to import data from "D:DBSsewertvinsp.mdb", tblSanTV" table to the general database. But I want data in the field "INSPNO;MAINLINE; SAN_MH_FROM" in "tblSanTV" goes to the corresponding fields in general dabase "tblSanTV" table, fiel "INSP#, MAINLINE ID#,US MH ID#" consecutively.

I want somebody help me out with this issue. Please help me. Thanks.

Girma

View 1 Replies View Related

Transfering Data

May 27, 2005

Hello everyone,

I have still an issue with tranfsfering data from two tabels to another two tables which have parental relationship. A while a go on this forum someone have suggested to me to use the append query but that only works to append to one table, which is not my case.

If I don't transfer these two tables together or at the same time, they will loose their relationship because of their relationship which is auto number.

I have tried to modify the append query SQL and didn't work for me. Please someone help me solve this problem or tell me other alternative way of doing this. Somone look at the following modified append query and see where I made a mistake or cannot do it this way:

INSERT INTO tblSanTV ( INSPNO, MAINLINE, [US MH ID#], [DS MH ID#], [ADDRESS#], [STREET NAME], [CROSSING STREET], [FL TYPE], [P SIZE], [MT TYPE], [MH DEPTH], [P LENGTH], [SITE CONDITION], REVERSE, HEADING, [INSP DATE], [TAPE#], [TAPE START], [TAPE STOP], [INSPECTOR NAME], [PROJECT NAME], [PROJECT NUMBER], [REP TYPE], [REP PRIORITY])
INSERT INTO tblSanTVmk (DISTFROM, DISTTO, [COUNTER], [OBS TYPE], CATEGORY, DIRECTION, [SC PERMIT#], COMMENTS, [PHOTO CLIP] )
SELECT SANTV2.[INSP#], SANTV2.[MAINLINE ID#], SANTV2.[US MH ID#], SANTV2.[DS MH ID#], SANTV2.[ADDRESS#], SANTV2.[STREET NAME], SANTV2.[CROSS STREET], SANTV2.[FL TYPE], SANTV2.[P SIZE], SANTV2.[MT TYPE], SANTV2.[MH DEPTH], SANTV2.[P LENGTH], SANTV2.[SITE CONDITION], SANTV2.REVERSE, SANTV2.HEADING, SANTV2.[INSP DATE], SANTV2.[TAPE#], SANTV2.[TAPE START], SANTV2.[TAPE STOP], SANTV2.INSPECTOR, SANTV2.[PROJECT NAME], SANTV2.[PROJECT#], SANTV2.[REP TYPE], SANTV2.[REP PRIORITY], tblSanTVmk2.DISTFROM, tblSanTVmk2.DISTTO, tblSanTVmk2.COUNTER, tblSanTVmk2.[OBS TYPE], tblSanTVmk2.CATEGORY, tblSanTVmk2.DIRECTION, tblSanTVmk2.[SC PERMIT#], tblSanTVmk2.COMMENTS, tblSanTVmk2.[PHOTO CLIP]
FROM SANTV2 INNER JOIN tblSanTVmk2 ON SANTV2.[INSP#] = tblSanTVmk2.[INSP#]
WITH OWNERACCESS OPTION;

I tried to modify the append query to the above format but didn't work. I even tried "inner join" to put the above table together but I could be able to make it work. Anybody knows how to solve this, please help. Thanks.

Girma

View 12 Replies View Related

Transfering Data Between Databases

Jun 26, 2007

i have 3 databases containing data in the same format.

basically i work in a school, and have a database for 3 different classes.

each database has a table containing the childrens details(table a), and a linked table (through primary key in table a) to targets and points scote for each week.

--table a--
child number
name
carer
address
etc

--table b--
index
child number (linked)(displayed as childs name in table, but stored as a number)
week starting
target 1
target 2
target 3
points 1
points 2
points 3
etc


now this database has been working really well. but if ever a child has to be moved class then i need to be called to transfer the records manually (because nobody else can do it) and i have to get the records manually and copy and paste them between databases. This works fine and i've had no problems. And the auto number in table a is changed from the original. but this seems to automatically corrolate to table b when i paste that over. so everything is working fine.
but....
first of all, it creates lots of work for me when kids move classes, and also if i'm not there nobody else can do it.
so....
i've tried using an append query to transfer the data. I tried using 2 append queries (1 for each table).
but....
it works fine for table a, but i'm having trouble with table b.
the append query for table b pastes all the records into the equivalent table on the other database through searching all records related to childs name on table a, therefore retuning all records in table b for that child.
the problem.......
when this data is transfered it transfers table a data fine. but table b is fine except for the fact that it doesn't transfer the childs name data (number), which i can kinda understand, but from what i can understand, my queries are doing the same thing as if i was to cut and paste manually and it works fine when i do that.

ok so its all very confusing, and i hope ive explained adequetly.
oh and btw, i can't put it all in 1 database, because each class may need to access the database at the same time.

thanks


adam

View 4 Replies View Related

Transfering Data Dynamically

Oct 1, 2005

Hi,

I have a subform called "Earthwork". I also have a query called earthwork200 and I need to dynamically transfer data from the earthwork to the query based on a certain column.

for example, the earthwork column i am using to transfer data to the query is "Desc" (the name of the column). How do i get data to dynamically goto the query as I click on a new item under the "desc" column?

Kindly HELP!!

View 1 Replies View Related

Transfering MYSQL Data To An ACCESS Database- HELP ME!

Oct 31, 2005

Could someone please help me?

At work we have a website with a mysql database attached to it. It keeps data such as customer name address postcode contact id etc.

Currently our main database is made in access.

I need to transfer data from the website database (which is in mysql) to our access database. And would like this to happen regulary. We have been quoted £1800 for someone to do this!

As this is a new job i would like to be able to do this myself, is it hard to do?

Could someone provide me with some information of how to do this? or where to start.

Much appriciated.

View 3 Replies View Related

Transfering A Formula From A Form Into A Table

Nov 21, 2007

I've built a table and used it to build a form. One the form I have three boxes, one to enter the DoB, and two others that record the age and also put the individual into an age bracket.

In the latter two categories I have entered a formula in the Properties Box under Data & Control Source (the formulas are below) to automatically work out what the age and age bracket is when the DoB is entered. This works fine but the information isn't transferred back to the table.

Do I need to do the info in the table first and then update the form? And if so where do I enter the info in the field properties in the table design view?

=Int((Date()-[DOB])/365.25)

=IIf([age]>=50,"50+",IIf([age]>=35,"35-49",IIf([age]>=25,"25-34","16-24")))

Many thanks in advance

View 2 Replies View Related

Transfering RecordSource/OrderBy Of Form To Report

Oct 17, 2006

I have a subform within a form that displays filtered data based on dynamic selection criteria which is assigned to the RecordSource/OrderBy of the subform. On this form, I have a "Print Results" button -- OnClick, I would like the RecordSource/OrderBy of the subform to be copied to the Report, then run the report. What I have that doesn't work is:

Reports!rpt_frmTaskMain.RecordSource = Forms!frmTaskMain.frmTaskSub1.RecordSource
Reports!rpt_frmTaskMain.OrderBy = Forms!frmTaskMain.frm.TaskSub1.OrderBy

On execution I get error: "Object doesn't support this property or method"

I am thinking this can be done, and likely have the references wrong. Help?

View 1 Replies View Related

Transfering Old Records

Nov 11, 2005

Hey All,

This may have been covered already, and if it was I appologize. Searched for it but couldnt find it.

Any how, I have a large table of records (problem is its growing). It lists customers and dates. My table has way to many records, so i need to condense it a little bit. What i need to do is transfer contracts that have been fulfilled (by date) transfer to another table that contains records of contracts that have been fulfilled. I want to do this by a push of a button, automatically transferring any records that the date has passed to the pastcontract table.

Any ideas? Im not quite sure how to proceed.


Mateo

View 4 Replies View Related

Transfering Information

Nov 3, 2006

I have three list boxes. Two of them has data from a database in them. I want to chose one piece of data from one index, and choose two pieces of data from the other list, and click a button to send it to another list(database, that would later be exported to excel). Does anyone know how I would go about doing this?

View 1 Replies View Related

Error While Transfering Field

Feb 24, 2006

ok. as shown i have 2 forms.. form one is 'job' based on the 'job' table

form 2 is 'job pickup' based on the 'job pickup' table.

my job form has the following code.
Option Compare Database

Private Sub Command6_Click()
On Error GoTo Err_Command6_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "job pickup"

stLinkCriteria = "[job id]=" & Me![job id]
DoCmd.OpenForm stDocName, , , stLinkCriteria, , , Me.[job id]

Exit_Command6_Click:
Exit Sub

Err_Command6_Click:
MsgBox Err.Description
Resume Exit_Command6_Click

End Sub

and my job pickup form has the following code
Option Compare Database

Private Sub Form_Load()
Set rs = Me.RecordsetClone
rs.FindFirst "[job id] = " & Forms!job![job id]
If (rs.NoMatch) Then
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
Me.[job id] = Forms!job![job id]
Else
Set Me.Bookmark = rs.Bookmark
End If
rs.Close
End Sub

i have a button 'Command6'... that opens my job pickup form from my job form. when i click it however i get the following error..

runtime error 424, object required.
why is this?

View 14 Replies View Related

Transfering A Spreadsheet To Access Table

Oct 4, 2007

hello

i would like some advice so i do this correctly.

I have a access database with a customer table. And a excel spreadsheet wih customer details. I wish to transfer all the excel spreadsheet customers into the database - customer table.

The format of the customer table in the database is...
Customer ID
Customer Surname
Customer Forename/s
Position
Company Name
Address Line 1
Address Line 2
Address Line 3
Town/City
County
Postcode
Telephone
Mobile
Fax
Email Address
Type Of Business
No Of Employees
Capture Method
Preferred Contact Method
Newsletter/Fact Sheet
Update Auto Recieval
Additional Notes
Passed On to Partner Organisations
Date Input
Web Address
Chamber Member
Description
Month & Yr Est
Website ID
Complained?


The format of the excel spreadsheet is....
Contact(consists of forname and surname)
Role
Email
Tel.
CompanyAddress(has to lines add 1 and add 2)
City
Postcode


I need to make fields match from the spreadsheet to the field table on the database?

can someone please provide me with steps as to how to transfer the spreadsheet into the database correctly?

thanks a lot

View 4 Replies View Related

Table Structure - Transfering Information

Sep 25, 2006

I am creating a database for a hyperthetical car hire company. I have a table for the customer details, a table for car details, a mid table with current car hire information. I want to create a table for previous car hire information. Is there a way that i can transfer the details from the current car hire table to the previous car hire table without copying and pasting? (when the customer returns their car)

View 1 Replies View Related

Having Trouble Transfering Text In Forms

Feb 1, 2005

Can you work out whats wrong with this I used the sample database password system and tried to add a button to enable the user to change their own password. The problem was at the time that the change password form must open displaying only their own username, this is where the complication starts where i try to transfer UserID from the menu form to the Change password form.

Any Ideas Im a bit confussed.

P.S
Only left what was needed in the dadabase

View 2 Replies View Related

Transfering Information From Query To Table

Mar 15, 2006

Hi there, this is probably a very simple problem for people with experience of Access, however i have been having problems with being able to tranfer information from a query to a table.

I have made a query which displays a number of different items with their prices and who bought them (ie. booking ID)

I have then made a query which asks for the booking ID, then once you have input that it searches the items and adds up the price for all the items which that booking ID has.

both these queries work fine. The problem i am having is that i want to transfer this total price into a table. I have been able to do this by manually typing into the sql code the price, however when i try to get the query to collect the price itselfs, it gives the error
"operation must use an updateable query"

btw i am making the query as a update query,

sorry if this post is a tad long and messy,
thx in advance for any help

View 1 Replies View Related

Pivot Charts Done In 2003 - Transfering To 2000

Oct 15, 2007

I have set up some pivot charts in Access 2003 that open up on the click of a button. No problems. My problem now is that several PC at work are running Access 2000. Is there a way of easily getting this to work????Many thanks Eq

View 1 Replies View Related

Transfering Info From Table To Table

Jun 29, 2005

Hi

I am creating a database but I am having a problem with one little bit (so far!!)

I have form (and table) 1 and form/table 2. When I am in table 1 (which is company details) I want to be able to click a button which will open form 2 and allow me to enter a new record of incoming mail details regarding the Co. selected in form 1.

I have made a relationship between the Company ID on both tables.

I cannot seem to work out how to make Access take the Co ID no from form/table 1 and stick it into form/table 2 when I push the button.

Can anyone offer any advice??

thanks heaps
Siobhan. :p

View 1 Replies View Related

Select 1 Pce Of Data And It Automatically Selects And Inputs Relating Data In A Form

Oct 24, 2007

i would like in a form for a combo box to be able to select an item from a table and input relating information automatically into other boxes in the form..

I have 3 tables: Table 1 has product code and product description.
Table 2 has invoice number company details, address etc.
Table 3 has product code and product description qty and invoice number..
Table 3 relates to table 2 by the invoice number and table 3 product code looks up the product codes available in table 1 and also table 3 looks up the list of products descriptions in table 1 using the combo wizard.
This means the wrong code can be put with wrong description.
What i would like to know is how i select a product description and the product code in the form fills out automatically?? i hope this makes sense please helppppp!!

View 5 Replies View Related

Forms :: Create Data Entry Form To Input Data For Field

Mar 5, 2015

I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)

I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.

I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.

View 1 Replies View Related

Modules & VBA :: Datasheet Mode Form For Both Data Entry And Data Retrieval

Feb 9, 2015

I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working.

<code>
DoCmd.OpenForm "PO_Practice Data", , , , acFormEdit, acHidden

Forms![PO_Practice Data]!PO_Name.Enabled = True
Forms![PO_Practice Data]!PO_Name.Locked = False
Forms![PO_Practice Data]!Practice_Name.Enabled = True
Forms![PO_Practice Data]!Practice_Name.Locked = False

[code]...

View 3 Replies View Related

Queries :: Filter Data From A Table Using Query (from Data Input Form)

Dec 30, 2014

I would like to filter data from a table using a query (from an data input form). The objective is to output all results if input form field is empty and to output results higher or equal to the type in the field if field is not Null. The query code is as follows:

IIf(IsNull([Forms]![Form2]![MaxDiffInput]);[Maximum operational pressure (bar)];[Maximum operational pressure (bar)]>=[Forms]![Form2]![MaxDiffInput])

However, is not providing any result when the input field (MaxDiffInput) as a value.

View 5 Replies View Related

Forms :: Display Data In Form As Select Record In Subform In Data Sheet View

Nov 11, 2013

i have a main form named(EMP) i have a subform named(SEMP)with EMPID i have an another form Named(SDetail) with EMPID i want to open form Sdetail with filter records for data select in subform (SEMP) ,EMPID field Subform SEMP in as datasheet view. i can open sdetail for selected records only

View 14 Replies View Related

Forms :: Saving Specific Data From Data Entry Form Depending On User Selection

Dec 18, 2014

I am trying to save specific data from a data entry form to a specific depending on what the user selects from a dropdown/combo box.

So if the user selects "test company from the combo box, that data (from that form) will save to the Test company data table.

View 5 Replies View Related

Forms :: Opening A Form From Another Form Via Combo And Auto Loading Form Data?

Apr 14, 2015

I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.

The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.

The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.

View 9 Replies View Related

Forms :: Switching Form From Data Entry Only To Data Editing

Feb 18, 2015

My aim is to have my forms open to a new record, which I have done, but if my users need to then update or edit data in previous entries, they can click a button that allows this.

My thoughts were to add a button, then put in code so that the necessary properties changed the form from displaying a new record or records entered since opening it, to showing all records in the associated table....

As an example there is a table for purchase orders. When clicking on this from the main menu form, it opens up the purchase order form to create a brand new PO. At times though, we will need to revisit an order to attach a copy of an invoice, or update the cost of whatever was purchased.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved