i wish i could... but life isn't that easy....
i am trying to simplify 2 custom systems and make them work together.
efaxing and this proprietary medical manager transcription writer system..
the database is only on one computer...... and this is the reason for my
project.. so it will stay on only one computer.. not many... i don't really
want 50 copies of the db

2 questions though...
1. what is the best way to deploy my macro across the 50 computers
2. in reference to the thread i posted earlier today.. how can i select the
very first line in the word doc and put that value in a variable ?


thanks
daniel

Daniel O'Dorisio
dodorisio@h...
xxx-xxx-xxxx


-----Original Message-----
From: Pardee, Roy E [mailto:roy.e.pardee@l...]
Sent: Friday, May 25, 2001 12:59 PM
To: professional vb
Subject: [pro_vb] RE: need some direction form a expert


If it was me, I'd be most tempted to put all the code in an Access VBA
project & use automation to make Word & Outlook do what I needed.  The
runtime execution would likely be a bit slower than you'd get w/a compiled
VB .exe, but it'd be easier to get the whole picture of what the code was
doing (since all the code is in one place).  Plus you probably wouldn't have
to bother w/the package & destroy wizard to disseminate your app or its
updates.  It's also trivially simple to put up an editable data entry form.

But I'm probably just more comfortable w/Access.

Cheers,

-Roy

-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Thursday, May 24, 2001 2:39 PM
To: professional vb
Subject: [pro_vb] RE: need some direction form a expert


that is exactly what i did... and i am glad to find out that that is how it
is done:-) i was afraid i was doing something skewed... not to un common:-)

about the p.s

yeah.. i wish life was that simple!!!!
the problem lies in the fact that we are emailing word documents. so what i
am doing is:
in word i have created a macro that brings up a form to select the doctor
(list os drawn from the central db with ado code) that the word doc will be
sent to then they add as many doc's as they want. then they will click the
send button, and it will format the faxnumbers in the form that faxmail.com
wants them. attach the current document and then it will send it. so it
basically simplifies all the tasks... no more clicking send to mail as
attachment. and then clicking the 'to' button and selecting the doc. and
then adding the signature (for some reason when word creates the email the
default sig isnt used.. and that is our coverpage). i am hoping this little
deal.. whatever it it called.. will simplify the whole operation and a. make
all the users happy with the new paperless system. and b. get me a raise:-)

i have a general question though...
what would be the best way to do what i am doing.. use the macro to call an
outside program or just have word handle it all?
can an outside program be written and called from a word macro?

i also am going to need a button that will bring up a form to edit the
record.. and i figured vb would be a little faster then vba.. i dunno if
this assumption is correct. but is there a way that i can call a form from
another application?? use activex or something.

thanks!

daniel

Daniel O'Dorisio
dodorisio@h...
xxx-xxx-xxxx


-----Original Message-----
From: Pardee, Roy E [mailto:roy.e.pardee@l...]
Sent: Thursday, May 24, 2001 11:11 AM
To: professional vb
Subject: [pro_vb] RE: need some direction form a expert


If you set a reference to e.g., ADO in your Word project (or in Outlook for
that matter) you should be able to define recordsets against your access DB
& fill combo boxes programmatically with the .AddItem method, just as you
would in VB proper.

HTH,

-Roy

P.S. One other thing to consider--it may be easier to bring Outlook
functionality to Access than vice-versa.  For instance, putting a button on
an Access form that will generate an e-mail from the current user to an
address read out of a field is pretty simple (you can either do MAPI
automation, or just use Access' native DoCmd.SendObject command).

-----Original Message-----
From: Daniel O'Dorisio [mailto:dodorisio@h...]
Sent: Wednesday, May 23, 2001 6:53 PM
To: professional vb
Subject: [pro_vb] RE: need some direction form a expert


well i couldnt really find any shocking information on ldap. and i figure
since they have allready paid some access developer a good ammount of money
to develop this thing, we might as well stick to it. he has a bunch of
reports and macros built into it and i dont really feel like recreating the
same thing in ldap.. i cant even imagine formatting reports.. ugggg.

but thanks for the suggestion!! it would work beuatiful if we didnt allready
have this db (it is actually the marketing db, but everyone needs it)

but i still have a question.. i dunno if there is somone here that can help
me with this..
if i create a macro in word, is there a way either in word, or by using a
standalone app, to create a form that will be executed on the click of the
macro and will have a list box with multiple selections that the list comes
from a db, and then the user can click the certain person(s) and click ok.
then it will pass those values back to the macro and send the email(that the
macro creates) to those reciepients.

can that be done? i have toyed arround with the data controls in word vba..
but the dont seem to be fully functional. is there a way to use code to fill
a regular list box (kinda like we do in asp)

any help or pointers THANKS!!

daniel

Daniel O'Dorisio
dodorisio@h...
xxx-xxx-xxxx