Hello All,
I am new to the forum and looking forward to learning from you all. Although I work with Access on a daily basis I am clueless when it comes to it's "behind the scenes" capabilities.
The question I had today is whether the following process can be automated and if it is possible what is the best way to go about it for someone such as myself with no knowledge in coding.
I've attached 2 files, the 1st one is names "Excel Data Cell" ("EDC"), which is the Excel s/s I eneter tha data on, the other is "Access Data Entry" ("ADE"), which is a data entry screen in Access. What I would like to do is automate this process. I will use "ADE" and "EDC" abbreviations to distinguish the file names.
The following is exactly what I am trying to achieve:
1) First, I would like for this automation process to be able to pull up each file number seperately in the Access Database. The file numbers are shown in row 1, cell J-N, of the "EDC".
Once the first file is up (516115), I would like the following automated entries done for each file:
2)I would like the field directly next to the "Draft #" on the "ADE" field to be populated with the data entered on "EDC" Cell D7 (highlighted yellow)
3) I would like for the "Date Req:" and "Acctg Draft Date" fields on the "ADE" to both be populated with the data entered on "EDC" cell F3 (Highlighted black)
3) I would like for the "Amount" field to be poulated with the data entered in cell J7 (highlighted green)
4) For this spreadsheet I would like for Access to defulat to "Allocated Expense"
5) I would like for the "Payee" field on the "ADE" to be populated with the data entered in cell A2 (highlighted burgundy)
6) Lastly, I would like for the "Payment Reason" to list all invoices shown in cell D4 of the "EDC".
I hope this is not to much. If anyone can tell me if this is possible and how to go about it, I would really appreciate it. If you need any additional information, please just let me know. Thanks!
I am new to the forum and looking forward to learning from you all. Although I work with Access on a daily basis I am clueless when it comes to it's "behind the scenes" capabilities.
The question I had today is whether the following process can be automated and if it is possible what is the best way to go about it for someone such as myself with no knowledge in coding.
I've attached 2 files, the 1st one is names "Excel Data Cell" ("EDC"), which is the Excel s/s I eneter tha data on, the other is "Access Data Entry" ("ADE"), which is a data entry screen in Access. What I would like to do is automate this process. I will use "ADE" and "EDC" abbreviations to distinguish the file names.
The following is exactly what I am trying to achieve:
1) First, I would like for this automation process to be able to pull up each file number seperately in the Access Database. The file numbers are shown in row 1, cell J-N, of the "EDC".
Once the first file is up (516115), I would like the following automated entries done for each file:
2)I would like the field directly next to the "Draft #" on the "ADE" field to be populated with the data entered on "EDC" Cell D7 (highlighted yellow)
3) I would like for the "Date Req:" and "Acctg Draft Date" fields on the "ADE" to both be populated with the data entered on "EDC" cell F3 (Highlighted black)
3) I would like for the "Amount" field to be poulated with the data entered in cell J7 (highlighted green)
4) For this spreadsheet I would like for Access to defulat to "Allocated Expense"
5) I would like for the "Payee" field on the "ADE" to be populated with the data entered in cell A2 (highlighted burgundy)
6) Lastly, I would like for the "Payment Reason" to list all invoices shown in cell D4 of the "EDC".
I hope this is not to much. If anyone can tell me if this is possible and how to go about it, I would really appreciate it. If you need any additional information, please just let me know. Thanks!
