A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

import & export data on form



 
 
Thread Tools Display Modes
  #1  
Old November 14th, 2009, 04:38 AM posted to microsoft.public.access.forms
Ana
external usenet poster
 
Posts: 46
Default import & export data on form

Is it possible for a form to autofill w/ data in table and when rest of form
is filled out to export all data back into table?

Ex:

prefill form with:
accounts
dollars
action

When form completed:
accounts
accounts reviewed
dollars
dollars reviewed
action
action reviewed
comments
  #2  
Old November 14th, 2009, 06:34 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default import & export data on form

Ana,

There must be a misunderstanding here. Forms don't *prefill* with data. In
fact, forms don't have any data at all, tables do. Forms are bound to a
table or a query, or maybe your form is unbound? So where/how is your form
prefilling with data? Is the form unbound? OR does it have a RecordSource?
If it is unbound then you would need to run an update or append auery to
send the data to a table(s). However, that brings us to question number
two... what are the reviewed fields? Is someone checking a box once those
items are reviewed?

Here are some links that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ana" wrote in message
...
Is it possible for a form to autofill w/ data in table and when rest of
form
is filled out to export all data back into table?

Ex:

prefill form with:
accounts
dollars
action

When form completed:
accounts
accounts reviewed
dollars
dollars reviewed
action
action reviewed
comments



  #3  
Old November 17th, 2009, 09:34 PM posted to microsoft.public.access.forms
anamque
external usenet poster
 
Posts: 8
Default import & export data on form

Gina,

Thanks for the clarification. So I have a form that is bound to database1 -
it's pulling A, B, C, D, E from database1.

On my form I have - A, B, C, D, E, F, G, H, I, J, K

I need it to take A, B, C, D, E, F, G, H, I, J, K and put it in database2
when I complete the form (I am thinking a "submit" command button for this
piece). F-K would be the fields I reviewed but they would not be checkboxes,
they would be text boxes.

Ex: Analyst reviews 3 Business Accts (A), 2 Home Equity Lines (B), and 2
Unsecured Lines of Credits (C) - I have to review each account and in a
seperate field for each product, I have to enter the result of my review. In
some cases, the analyst entered it correctly or they could have entered it
wrong. I need F-K to capture what was entered wrong and go into db2
(including the original data A-E).

So A-E would bring in what was entered into db1
F-K would be where I would enter my results of the "quality review".

"Gina Whipp" wrote:

Ana,

There must be a misunderstanding here. Forms don't *prefill* with data. In
fact, forms don't have any data at all, tables do. Forms are bound to a
table or a query, or maybe your form is unbound? So where/how is your form
prefilling with data? Is the form unbound? OR does it have a RecordSource?
If it is unbound then you would need to run an update or append auery to
send the data to a table(s). However, that brings us to question number
two... what are the reviewed fields? Is someone checking a box once those
items are reviewed?

Here are some links that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ana" wrote in message
...
Is it possible for a form to autofill w/ data in table and when rest of
form
is filled out to export all data back into table?

Ex:

prefill form with:
accounts
dollars
action

When form completed:
accounts
accounts reviewed
dollars
dollars reviewed
action
action reviewed
comments



.

  #4  
Old November 17th, 2009, 11:37 PM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default import & export data on form

Ana,

You have explained, somewhat, what you do but not why which still leaves a
solution kinda out of reach.

1. A thru E bound to database 1 and pulling from database 1? Can one assume
by this statement that there is a table in database 1 that has a table with
fields A thru E? And is that data entered by someone? Or imported?

2. Where do F thru K come from? Are they fields in another table or the
same table as above but manually entered by you?

3. And why after all this manipulation are you *pushing* this table off to
Database 2? Why not just have a Reviewed field?

4. And I am still not sure where the *autofill* mentioned in your original
posting comes into play. What are you trying to autofill? Or was that a
reference to *pushing* the data to database 2?

I can simply answer your question with yes you can just use a *SUBMIT*
button. However, I see some concerns in your design that may be okay and
working for you and that's okay but why do double work to maintain two
datbases that sound like the duplicate each other.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
Gina,

Thanks for the clarification. So I have a form that is bound to
database1 -
it's pulling A, B, C, D, E from database1.

On my form I have - A, B, C, D, E, F, G, H, I, J, K

I need it to take A, B, C, D, E, F, G, H, I, J, K and put it in database2
when I complete the form (I am thinking a "submit" command button for this
piece). F-K would be the fields I reviewed but they would not be
checkboxes,
they would be text boxes.

Ex: Analyst reviews 3 Business Accts (A), 2 Home Equity Lines (B), and 2
Unsecured Lines of Credits (C) - I have to review each account and in a
seperate field for each product, I have to enter the result of my review.
In
some cases, the analyst entered it correctly or they could have entered it
wrong. I need F-K to capture what was entered wrong and go into db2
(including the original data A-E).

So A-E would bring in what was entered into db1
F-K would be where I would enter my results of the "quality review".

"Gina Whipp" wrote:

Ana,

There must be a misunderstanding here. Forms don't *prefill* with data.
In
fact, forms don't have any data at all, tables do. Forms are bound to a
table or a query, or maybe your form is unbound? So where/how is your
form
prefilling with data? Is the form unbound? OR does it have a
RecordSource?
If it is unbound then you would need to run an update or append auery to
send the data to a table(s). However, that brings us to question number
two... what are the reviewed fields? Is someone checking a box once
those
items are reviewed?

Here are some links that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ana" wrote in message
...
Is it possible for a form to autofill w/ data in table and when rest of
form
is filled out to export all data back into table?

Ex:

prefill form with:
accounts
dollars
action

When form completed:
accounts
accounts reviewed
dollars
dollars reviewed
action
action reviewed
comments



.



  #5  
Old November 18th, 2009, 04:58 PM posted to microsoft.public.access.forms
anamque
external usenet poster
 
Posts: 8
Default import & export data on form

Gina,

1. Yes, fields A thru E are bound to db1 and this information will be
imported into db1

2. F thru K going into db2 but are coming from the access from, on the form
i will have fields A-K.

3. I can't have a reviewed field in db1. Reason being is, the purpose of
this database/form - i will be doing "quality reviews" on my associates. So i
have associates enter in all their work into db1.

Let's say for example, associate enters that they worked 3 Home Equity
Lines, 2 Consumer Cards, 4 Business accounts associated under one social
security number. My quality review is supposed to gather all account
information they entered and confirm that they worked what they entered. Due
to the sensitivity of my reviews and for compliance reasons, the work i
"pull" (accts reviewed) and what i review & confirm must be kept seperately.
Not only that, but let's say the analyst mistyped they worked 3 Home Equity
Lines and they actually worked 2. I will update the db1 that they worked 2,
but in db2, i still need it store that originally they entered 3 and due to
the review, it was changed to two.

4. yes my verbage was incorrect, it's pushing all fields into db2.

"Gina Whipp" wrote:

Ana,

You have explained, somewhat, what you do but not why which still leaves a
solution kinda out of reach.

1. A thru E bound to database 1 and pulling from database 1? Can one assume
by this statement that there is a table in database 1 that has a table with
fields A thru E? And is that data entered by someone? Or imported?

2. Where do F thru K come from? Are they fields in another table or the
same table as above but manually entered by you?

3. And why after all this manipulation are you *pushing* this table off to
Database 2? Why not just have a Reviewed field?

4. And I am still not sure where the *autofill* mentioned in your original
posting comes into play. What are you trying to autofill? Or was that a
reference to *pushing* the data to database 2?

I can simply answer your question with yes you can just use a *SUBMIT*
button. However, I see some concerns in your design that may be okay and
working for you and that's okay but why do double work to maintain two
datbases that sound like the duplicate each other.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
Gina,

Thanks for the clarification. So I have a form that is bound to
database1 -
it's pulling A, B, C, D, E from database1.

On my form I have - A, B, C, D, E, F, G, H, I, J, K

I need it to take A, B, C, D, E, F, G, H, I, J, K and put it in database2
when I complete the form (I am thinking a "submit" command button for this
piece). F-K would be the fields I reviewed but they would not be
checkboxes,
they would be text boxes.

Ex: Analyst reviews 3 Business Accts (A), 2 Home Equity Lines (B), and 2
Unsecured Lines of Credits (C) - I have to review each account and in a
seperate field for each product, I have to enter the result of my review.
In
some cases, the analyst entered it correctly or they could have entered it
wrong. I need F-K to capture what was entered wrong and go into db2
(including the original data A-E).

So A-E would bring in what was entered into db1
F-K would be where I would enter my results of the "quality review".

"Gina Whipp" wrote:

Ana,

There must be a misunderstanding here. Forms don't *prefill* with data.
In
fact, forms don't have any data at all, tables do. Forms are bound to a
table or a query, or maybe your form is unbound? So where/how is your
form
prefilling with data? Is the form unbound? OR does it have a
RecordSource?
If it is unbound then you would need to run an update or append auery to
send the data to a table(s). However, that brings us to question number
two... what are the reviewed fields? Is someone checking a box once
those
items are reviewed?

Here are some links that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ana" wrote in message
...
Is it possible for a form to autofill w/ data in table and when rest of
form
is filled out to export all data back into table?

Ex:

prefill form with:
accounts
dollars
action

When form completed:
accounts
accounts reviewed
dollars
dollars reviewed
action
action reviewed
comments


.



.

  #6  
Old November 18th, 2009, 06:46 PM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default import & export data on form

Ana,

Okay I see we still having a bit of a terminlogy issue...

1. I do not understand *bound to* is that... a table in database 1 with
feilds A thru E where an Associate enters what they have done?

2. F thru K *going into database 2*... is that entered into database 1 and
then this is where you want the button to transfer it to database 2? OR is
it you want to transer A thru E from database 1 to database 2 and then enter
F thru K?

If Option 2 is what you are hoping to accomplish then you can set up a
TransferText export on Database 1 then a TransferText import on Database 2.
After the import in Database 2 you can run an Append query to get it into
the table and update fields F thru K there. (Or you could fix them in
Database 1 then run the export and when brought into Database 2 add the
additional information.)

OR

Split the database and have two front ends... one showing the form with the
fields A thru E and the other front end shoing the feilds F thru K. That
way one table to maintain. Becase in reality, if I wanted to change
database 2 all I would have to do is go open it, unless there is some sort
of security that will not let me?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
Gina,

1. Yes, fields A thru E are bound to db1 and this information will be
imported into db1

2. F thru K going into db2 but are coming from the access from, on the
form
i will have fields A-K.

3. I can't have a reviewed field in db1. Reason being is, the purpose of
this database/form - i will be doing "quality reviews" on my associates.
So i
have associates enter in all their work into db1.

Let's say for example, associate enters that they worked 3 Home Equity
Lines, 2 Consumer Cards, 4 Business accounts associated under one social
security number. My quality review is supposed to gather all account
information they entered and confirm that they worked what they entered.
Due
to the sensitivity of my reviews and for compliance reasons, the work i
"pull" (accts reviewed) and what i review & confirm must be kept
seperately.
Not only that, but let's say the analyst mistyped they worked 3 Home
Equity
Lines and they actually worked 2. I will update the db1 that they worked
2,
but in db2, i still need it store that originally they entered 3 and due
to
the review, it was changed to two.

4. yes my verbage was incorrect, it's pushing all fields into db2.

"Gina Whipp" wrote:

Ana,

You have explained, somewhat, what you do but not why which still leaves
a
solution kinda out of reach.

1. A thru E bound to database 1 and pulling from database 1? Can one
assume
by this statement that there is a table in database 1 that has a table
with
fields A thru E? And is that data entered by someone? Or imported?

2. Where do F thru K come from? Are they fields in another table or the
same table as above but manually entered by you?

3. And why after all this manipulation are you *pushing* this table off
to
Database 2? Why not just have a Reviewed field?

4. And I am still not sure where the *autofill* mentioned in your
original
posting comes into play. What are you trying to autofill? Or was that a
reference to *pushing* the data to database 2?

I can simply answer your question with yes you can just use a *SUBMIT*
button. However, I see some concerns in your design that may be okay and
working for you and that's okay but why do double work to maintain two
datbases that sound like the duplicate each other.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
Gina,

Thanks for the clarification. So I have a form that is bound to
database1 -
it's pulling A, B, C, D, E from database1.

On my form I have - A, B, C, D, E, F, G, H, I, J, K

I need it to take A, B, C, D, E, F, G, H, I, J, K and put it in
database2
when I complete the form (I am thinking a "submit" command button for
this
piece). F-K would be the fields I reviewed but they would not be
checkboxes,
they would be text boxes.

Ex: Analyst reviews 3 Business Accts (A), 2 Home Equity Lines (B), and
2
Unsecured Lines of Credits (C) - I have to review each account and in a
seperate field for each product, I have to enter the result of my
review.
In
some cases, the analyst entered it correctly or they could have entered
it
wrong. I need F-K to capture what was entered wrong and go into db2
(including the original data A-E).

So A-E would bring in what was entered into db1
F-K would be where I would enter my results of the "quality review".

"Gina Whipp" wrote:

Ana,

There must be a misunderstanding here. Forms don't *prefill* with
data.
In
fact, forms don't have any data at all, tables do. Forms are bound to
a
table or a query, or maybe your form is unbound? So where/how is your
form
prefilling with data? Is the form unbound? OR does it have a
RecordSource?
If it is unbound then you would need to run an update or append auery
to
send the data to a table(s). However, that brings us to question
number
two... what are the reviewed fields? Is someone checking a box once
those
items are reviewed?

Here are some links that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ana" wrote in message
...
Is it possible for a form to autofill w/ data in table and when rest
of
form
is filled out to export all data back into table?

Ex:

prefill form with:
accounts
dollars
action

When form completed:
accounts
accounts reviewed
dollars
dollars reviewed
action
action reviewed
comments


.



.



  #7  
Old November 20th, 2009, 12:12 AM posted to microsoft.public.access.forms
anamque
external usenet poster
 
Posts: 8
Default import & export data on form

the form would get the data for fields a thru e from db1, once the form is
completed (all fields a thru k) - it would take fields a thru k and put the
data in db2.

"Gina Whipp" wrote:

Ana,

Okay I see we still having a bit of a terminlogy issue...

1. I do not understand *bound to* is that... a table in database 1 with
feilds A thru E where an Associate enters what they have done?

2. F thru K *going into database 2*... is that entered into database 1 and
then this is where you want the button to transfer it to database 2? OR is
it you want to transer A thru E from database 1 to database 2 and then enter
F thru K?

If Option 2 is what you are hoping to accomplish then you can set up a
TransferText export on Database 1 then a TransferText import on Database 2.
After the import in Database 2 you can run an Append query to get it into
the table and update fields F thru K there. (Or you could fix them in
Database 1 then run the export and when brought into Database 2 add the
additional information.)

OR

Split the database and have two front ends... one showing the form with the
fields A thru E and the other front end shoing the feilds F thru K. That
way one table to maintain. Becase in reality, if I wanted to change
database 2 all I would have to do is go open it, unless there is some sort
of security that will not let me?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
Gina,

1. Yes, fields A thru E are bound to db1 and this information will be
imported into db1

2. F thru K going into db2 but are coming from the access from, on the
form
i will have fields A-K.

3. I can't have a reviewed field in db1. Reason being is, the purpose of
this database/form - i will be doing "quality reviews" on my associates.
So i
have associates enter in all their work into db1.

Let's say for example, associate enters that they worked 3 Home Equity
Lines, 2 Consumer Cards, 4 Business accounts associated under one social
security number. My quality review is supposed to gather all account
information they entered and confirm that they worked what they entered.
Due
to the sensitivity of my reviews and for compliance reasons, the work i
"pull" (accts reviewed) and what i review & confirm must be kept
seperately.
Not only that, but let's say the analyst mistyped they worked 3 Home
Equity
Lines and they actually worked 2. I will update the db1 that they worked
2,
but in db2, i still need it store that originally they entered 3 and due
to
the review, it was changed to two.

4. yes my verbage was incorrect, it's pushing all fields into db2.

"Gina Whipp" wrote:

Ana,

You have explained, somewhat, what you do but not why which still leaves
a
solution kinda out of reach.

1. A thru E bound to database 1 and pulling from database 1? Can one
assume
by this statement that there is a table in database 1 that has a table
with
fields A thru E? And is that data entered by someone? Or imported?

2. Where do F thru K come from? Are they fields in another table or the
same table as above but manually entered by you?

3. And why after all this manipulation are you *pushing* this table off
to
Database 2? Why not just have a Reviewed field?

4. And I am still not sure where the *autofill* mentioned in your
original
posting comes into play. What are you trying to autofill? Or was that a
reference to *pushing* the data to database 2?

I can simply answer your question with yes you can just use a *SUBMIT*
button. However, I see some concerns in your design that may be okay and
working for you and that's okay but why do double work to maintain two
datbases that sound like the duplicate each other.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
Gina,

Thanks for the clarification. So I have a form that is bound to
database1 -
it's pulling A, B, C, D, E from database1.

On my form I have - A, B, C, D, E, F, G, H, I, J, K

I need it to take A, B, C, D, E, F, G, H, I, J, K and put it in
database2
when I complete the form (I am thinking a "submit" command button for
this
piece). F-K would be the fields I reviewed but they would not be
checkboxes,
they would be text boxes.

Ex: Analyst reviews 3 Business Accts (A), 2 Home Equity Lines (B), and
2
Unsecured Lines of Credits (C) - I have to review each account and in a
seperate field for each product, I have to enter the result of my
review.
In
some cases, the analyst entered it correctly or they could have entered
it
wrong. I need F-K to capture what was entered wrong and go into db2
(including the original data A-E).

So A-E would bring in what was entered into db1
F-K would be where I would enter my results of the "quality review".

"Gina Whipp" wrote:

Ana,

There must be a misunderstanding here. Forms don't *prefill* with
data.
In
fact, forms don't have any data at all, tables do. Forms are bound to
a
table or a query, or maybe your form is unbound? So where/how is your
form
prefilling with data? Is the form unbound? OR does it have a
RecordSource?
If it is unbound then you would need to run an update or append auery
to
send the data to a table(s). However, that brings us to question
number
two... what are the reviewed fields? Is someone checking a box once
those
items are reviewed?

Here are some links that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ana" wrote in message
...
Is it possible for a form to autofill w/ data in table and when rest
of
form
is filled out to export all data back into table?

Ex:

prefill form with:
accounts
dollars
action

When form completed:
accounts
accounts reviewed
dollars
dollars reviewed
action
action reviewed
comments


.



.



.

  #8  
Old November 20th, 2009, 02:39 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default import & export data on form

Ana,

Then you can use the TransferText on one side to export and TransferText to
import on the other side. To do this all you need is the folder name in
which to place the file. Here is a sample of TransferText...

DoCmd.TransferText acExportDelim, "NameOfYourSpecification", "TableName",
"C:\Path\NameOfFile.txt"

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
the form would get the data for fields a thru e from db1, once the form is
completed (all fields a thru k) - it would take fields a thru k and put
the
data in db2.

"Gina Whipp" wrote:

Ana,

Okay I see we still having a bit of a terminlogy issue...

1. I do not understand *bound to* is that... a table in database 1 with
feilds A thru E where an Associate enters what they have done?

2. F thru K *going into database 2*... is that entered into database 1
and
then this is where you want the button to transfer it to database 2? OR
is
it you want to transer A thru E from database 1 to database 2 and then
enter
F thru K?

If Option 2 is what you are hoping to accomplish then you can set up a
TransferText export on Database 1 then a TransferText import on Database
2.
After the import in Database 2 you can run an Append query to get it into
the table and update fields F thru K there. (Or you could fix them in
Database 1 then run the export and when brought into Database 2 add the
additional information.)

OR

Split the database and have two front ends... one showing the form with
the
fields A thru E and the other front end shoing the feilds F thru K. That
way one table to maintain. Becase in reality, if I wanted to change
database 2 all I would have to do is go open it, unless there is some
sort
of security that will not let me?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
Gina,

1. Yes, fields A thru E are bound to db1 and this information will be
imported into db1

2. F thru K going into db2 but are coming from the access from, on the
form
i will have fields A-K.

3. I can't have a reviewed field in db1. Reason being is, the purpose
of
this database/form - i will be doing "quality reviews" on my
associates.
So i
have associates enter in all their work into db1.

Let's say for example, associate enters that they worked 3 Home Equity
Lines, 2 Consumer Cards, 4 Business accounts associated under one
social
security number. My quality review is supposed to gather all account
information they entered and confirm that they worked what they
entered.
Due
to the sensitivity of my reviews and for compliance reasons, the work i
"pull" (accts reviewed) and what i review & confirm must be kept
seperately.
Not only that, but let's say the analyst mistyped they worked 3 Home
Equity
Lines and they actually worked 2. I will update the db1 that they
worked
2,
but in db2, i still need it store that originally they entered 3 and
due
to
the review, it was changed to two.

4. yes my verbage was incorrect, it's pushing all fields into db2.

"Gina Whipp" wrote:

Ana,

You have explained, somewhat, what you do but not why which still
leaves
a
solution kinda out of reach.

1. A thru E bound to database 1 and pulling from database 1? Can one
assume
by this statement that there is a table in database 1 that has a table
with
fields A thru E? And is that data entered by someone? Or imported?

2. Where do F thru K come from? Are they fields in another table or
the
same table as above but manually entered by you?

3. And why after all this manipulation are you *pushing* this table
off
to
Database 2? Why not just have a Reviewed field?

4. And I am still not sure where the *autofill* mentioned in your
original
posting comes into play. What are you trying to autofill? Or was
that a
reference to *pushing* the data to database 2?

I can simply answer your question with yes you can just use a *SUBMIT*
button. However, I see some concerns in your design that may be okay
and
working for you and that's okay but why do double work to maintain two
datbases that sound like the duplicate each other.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"anamque" wrote in message
...
Gina,

Thanks for the clarification. So I have a form that is bound to
database1 -
it's pulling A, B, C, D, E from database1.

On my form I have - A, B, C, D, E, F, G, H, I, J, K

I need it to take A, B, C, D, E, F, G, H, I, J, K and put it in
database2
when I complete the form (I am thinking a "submit" command button
for
this
piece). F-K would be the fields I reviewed but they would not be
checkboxes,
they would be text boxes.

Ex: Analyst reviews 3 Business Accts (A), 2 Home Equity Lines (B),
and
2
Unsecured Lines of Credits (C) - I have to review each account and
in a
seperate field for each product, I have to enter the result of my
review.
In
some cases, the analyst entered it correctly or they could have
entered
it
wrong. I need F-K to capture what was entered wrong and go into db2
(including the original data A-E).

So A-E would bring in what was entered into db1
F-K would be where I would enter my results of the "quality review".

"Gina Whipp" wrote:

Ana,

There must be a misunderstanding here. Forms don't *prefill* with
data.
In
fact, forms don't have any data at all, tables do. Forms are bound
to
a
table or a query, or maybe your form is unbound? So where/how is
your
form
prefilling with data? Is the form unbound? OR does it have a
RecordSource?
If it is unbound then you would need to run an update or append
auery
to
send the data to a table(s). However, that brings us to question
number
two... what are the reviewed fields? Is someone checking a box
once
those
items are reviewed?

Here are some links that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ana" wrote in message
...
Is it possible for a form to autofill w/ data in table and when
rest
of
form
is filled out to export all data back into table?

Ex:

prefill form with:
accounts
dollars
action

When form completed:
accounts
accounts reviewed
dollars
dollars reviewed
action
action reviewed
comments


.



.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.