I Need Help
Registered User.
- Local time
- Today, 08:51
- Joined
- Apr 1, 2013
- Messages
- 17
Hi all, my name's Sam and I'd like to start my first post by saying thank you to the users of this forum, it's been so useful that I just had to join.
My dilemma starts with me taking on a job which was supposed to be a simple mail merge (which I planned on doing from excel). This was made more complicated as:
1-The amount of fields to be filled in for each case made a very ugly looking excel table so I had to switch to MS Access (which I am fairly new to) and create forms. I was able to create a button that carries out a single mail merge for the particular record being viewed (borrowed the code from this forum). One improvement I would like to make is that it is currently opening a 97-2003 document and I want to open a new format document which may allow use of more features
2-For each record I need to pick an institution (from another table). This second table contains the address of the institution )spread over 5 columns. I need the address included in the mailmerge but word only wants to link to the one table.
3-the end mail merge requires whole paragraphs to be changed depending on circumstances entered in the table. I would use a nice easy IF operation if it weren't for the fact that I need it to be based on two conditions. (maybe even 3 in some cases)
4-The first part of the document I need to fill the details in for is an already existing official document which contains check boxes. I would like these check boxes to be ticked (or not) depending on what is in the table. I have looked and cant seem to find any way to set conditions for these boxes.
5-I need to convert a date from my form e.g. 29/04/1963 into individual characters i.e. 2 9 0 4 1 9 6 and 3 to be put into 8 individual boxes in the document. I believe its called concatenation but I'm lost beyond that
6-They want this database to be shared securely between up to 5 people on a network with each person having their own login details. I'm not sure how to approach this
I realise its a lot to be putting in one thread but any help would be greatly appreciated.
Regards
Sam
My dilemma starts with me taking on a job which was supposed to be a simple mail merge (which I planned on doing from excel). This was made more complicated as:
1-The amount of fields to be filled in for each case made a very ugly looking excel table so I had to switch to MS Access (which I am fairly new to) and create forms. I was able to create a button that carries out a single mail merge for the particular record being viewed (borrowed the code from this forum). One improvement I would like to make is that it is currently opening a 97-2003 document and I want to open a new format document which may allow use of more features
2-For each record I need to pick an institution (from another table). This second table contains the address of the institution )spread over 5 columns. I need the address included in the mailmerge but word only wants to link to the one table.
3-the end mail merge requires whole paragraphs to be changed depending on circumstances entered in the table. I would use a nice easy IF operation if it weren't for the fact that I need it to be based on two conditions. (maybe even 3 in some cases)
4-The first part of the document I need to fill the details in for is an already existing official document which contains check boxes. I would like these check boxes to be ticked (or not) depending on what is in the table. I have looked and cant seem to find any way to set conditions for these boxes.
5-I need to convert a date from my form e.g. 29/04/1963 into individual characters i.e. 2 9 0 4 1 9 6 and 3 to be put into 8 individual boxes in the document. I believe its called concatenation but I'm lost beyond that
6-They want this database to be shared securely between up to 5 people on a network with each person having their own login details. I'm not sure how to approach this
I realise its a lot to be putting in one thread but any help would be greatly appreciated.
Regards
Sam
