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