GETTING STRATED

[Frank Situmorang]

Hello,

I have typed on 2 pages words a simple operating manual of our new church
membership database.

How can we put this in a report to enable user to open it on the 1st button
of the switchboard.

Thanks in advance

 

[Golfinray]

Report wizard (click new, report, report wizard) and tell the report wizard
what table or query you want as the source of the report. Then tell the
wizard what particular fields you want in the report. Then you could use a
command button for the users to open the reports. There is also a command
button wizard. Follow the prompts.

 

[Frank Situmorang]

Golfinray, this is 2 pages words documentl, how can I put it on the report, I
kbow how to make a button to open the report, but the problem is how can I
put this 2 pages word document

I appreciate your idea

 

[Golfinray]

Are you trying to import Word documents into Access? If so, go to
file/external data/import and give it the file name of the word document. You
may also have to choose the format. It will import it as a table. You can
then build a form or report from the table. The command button is on the menu
bar for form or report. It has a wizard that walks you through it. Come back
if you have more questions.

 

[Evi]

Is Importing Word documents an option in later versions of Access,Golfinray?
I don't have it in Acc2000. The best it can offer, is text files.

I thought that Insert, Object, Word Document would be the way to put a Word
Document into a report - until I actually tried it! It will only display
the first page of the document, as far as I can see (unless I'm missing
something).
Evi

 

[Frank Situmorang]

Evi,

You are right, I have insert the word document in a form in continues form,
sot that user can just scroll down to read it.

My question, I have 2 pages, but I can only see 1 page. I appreciate your
help.

 

[Evi]

What version of Access do you have Frank? If it's later than 2000 then
follow Goldfinray's advice. All I can see in Acc2000 that you have to divide
your document into 2, Create a table with an OLE field, click on each field
and go to Insert Object. It looks dreadful! All the text has to be indented
because the record goes right up to the document's margin, looking as if you
had trimmed it badly. The scroll wheel on my mouse doesn't work - I don't
know if later versions of Access have sorted this out but none of the
versions I have used, have ever responded well to the scroll wheel.

Having said this, I've had better results for my Instructions, having a
table called Topics (so I can format my headings) which is linked to my
Instructions table. This contains the link field to Topic, a field called
PgNo so that I can arrange my text in order and a text field with a size of
255 (rather than memos, that way, the user can search the field)
I can then use a continuous form, making my text boxes white and making the
Topic field bold. Each paragraph in the Instructions is a new record and I
limit them to screen height for my user's convenience. I could also use a
Single Form if I wished and use a tab control to move through the pages or
have a list box to allow the user to navigate to the different topics.

It is very limiting No cute formatting within each paragraph, only 3 text
styles, one for the document title - a label, one of the topic headers and
one for the topic but it does not bloat the database. You can Lock the
fields if you don't want users to edit them.

I'll be following this thread to see if the later versions of Access have
anything better to offer.

Evi

 

[Frank Situmorang]

Thanks Evi, I have ver 2000 and what I did is to split it into 2 word file
and I put
1 page/file in a form then I put command button to go to the next form and
v.v. use command button again to retun it back to the 1st form, my operating
manual is so simple