Hello
I’ve managed to transfer data from MS Access to MS Word Table. I now can transfer the Franchisees Info, Shop info and Phone (MSISDN) info. I recorded a macro that selects the MSISDN and converts it to a nested table and then copies the nested table and rePastes it and then merge to the existing table.
The trouble I have now is:
1. Handling Null Values in my recordset so that ant Null values can be converted to zero Length string (“”). I tried the NZ() function but it does not seem to work. I’m probably doing it all wrong.
2. Counting the Number of records transferred so that I can
a. Select the correct number of records to convert into a nested table as above.
b. Limit the records for the table to 10. On the Final CSTO Agreement Schedule Template, if a Franchisee operates more than 10 phones in a shop, the norm is to duplicate the shop’s details on another table and insert the excess phones there.
3. How do I insert information for a second shop? Assuming a customer is operating two or more shops. Here I believe I need to change the cboSites Combo Box on frmFilterComboBox to a Multi-Select List Box allowing me to select more than one or All sites. I’m not sure how to do that though.
Any assistance will be appreciated.
I’ve managed to transfer data from MS Access to MS Word Table. I now can transfer the Franchisees Info, Shop info and Phone (MSISDN) info. I recorded a macro that selects the MSISDN and converts it to a nested table and then copies the nested table and rePastes it and then merge to the existing table.
The trouble I have now is:
1. Handling Null Values in my recordset so that ant Null values can be converted to zero Length string (“”). I tried the NZ() function but it does not seem to work. I’m probably doing it all wrong.
2. Counting the Number of records transferred so that I can
a. Select the correct number of records to convert into a nested table as above.
b. Limit the records for the table to 10. On the Final CSTO Agreement Schedule Template, if a Franchisee operates more than 10 phones in a shop, the norm is to duplicate the shop’s details on another table and insert the excess phones there.
3. How do I insert information for a second shop? Assuming a customer is operating two or more shops. Here I believe I need to change the cboSites Combo Box on frmFilterComboBox to a Multi-Select List Box allowing me to select more than one or All sites. I’m not sure how to do that though.
Any assistance will be appreciated.
