[mso] Re: Word forms (from outlook forms)
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 2 Jan 2003 19:15:41 -0600
OK...I'm assuming you mean the Please Fill Out This Form article # 5 for
Database Connectivity from my web site that is reference on the MVP
site, right?
OK...I have to check to where you're at in the code to see exactly what
you mean. However...as I've taught my students, consistency is a key to
knowing what you're doing and I know that I always write database codes
with names like FName and LName and bkCompany would be a bookmarked form
field within a form. So you're kinda talking apples and oranges here.
And in the code below...first and last names aren't in the code.
>>'set the form field's bookmarks to the results from the database field
variables
>>ActiveDocument.FormFields("bkCompany").Result = vCompany
The code you mentioned above says that you have an active document with
a form field called bkCompany. First question...do you have a form
active with a form field called bkCompany?
Next, it says to set the result of that field...assuming it exists...to
the value of the vCompany variable. Next question...do you HAVE a
variable called vCompany? Have you declared it and set some value to it?
Next question...what EXACTLY is the error you are getting? That error
can tell us what the problem is.
Now...as to the FName and LName is concerned...that SHOULD be the
database values. Do you have a database? In the database...do you have a
field called FName and one called LName? If the code are actually
bkFName and bkLName...then they would be bookmark fields in the form
itself.
So sorry, I'm still confused about what you mean?
Finally...you mention you cut/pasted some of the code from the
article...where did you put it? In your own code? If so...there could be
any number of reasons why the code isn't working if you rewrote the
code. I'd need to see ALL of it to see what might be the problem...or at
least know the error.
The code works when it's all in order the way I had it...so the problem
is to figure out what you're doing differently and what's missing in
your version of the code that's causing it not to work.
Let me know...
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: Thursday, January 02, 2003 6:57 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Outlook forms
Hi Dian:
I am working on the database ... form that you have available on the mvp
site .... I am through momentarily with the autoform ebook and trying to
get my contract/invoice functional I usually get only a short break this
time of year to get my software projects done ... on again off again'
so I went on to the database part ...
The Form I am working on is ClientInformationUpdateForm when I try to
see if the Stacy James entry is there the code that I cut and pasted
from That portion of the program dies at Activedocument. ....
'set the form field's bookmarks to the results from the database field
variables
ActiveDocument.FormFields("bkCompany").Result = vCompany
The VBA program debugger stops on the above place ... It does not have
The Fname and Lname field in the code ... so my questions is ... ??
Question: in the VBE code FName or Lname does not appear prior to
bkCompany ...... Is that done SomeWhere else??
Bill Scott
*************************************************************
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:
