import & export data on form

  • Thread starter Thread starter ana
  • Start date Start date
A

ana

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
 
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/accessjunkie/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
 
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".
 
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
 
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.
 
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
 
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.
 
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
 
Back
Top