Hello,
My current task using Microsoft Access 2007, a program that I have never used, is to create 2 tables, (currently named MQL and DNA (will stay as acronyms for sensitivity reasons)), and then once certain criteria is met, (criteria being a certain situation, nothing to actually do with numbers or orders placed), is to move a record, (name and other information), from 'MQL' to 'DNA' while deleting that record from 'MQL, whilst generating an object that appears as a letter that will be filled in with the information found in the moved record. I know it sounds complicated, but it looks really simple in my head, I just don't know what I am really doing, so it may be much more difficult than it sounds. The only reason I am using Access and trying to accomplish this is because my supervisor wants it done this way, and to make it easy for any user to generate this task of moving someone from one roster to another while generating a letter with a click of a button; I am guessing it is out of pure laziness, but I have learned not to ask too many questions in my line of work.
Basically the process I have in my head is this:
1. MQL Roster has 200 names, it is pretty much a constant with a little editing here and there.
2. Something happens, and an individual needs to be moved from the MQL Roster to the DNA Roster, (which contains less than 5 names usually).
3. I bring up the Database and the Switchboard greets me. I click on the 'Start DNA procedure' button.
4. That button brings me to a SOMETHING where I can search for the individual's name.
5. Once I find that individual's record, I click another button labeled 'DNA.'
6. When I click it, the record is moved, (as in copies, then deletes the original), from the 'MQL Roster' to the 'DNA Roster', and it generates an object that appears to be a letter, where there is a main document already stored, and this process fills out the specific information. (I have found that the 'Mail Merge' function used with Microsoft Word works well, but I need it to generate only one letter that is printable. It doesn't have to be an actual letter, just something containing the main document information, that fills out the specific fields labeled and makes it printable.)
Again, my supervisor wants all of 'step 6' to happen with virtually one click of a button, or at least something that is incredibly easy to use to anyone without any knowledge of Access.
Sorry for the length, but I have been trying for days and days to figure out how to make this work, but I do not have any knowledge of programming, which may be the only way to make this work... if it IS even possible. Thank you for your time and I appreciate any help you can offer!