pikkhuanloy
Registered User.
- Local time
- Today, 14:26
- Joined
- Mar 30, 2015
- Messages
- 17
Hi all Access Experts,
First of all, I am not a native english speaker, so please forgive me for my poor english.
My boss has assigned a task for me to move the details under a field name (eg:[Name]) in table 1 to table2 under another field name (eg:[InsuredName]).
Previously, the software I planned to use is Excel, but my boss says Excel cannot handle large data as the computer will be hanging.
So,he wants me to use Access to do the programming.
But I am definitely a newbie to Access.
I have some programming backgrounds (like C++) but it seems like I hardly understand how Access works! :banghead:
So can any Access expert here teach me how to do so that i won't get fired.
To get you the clear picture of what I want, I will paste some images here. I illustrate the process by using Excel but my job is making this work in Access.
Firstly, We will have the data like this.
Table1
Secondly, we let the other staffs to key in which column to be mapped with the other.
Manually Key in (both columns)
Mapping Table:
Thirdly, the staff will run the VBA and result would be like this.
Table2
As you can see the new table(table2) , field number 3 is the same with the field number 4 in table1. There is something like copy and paste job, but user can decide how the arrangement for the new table is.
Any idea? I know this can be done in queries but as the boss wants it to be automated, what i can think of is VBA.
Appreciate if someone can help me on this.
First of all, I am not a native english speaker, so please forgive me for my poor english.
My boss has assigned a task for me to move the details under a field name (eg:[Name]) in table 1 to table2 under another field name (eg:[InsuredName]).
Previously, the software I planned to use is Excel, but my boss says Excel cannot handle large data as the computer will be hanging.
So,he wants me to use Access to do the programming.
But I am definitely a newbie to Access.
I have some programming backgrounds (like C++) but it seems like I hardly understand how Access works! :banghead:
So can any Access expert here teach me how to do so that i won't get fired.
To get you the clear picture of what I want, I will paste some images here. I illustrate the process by using Excel but my job is making this work in Access.
Firstly, We will have the data like this.
Table1
Code:
Name | PolicyNo | Age | Benefit
--------+----------------+----------+-----------
Chris | 123 | 21 | Death
Jane | 456 | 34 | TPD
Adam | 789 | 55 | DD
Manually Key in (both columns)
Mapping Table:
Code:
Table1 | Table2
--------------+-------------------
Name | InsuredName
Policy No | Pol_No
Benefit | InsuredBenefit
Age | InsuredAge
Table2
Code:
InsureName | Pol_No | InsuredBenefit | InsuredAge
--------------+--------------+----------------------+----------------
Chris | 123 | Death | 21
Jane | 456 | TPD | 34
Adam | 789 | DD | 55
Any idea? I know this can be done in queries but as the boss wants it to be automated, what i can think of is VBA.
Appreciate if someone can help me on this.

Last edited by a moderator: