If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing data into a form
Hello again. I have a form that is finally the way I want it;
functioning the way it's supposed to...all is great. Now, there is a request to import some data from Excel into certain fields of the form. I've been able to import successfully into the table, and the data goes into the correct fields, but how do I get that data now into the form? I've even tried to recreate the form, using that new/ updated table, but it doesn't show. Any ideas? Thank you very much. Julie |
#2
|
|||
|
|||
Importing data into a form
If you're triggering this import from your form, you'll have to then requery
the form so that the new data will be pulled from the table and displayed. To insure that the import operation completes before requerying form, I'd use DoEvents. After your import code use DoEvents Me.Requery -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Importing data into a form
On Wed, 27 Aug 2008 06:28:18 -0700 (PDT), julie
wrote: Hello again. I have a form that is finally the way I want it; functioning the way it's supposed to...all is great. Now, there is a request to import some data from Excel into certain fields of the form. I've been able to import successfully into the table, and the data goes into the correct fields, but how do I get that data now into the form? I've even tried to recreate the form, using that new/ updated table, but it doesn't show. Any ideas? Thank you very much. Julie Recreating the form would not be necessary. Again... the form *is just a window* onto the table, so you can't "import into a form". What you need to do is import the data into the Table, and then somehow navigate the form to the newly imported record (or records). What is the Recordsource property of the form? How are you doing the import? Is the form open while you are doing so? Can you see the data if you close and reopen the form? -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Importing data into a form
On Aug 27, 1:12*pm, John W. Vinson
wrote: On Wed, 27 Aug 2008 06:28:18 -0700 (PDT), julie wrote: Hello again. *I have a form that is finally the way I want it; functioning the way it's supposed to...all is great. *Now, there is a request to import some data from Excel into certain fields of the form. *I've been able to import successfully into the table, and the data goes into the correct fields, but how do I get that data now into the form? *I've even tried to recreate the form, using that new/ updated table, but it doesn't show. *Any ideas? Thank you very much. Julie Recreating the form would not be necessary. Again... the form *is just a window* onto the table, so you can't "import into a form". What you need to do is import the data into the Table, and then somehow navigate the form to the newly imported record (or records). What is the Recordsource property of the form? How are you doing the import? Is the form open while you are doing so? Can you see the data if you close and reopen the form? -- * * * * * * *John W. Vinson [MVP] ************************************************** ************************************************** **************** Hi John, Thank you for your reply. Let's see if I can answer your questions so you can help me better: 1. I did import the data into the Table successfully 2. Recordsource on the form: the query which includes the new table/ imported data 3. I imported using: File/Get External Data/Import, then followed all the prompts into my designated Table 4. No, the form was/is not open while importing. 5. No, I thought closing/reponing would work as well. I'm lost, and now there's even more data that is being requested to be imported. Your time is very much appreciated! julie |
#5
|
|||
|
|||
Importing data into a form
On Wed, 27 Aug 2008 12:49:23 -0700 (PDT), julie
wrote: ok... let's keep digging: 1. I did import the data into the Table successfully Demonstrated how? opening the table? 2. Recordsource on the form: the query which includes the new table/ imported data Perhaps you could post the SQL view of this query, and indicate how it selects the new import. 3. I imported using: File/Get External Data/Import, then followed all the prompts into my designated Table 4. No, the form was/is not open while importing. 5. No, I thought closing/reponing would work as well. I would have thought so too, if the form's Recordsource is correctly defined. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Importing data into a form
On Aug 28, 2:35*am, John W. Vinson
wrote: On Wed, 27 Aug 2008 12:49:23 -0700 (PDT), julie wrote: ok... let's keep digging: 1. I did import the data into the Table successfully Demonstrated how? opening the table? 2. Recordsource on the form: *the query which includes the new table/ imported data Perhaps you could post the SQL view of this query, and indicate how it selects the new import. 3. I imported using: *File/Get External Data/Import, then followed all the prompts into my designated Table 4. No, the form was/is not open while importing. 5. No, I thought closing/reponing would work as well. I would have thought so too, if the form's Recordsource is correctly defined. -- * * * * * * *John W. Vinson [MVP] ************************************************** ********************************************** Ok, I am really not getting this. With the addition of all the new data from Excel provided to me, I just went ahead and created (by importing) a completely new table. It looks great; all the info that I wanted imported did so fine (verifying by looking at the Table in datasheet view). When I try to create a form from this one new table, it's looks great. When I try to create a form with this one new table AND other tables previously created, the imported data is not included. I have built a query with the new table and tried to create a form from that query - imported data still not showing up. What more information can I give you to help me? And of course, there is a rediculous deadline.... julie |
#7
|
|||
|
|||
Importing data into a form
On Thu, 28 Aug 2008 09:13:31 -0700 (PDT), julie
wrote: Ok, I am really not getting this. With the addition of all the new data from Excel provided to me, I just went ahead and created (by importing) a completely new table. It looks great; all the info that I wanted imported did so fine (verifying by looking at the Table in datasheet view). When I try to create a form from this one new table, it's looks great. When I try to create a form with this one new table AND other tables previously created, the imported data is not included. I have built a query with the new table and tried to create a form from that query - imported data still not showing up. What more information can I give you to help me? And of course, there is a rediculous deadline.... So you have a *completely new table*, unrelated to any other tables? Again: please open the Query that you are using as the recordsource of the Form. Open it in SQL view (View... SQL). Post the SQL text here. My *guess in the total absence of evidence* is that you have two tables in a query and that the join between them is incorrect, causing no records to be returned. Typically you would NOT display multiple tables' data on one form, instead using a Form with Subforms - but then I know nothing about your tables or the structure and relationships of the data within them. -- John W. Vinson [MVP] |
#8
|
|||
|
|||
Importing data into a form
On Aug 28, 12:44*pm, John W. Vinson
wrote: On Thu, 28 Aug 2008 09:13:31 -0700 (PDT), julie wrote: Ok, I am really not getting this. With the addition of all the new data from Excel provided to me, I just went ahead and created (by importing) a completely new table. *It looks great; all the info that I wanted imported did so fine (verifying by looking at the Table in datasheet view). *When I try to create a form from this one new table, it's looks great. *When I try to create a form with this one new table AND other tables previously created, the imported data is not included. *I have built a query with the new table and tried to create a form from that query - imported data still not showing up. What more information can I give you to help me? *And of course, there is a rediculous deadline.... So you have a *completely new table*, unrelated to any other tables? Again: please open the Query that you are using as the recordsource of the Form. Open it in SQL view (View... SQL). Post the SQL text here. My *guess in the total absence of evidence* is that you have two tables in a query and that the join between them is incorrect, causing no records to be returned. Typically you would NOT display multiple tables' data on one form, instead using a Form with Subforms - but then I know nothing about your tables or the structure and relationships of the data within them. -- * * * * * * *John W. Vinson [MVP] I do have a completely new table, but it is related to the other existing table. Here's the deal: I have 7 tables containing various data of patient records: ID (auto numbered), Subject Code, several fields of date/time stamps of admissions, discharges, transfers, etc. It's a lot of data. The primary key of each table is the Subject Code, although there is one main table with the primary key being the auto-number ID (this table does also include the Subject Code field). The six other tables have a 1:1 relationship to the main table, linking the Subject Codes. (I did it this way because the instructor in the certifcation class said every day for four weeks - "you'll never have enough tables! people have problems because they never make enough tables!") Should all the tables be related to each other's SbjCd, like one big spider web? Here is the SQL text (is this really what you wanted?) There are seven tables in the query, all related as described above: SELECT tblTransferredTraumaPatientsIMPORT.ID, tblTransferredTraumaPatientsIMPORT.[Subject Code], tblTransferredTraumaPatientsIMPORT.[Date of Admission], tblTransferredTraumaPatientsIMPORT.Class, tblTransferredTraumaPatientsIMPORT.ISS, tblTransferredTraumaPatientsIMPORT.[Mechanism of Injury], tblTransferredTraumaPatientsIMPORT.[Intubated Prior to Arrival], tblTransferredTraumaPatientsIMPORT.Age, tblTransferredTraumaPatientsIMPORT.Gender, tblTransferredTraumaPatientsIMPORT.[DateTime of Injury], tblTransferredTraumaPatientsIMPORT.[Date/Time Arrived], tblTransferredTraumaPatientsIMPORT.[DateTime Registered in ED], tblTransferredTraumaPatientsIMPORT.[Date/Time Out of ED], tblTransferredTraumaPatientsIMPORT.Disposition, tblTransferredTraumaPatientsIMPORT.[Date/Time in CT], tblTransferredTraumaPatientsIMPORT.[Date/Time Available in CareWeb], tblTransferredTraumaPatientsIMPORT.[Date/Time of Reading], tblTransferredTraumaPatientsIMPORT.[Date/Time of Discharge], tblOSHCTEvaluations.Head AS tblOSHCTEvaluations_Head, tblOSHCTEvaluations.[Max/Fac] AS [tblOSHCTEvaluations_Max/Fac], tblOSHCTEvaluations.Cspine AS tblOSHCTEvaluations_Cspine, tblOSHCTEvaluations.CTA AS tblOSHCTEvaluations_CTA, tblOSHCTEvaluations.Chest AS tblOSHCTEvaluations_Chest, tblOSHCTEvaluations.[Abdomen/Pelvis] AS [tblOSHCTEvaluations_Abdomen/ Pelvis], tblOSHCTEvaluations.[Bony Pelvis] AS [tblOSHCTEvaluations_Bony Pelvis], tblOSHCTEvaluations.Extremity AS tblOSHCTEvaluations_Extremity, tblOSHCTEvaluations.Other AS tblOSHCTEvaluations_Other, tblOSHCTEvaluations.[OSH IV Contrast] AS [tblOSHCTEvaluations_OSH IV Contrast], tblOSHCTEvaluations.Dose AS tblOSHCTEvaluations_Dose, tblUMCTEvaluations.Head AS tblUMCTEvaluations_Head, tblUMCTEvaluations.[Max/Fac] AS [tblUMCTEvaluations_Max/Fac], tblUMCTEvaluations.Cspine AS tblUMCTEvaluations_Cspine, tblUMCTEvaluations.CTA AS tblUMCTEvaluations_CTA, tblUMCTEvaluations.Chest AS tblUMCTEvaluations_Chest, tblUMCTEvaluations.[Abdomen/Pelvis] AS [tblUMCTEvaluations_Abdomen/Pelvis], tblUMCTEvaluations.[Bony Pelvis] AS [tblUMCTEvaluations_Bony Pelvis], tblUMCTEvaluations.Extremity AS tblUMCTEvaluations_Extremity, tblUMCTEvaluations.Other AS tblUMCTEvaluations_Other, tblUMCTEvaluations.[OSH IV Contrast] AS [tblUMCTEvaluations_OSH IV Contrast], tblUMCTEvaluations.Dose AS tblUMCTEvaluations_Dose, tblUMCTEvaluations.[Total CT mSievert 24hrs Post-Admission], tblReasonsForRepeatCTs.Head AS tblReasonsForRepeatCTs_Head, tblReasonsForRepeatCTs.[Max/Fac] AS [tblReasonsForRepeatCTs_Max/Fac], tblReasonsForRepeatCTs.Cspine AS tblReasonsForRepeatCTs_Cspine, tblReasonsForRepeatCTs.CTA AS tblReasonsForRepeatCTs_CTA, tblReasonsForRepeatCTs.Chest AS tblReasonsForRepeatCTs_Chest, tblReasonsForRepeatCTs.[Abdomin/Pelvis] AS [tblReasonsForRepeatCTs_Abdomin/Pelvis], tblReasonsForRepeatCTs. [Bony Pelvis] AS [tblReasonsForRepeatCTs_Bony Pelvis], tblReasonsForRepeatCTs.Extremity AS tblReasonsForRepeatCTs_Extremity, tblReasonsForRepeatCTs.Other AS tblReasonsForRepeatCTs_Other, tblMissedInjuries.[Discrepancy Btwn Initial and Consult], tblMissedInjuries.Head AS tblMissedInjuries_Head, tblMissedInjuries. [Max/Fac] AS [tblMissedInjuries_Max/Fac], tblMissedInjuries.Cspine AS tblMissedInjuries_Cspine, tblMissedInjuries.CTA AS tblMissedInjuries_CTA, tblMissedInjuries.Chest AS tblMissedInjuries_Chest, tblMissedInjuries.[Abdomin/Pelvis] AS [tblMissedInjuries_Abdomin/Pelvis], tblMissedInjuries.[Bony Pelvis] AS [tblMissedInjuries_Bony Pelvis], tblMissedInjuries.Extremity AS tblMissedInjuries_Extremity, tblMissedInjuries.Other AS tblMissedInjuries_Other, tblRenalFunction.BaselineCreatinine, tblRenalFunction.[Max Creatinine in 7 Days Post-Admission], tblRenalFunction.[Date of Max Creatinine], tblRenalFunction.[Max Creatinine During Hospitalization], tblRenalFunction.Dialysis, tblRenalFunction.[Date Dialysis Intiated], tblHospitalOutcome. [Discharged Alive], tblHospitalOutcome.Deceased FROM (((((tblTransferredTraumaPatientsIMPORT INNER JOIN tblMissedInjuries ON tblTransferredTraumaPatientsIMPORT.[Subject Code] = tblMissedInjuries.[Subject Code]) INNER JOIN tblOSHCTEvaluations ON tblTransferredTraumaPatientsIMPORT.[Subject Code] = tblOSHCTEvaluations.[Subject Code]) INNER JOIN tblReasonsForRepeatCTs ON tblTransferredTraumaPatientsIMPORT.[Subject Code] = tblReasonsForRepeatCTs.[Subject Code]) INNER JOIN tblRenalFunction ON tblTransferredTraumaPatientsIMPORT.[Subject Code] = tblRenalFunction. [Subject Code]) INNER JOIN tblUMCTEvaluations ON tblTransferredTraumaPatientsIMPORT.[Subject Code] = tblUMCTEvaluations. [Subject Code]) INNER JOIN tblHospitalOutcome ON tblTransferredTraumaPatientsIMPORT.[Subject Code] = tblHospitalOutcome. [Subject Code]; |
#9
|
|||
|
|||
Importing data into a form
Julie, I'm tied up with other work through Saturday. I'll try to get back to
this over the weekend but you might want to start a new thread to see if anyone else can help. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|