[mso] Re: Word forms (from outlook forms)
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 3 Jan 2003 20:35:07 -0600
OK...sorry for the confusion, Bill, but that error is happening because
the NOTES field doesn't have anything entered and...like I said...I
didn't bother with any debugging in the quick demo and set up the form
as a sample where you'd fill out ALL fields to see how it worked. But
yes, I guess the notes should have also been turned off for...If
(whateverField) = "" then (don't mess up<g>).
Thanks for catching this. I'll update the demo and upload a revised
version in the next couple days.
In the meantime...when you get that error message, you should also get
an option button on the error message to DEBUG. If you click that
button, it will open the VBE and highlight the offending line of code.
When it does, you will be able to better see the problem. In this case,
it's the fact that the Notes field wasn't set to ignore if nothing was
in the field and the DB isn't set to accept a Null value. So, until I
upload a revised version, you'll either need to enter something into the
Notes field or comment out that line of code. At least that's the only
problem I see at this point with a quick run through it.
Hope this helps...
Dian Chapman
Technical Consultant, Instructor,
Microsoft MVP & TechTrax Editor
Word AutoForm/VBA eBook: http://www.mousetrax.com/books.html
Tutorial web site: http://www.mousetrax.com/techpage.html
TechTrax Ezine: http://www.mousetrax.com/techtrax/
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Bill Scott
Sent: Friday, January 03, 2003 7:07 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Word forms (from outlook forms)
Sorry meant clicked on the already entered ? button
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
