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

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

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]

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

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]

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

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]

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];

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]