Question

  • Thread starter Thread starter M Phillips
  • Start date Start date
M

M Phillips

Is there any way to increase the length of a single form.

Problem:
Have a copy of forms that are three to six pages in
length not sure as to how to fit these together.

Thanks
Mike
 
Mike,

Long forms is one of the primary indictaions that the tables in a database are
incorrect. Take a look at the tables before spending too much time on the forms!
 
-----Original Message-----
Mike,

Long forms is one of the primary indictaions that the tables in a database are
incorrect. Take a look at the tables before spending too much time on the forms!


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com





.
Maybe I phrased the question wrong, what I have is a
Click to expand...
great deal of information to input, these are a type of
Social Services Form. If I create the form with the wiz I
get all the input fields but when I try to create the
output (Form/Report) which has to in court form I don't
have enough room to create it thereby loseing half the
output information.

Thanks
Mike
 
Mike,

Have you considered creating your Report in Word as a template (.dot) file,
with a Word Bookmark at every location where data must be input. You'll
continue to use Access to enter and store your data but would use Word
Automation from your Access database to fill in the template without losing
pagination or formatting. It will take some setup but the results could be
what you are looking for. Below is some code that you can use to
familiarize yourself with the concepts - it's really pretty easy.

SAMPLE:
First, in Access, create a form (if you do not already have one) with Name
and Address info on it. Then, in Word, create a Word template for your form
letter. For this example, the document name is C:\FormLetter.dot. In this
template, you'll use the Insert \ Bookmark command to create a bookmark at
each location in the text where you'll want to insert Access data.

In Access, open any Module in design view. Then select Tools|References and
make sure that you have a reference to the appropriate Word library. Look
for "Microsoft Word xx.x Object Library, where xx.x is the Word version
number. For this example, you will also need a reference to DAO.

' Behind a command button on your form, insert the following code.

BEGIN CODE SAMPLE:

Dim objWord As Object

' Open Microsoft Word using automation
Set objWord = New Word.Application

objWord.Documents.Add "c:\FormLetter.dot"
objWord.Visible = True

' The following code is generated from your Access form while it is
' manipulating an instance of Word.
' So, while it looks somewhat like VBA, it's really Word VBA.

If objWord.ActiveDocument.Bookmarks.Exists("FirstName") = True Then
objWord.ActiveDocument.Bookmarks("FirstName").Range.Text = me!FirstName
End If

If objWord.ActiveDocument.Bookmarks.Exists("LastName") = True Then
objWord.ActiveDocument.Bookmarks("LastName").Range.Text = me!LastName
End If

' ... continue reading data from form and inserting into bookmark

END CODE SAMPLE


hth,
 
Back
Top