Hello,
I am working on an incident form. I have 4 set text boxes and up to 4 drop-down boxes on the form. The user enters in the date then time. I have 4 option buttons for the user to select the number of security involved. When the user selects the number of security, the corrisponding drop-down boxes appear (eg. if they select 3 security, 3 drop-down boxes appear). The drop-down boxes have a list of names (populated by a query). The user enters in the title for the report (which is later used to save the document). The last text box the user enters in a description of what happened.
Once the user is done, i have this info populate an excel form (using a print button on the form). It is printed and saved. My boss is now telling me (if i can do it) he would like to be able to double click on the last text box and a word document appear (mostly for the Spell check and grammer feature of Word). I am pretty sure I can get the document to appear in the same space the text box was when the user double clicks it. I am not sure, however, how to get this info back to the same field as the text box, or if i can. Is this possible? Should I do it this way? Any suggestions would be awesome.
Also, he wants to be able to add pictures if needed. Can I save pictures in a table?
I hope this makes sense.
ANdrew
I am working on an incident form. I have 4 set text boxes and up to 4 drop-down boxes on the form. The user enters in the date then time. I have 4 option buttons for the user to select the number of security involved. When the user selects the number of security, the corrisponding drop-down boxes appear (eg. if they select 3 security, 3 drop-down boxes appear). The drop-down boxes have a list of names (populated by a query). The user enters in the title for the report (which is later used to save the document). The last text box the user enters in a description of what happened.
Once the user is done, i have this info populate an excel form (using a print button on the form). It is printed and saved. My boss is now telling me (if i can do it) he would like to be able to double click on the last text box and a word document appear (mostly for the Spell check and grammer feature of Word). I am pretty sure I can get the document to appear in the same space the text box was when the user double clicks it. I am not sure, however, how to get this info back to the same field as the text box, or if i can. Is this possible? Should I do it this way? Any suggestions would be awesome.
Also, he wants to be able to add pictures if needed. Can I save pictures in a table?
I hope this makes sense.
ANdrew
Comment