Some Advise

[Gunti]

Hi,

I've got a question. I'm fairly new to Access. I'll explain what i want and
i basicly would like one of you to answer if this is possible.
I want people to be able to check some checkboxes. After that click a button
whereafter access (or anything else??) generates a word .doc with preset text
blocks. I want to use this for creating letters and such. For starters, i'm
not even sure if this is possible in Access. What i want:


For example:
Listbox1: Choose kind of letter (preset by me)

Checkbox 1: Add block 'x' (a lap of text) to letter
Checkbox 2: Add textblock 'b' to letter

Button -> Generate letter.

Is there anyway to do this in access? I'm starting out with Access. If you
know an alternative this, of course, is also welcome. I'd also like an
impression of how difficult it is. It does need some kind of interaction
between word & access.

Greets,
Gunti

 

[Stefan Hoffmann]

hi Gunti,

For example:
Listbox1: Choose kind of letter (preset by me)

Checkbox 1: Add block 'x' (a lap of text) to letter
Checkbox 2: Add textblock 'b' to letter

This should be no problem for a beginner

Button -> Generate letter.

Is there anyway to do this in access? I'm starting out with Access.

You can do this using Word Automation:

http://msdn.microsoft.com/en-us/library/bb407305(VS.80).aspx

But it's not a beginner level task.


mfG
--> stefan <--

 

[Gunti]

Hi, thanks for replying. I do have a problem though, current version of
office is 2003. I would like to know if something similar is possible in
2003??

Greets,
Gunti

 

[Stefan Hoffmann]

hi Gunti,

Hi, thanks for replying. I do have a problem though, current version of
office is 2003. I would like to know if something similar is possible in
2003??

It's basically the same. You need to take a close look at the code examples.

First go to the VBA IDE, Tools, References and add the Microsoft Word 11
Library.

Then try this:

Option Compare Database
Option Explicit

Public Sub StartAndQuit()

Dim axWord As Word.Application

Set axWord = New Word.Application
axWord.Visible = True

MsgBox "Started..."

axWord.Quit

Set axWord = Nothing

End Sub


mfG
--> stefan <--

 

[Gunti]

Hi Stefan,
Thanks for writing me back again. After running through the tutorial it
seems that what i'm after is more difficult than i thought. I wont be able to
do this within the timeframe i'm in. Thanks for trying to help & maybe i'll
catch up some visual basic later.

Greets,
Gunti

 

[BruceM]

As you know, this is a free volunteer newsgroup. Trolling for business is
inappropriate, as you have been reminded time and again. I know the OP
spoke of dropping the project due to it being a bigger job than was first
anticipated, but that does not mean it's OK to solicit the job.
You were doing well for a few postings recently, giving advice without
soliciting, but it seems you're always ready to pounce.
I'll leave it to others to post links relevant to your history, if they are
so inclined.

 

[strive4peace]

Hi Gunti,

don't let VBA scare you off ... VBA is the easiest language, in my
opinion, to learn.

to get a good foundation, you need to become familar with the objects in
Access, like Tables, Queries, Forms, ... and understand the objects they
contain like fields, controls, and sections ... and then Properties and
Methods. Read this:

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

it just takes a bit of time, so plan to spend a day studying -- print
the links, get a highlighter, make a nice pot of tea, get comfy in your
favorite chair, relax ... and enjoy!

Warm Regards,
Crystal
remote programming and training

*
have an awesome day
*

 

[John... Visio MVP]

Hello Gunti,

If you REALLY NEED this, I can help you. I provide help with Access, Word
and Exxcel applications for a reasonable fee. I could create the
application you describe. My fee would be modest. If you want my help,
contact me.

Steve
(e-mail address removed)

These newsgroups are provided by Microsoft for FREE peer to peer support.
Stevie is a known troll who enjoys harrassing posters for work. He does work
of questionable value and has proven many times that he does not know what
he is talking about.

John... Visio MVP

 

[strive4peace]

Hi Steve,

It is not the same at all and, anyway, my siggy tag has been approved.
I give free advice in these forums and do not tell the poster to email
me and pay me for help as you do. Telling someone you will do work for
a fee is what is not allowed.

I do occasionally ask the poster to send me a database, but I provide my
comments back to the public newsgroup for all to benefit.

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[John... Visio MVP]

Take notice of Crystal's response in this thread. She always ends her
response with "remote programming and training" below her name. This is
clearly advertising! In this thread it is not even relevant to the subject
of the thread. Yet you say nothing about what she does!!

Steve

Stevie, we have gone this route with you many times in the past. What
Crystal has is a description of who she is. She never urges posters to email
her for help. She has too much class for that.

You on the other hand are always trolling for work, even when it is not
necessary. Why did you offer to convert a mailing list to an Access database
to a mailing list in the Word newuser newsgroup only a few weeks ago? That
was not asked for.

Go back on your medication and stop harrassing the posters.

John... Visio MVP

 

[Douglas J. Steele]

You just don't get it, do you Steve?

I used to feel sorry for you, but you're bringing this on yourself by your
pigheaded refusal to obey the rules.

 

[John... Visio MVP]

Crystal, you missed one point about "comments back to the public newsgroup".
You forgot to mention your modest fee --> FREE.

John... Visio MVP

 

[BruceM]

Crystal has given all sorts of free high-quality advice, including a
tutorial that has helped untold numbers of people trying to learn the basics
of Access. Post a by-line if you like, or include your web site link if you
ever get it up and running. Just don't solicit paid work here. We will
come after you every time.