L
Linda
I want to beable to create a form that is used every day with fill in the
blanks, then beable to delete the answers and fill in again.
blanks, then beable to delete the answers and fill in again.
A
Andrew Watt [MVP - InfoPath]
Linda,
What do you want to do with the form after you fill in the blanks?
Send it somewhere?
Andrew Watt
MVP - InfoPath
L
Linda
I want to beable to e-mail it to a customer then erase the blanks and fill it
in with the info needed for the next person.
in with the info needed for the next person.
A
Andrew Watt [MVP - InfoPath]
You could create some custom stationery and create a new page using
that custom stationery. Then email it.
Then either keep or delete the page. Create a new page (Ctrl+N) using
the custom stationery and fill in the blanks on it.
There is a range of custom stationery online, see
http://office.microsoft.com/en-gb/results.aspx?Scope=TC&Query=TC&Origin=EC790013251033&app=sc
There are no textbox form controls, dropdowns etc in OneNote.
For simple documents it may be adequate for what you need.
Andrew Watt
MVP - InfoPath
that custom stationery. Then email it.
Then either keep or delete the page. Create a new page (Ctrl+N) using
the custom stationery and fill in the blanks on it.
There is a range of custom stationery online, see
http://office.microsoft.com/en-gb/results.aspx?Scope=TC&Query=TC&Origin=EC790013251033&app=sc
There are no textbox form controls, dropdowns etc in OneNote.
For simple documents it may be adequate for what you need.
Andrew Watt
MVP - InfoPath
L
Linda
What program do I need to use to create a fill in the blanks - form. I am
not talking a simple form. This is something I do every day at work. There is
alot of questions, prices etc. I want to make this form up myself, and
beable to have the other people in the office that use this form, beable to
turn the computer on - fill in the form - email it to our customers - and
then erase the form to be used again.
not talking a simple form. This is something I do every day at work. There is
alot of questions, prices etc. I want to make this form up myself, and
beable to have the other people in the office that use this form, beable to
turn the computer on - fill in the form - email it to our customers - and
then erase the form to be used again.
A
Andrew Watt [MVP - InfoPath]
What do the people that you are emailing the form to need to do with
it?
Do they fill in data too? Or simply read the data in it?
Do they need to digitally sign the form?
Andrew Watt
MVP - InfoPath
it?
Do they fill in data too? Or simply read the data in it?
Do they need to digitally sign the form?
Andrew Watt
MVP - InfoPath
E
EMRhelp.org
"There are no textbox form controls, dropdowns etc in OneNote. "
There should be !
There should be !
L
Linda
I work for a printing co. We have customers fax us job spects. for pricing on
the job. We have a quote sheet we fill out with all info and prices and fax
it back to the customer. This is all hand written. If I can create a fill
in the blank form on the computer, that can be filled in - erased and used
again & again - we can e-mail the quote sheet back to the customer, plus it
will not have to be hand written
the job. We have a quote sheet we fill out with all info and prices and fax
it back to the customer. This is all hand written. If I can create a fill
in the blank form on the computer, that can be filled in - erased and used
again & again - we can e-mail the quote sheet back to the customer, plus it
will not have to be hand written
E
EMRhelp.org
Wouldn't you want to also save your quote ?
You need a database.
Sadly, another error in OneNote is that it doesnt connect to databases.
If OneNote could function well as a GUI to an access database it would
be a killer app.
However, MS doesnt even include VBA into OneNote. (VERY SAD).
You need a database.
Sadly, another error in OneNote is that it doesnt connect to databases.
If OneNote could function well as a GUI to an access database it would
be a killer app.
However, MS doesnt even include VBA into OneNote. (VERY SAD).
E
EMRhelp.org
Linda, you should do price quotes in Excel or Microsoft Access.
Excel would be the easist, Access would be the most powerful.
OneNote is the wrong app for you, especially in it's very junior state
of development.
Excel would be the easist, Access would be the most powerful.
OneNote is the wrong app for you, especially in it's very junior state
of development.
A
Andrew Watt [MVP - InfoPath]
Linda,
Why not use Word? It has forms functionality that may be enough for
the needs you describe.
Andrew Watt
MVP - InfoPath
Why not use Word? It has forms functionality that may be enough for
the needs you describe.
Andrew Watt
MVP - InfoPath
E
EMRhelp.org
"Why not use Word? It has forms functionality that may be enough for
the needs you describe. "
The forms in Word are horrible.
the needs you describe. "
The forms in Word are horrible.
C
Chris H.
Linda, it sounds like you're a good candidate for the forms creator from
Active Ink Software: http://www.activeinksoftware.com/ They enable us to
do some really magical things with forms. You may want to check them out.
--
Chris H.
Microsoft Windows MVP/Tablet PC
Tablet Creations - http://nicecreations.us/
Associate Expert
Expert Zone -
Active Ink Software: http://www.activeinksoftware.com/ They enable us to
do some really magical things with forms. You may want to check them out.
--
Chris H.
Microsoft Windows MVP/Tablet PC
Tablet Creations - http://nicecreations.us/
Associate Expert
Expert Zone -
E
EMRhelp.org
ActiveInk Software is quite expensive.
Linda, you do realize most people type faster than they can write, dont
you ?
Linda, you do realize most people type faster than they can write, dont
you ?
E
EMRhelp.org
Are you using a Tablet PC ?
A
Andrew Watt [MVP - InfoPath]
Jason,
What do you think would be the best solution for Linda's relatively
simple use case?
Andrew Watt
MVP - InfoPath
R
RK Henry
Ok. You want something that can do calculations, store the result in
OneNote, and also send E-mail. And apparently you want something
relatively cheap and low volume. Excel might work, with a macro that
would insert the resulting page into OneNote. I notice that someone is
selling a book on how to do this in Excel.
http://www.mrexcel.com/tip078.shtml I can't comment on its accuracy or
usefulness.
I've experimented with automatically inserting pages into OneNote with
Visual Basic, as described in a Microsoft article (The code in the
article has a minor bug in it. In the VBA code, "objectGuid" should
read "pageGuid".).
http://msdn.microsoft.com/office/un...en-us/odc_on2003_ta/html/odc_on_importapi.asp
It works with Microsoft Visual Studio but I haven't tried it with
Excel's macros as described in the book mentioned above. I'm not that
familiar with VBA, more familiar with C++, MFC, or Java, but it's
gratifying to know that OneNote can be used this way. Could write an
entire application in VBA, C#, or even a Windows MFC application that
would do the whole thing. That might require the help of a programmer
though. Even if the application handled everything with a database and
automatic e-mail system, it still might be nice to import the result
into OneNote so management could peruse a notebook filled with reports
of what's going on. As I think about it, OneNote could make a nice
report writer for lots of business applications. Once the application
added a a page reporting on a sale or other activity, a manager could
annotate it with free-form notes that usually aren't permitted in more
structured database applications.
For a simpler solution, you'd probably set up your price list in
Excel, maybe a form under macro control that you'd fill in with the
details, and a button that you'd click once you'd entered everything.
The Excel macro would calculate the prices, format a response, and
import the result into OneNote.
This solution is low volume, ok for a small company but a lot of work
if the company grows larger. Have you investigated some of the
software packages designed for printing companies?
Bob Henry
OneNote, and also send E-mail. And apparently you want something
relatively cheap and low volume. Excel might work, with a macro that
would insert the resulting page into OneNote. I notice that someone is
selling a book on how to do this in Excel.
http://www.mrexcel.com/tip078.shtml I can't comment on its accuracy or
usefulness.
I've experimented with automatically inserting pages into OneNote with
Visual Basic, as described in a Microsoft article (The code in the
article has a minor bug in it. In the VBA code, "objectGuid" should
read "pageGuid".).
http://msdn.microsoft.com/office/un...en-us/odc_on2003_ta/html/odc_on_importapi.asp
It works with Microsoft Visual Studio but I haven't tried it with
Excel's macros as described in the book mentioned above. I'm not that
familiar with VBA, more familiar with C++, MFC, or Java, but it's
gratifying to know that OneNote can be used this way. Could write an
entire application in VBA, C#, or even a Windows MFC application that
would do the whole thing. That might require the help of a programmer
though. Even if the application handled everything with a database and
automatic e-mail system, it still might be nice to import the result
into OneNote so management could peruse a notebook filled with reports
of what's going on. As I think about it, OneNote could make a nice
report writer for lots of business applications. Once the application
added a a page reporting on a sale or other activity, a manager could
annotate it with free-form notes that usually aren't permitted in more
structured database applications.
For a simpler solution, you'd probably set up your price list in
Excel, maybe a form under macro control that you'd fill in with the
details, and a button that you'd click once you'd entered everything.
The Excel macro would calculate the prices, format a response, and
import the result into OneNote.
This solution is low volume, ok for a small company but a lot of work
if the company grows larger. Have you investigated some of the
software packages designed for printing companies?
Bob Henry
K
Kathy Jacobs
Bob,
I may be biased, but I am pretty sure that the examples in the book work.
I am also pretty sure that they would work for what Linda needs. My
suggestion, Set up a piece of stationery where you can fill in the other
fields, then use Mr. Excel's information to puts the price information to a
new page. The final step would be to copy the pushed information to the page
with the stationery.
--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Co-author of Unleash the Power of OneNote- Available now from Holy Macro!
Books
Get OneNote answers at http://www.onenoteanswers.com
I may be biased, but I am pretty sure that the examples in the book work.
I am also pretty sure that they would work for what Linda needs. My
suggestion, Set up a piece of stationery where you can fill in the other
fields, then use Mr. Excel's information to puts the price information to a
new page. The final step would be to copy the pushed information to the page
with the stationery.
--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Co-author of Unleash the Power of OneNote- Available now from Holy Macro!
Books
Get OneNote answers at http://www.onenoteanswers.com
B
Ben M. Schorr - MVP
EMRhelp.org said:
http://www.microsoft.com/infopath
--
Aloha,
-Ben-
Ben M. Schorr, OneNote-MVP
Roland Schorr & Tower
http://www.rolandschorr.com
Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.htm
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
A
Andrew Watt [MVP - InfoPath]
I would simply comment that InfoPath is not, in my view, the
appropriate solution for the use case that Linda described. Its
strengths lie in larger scale use.
Andrew Watt
MVP - InfoPath