Few questions regarding Reports

[Kitty]

1) i hv to export few reports daily to a certain location on my company's
network.. can i set something to let access do it automatically itself?

2) i hv a report which contains fifty something pages, and i need to export
each page as 1 file (i.e. 5X files).. can access do like that instead of
export all pages into 1 file?

3) how can i set to display 3 records only in each pages even the page still
have space to display the 4th record?

4) in page setup's column.. i can change the column width but may i know
what's the function of HEIGHT?? as i found nothing change even i hv changed
the height size.

thx and regards

 

[Arvin Meyer]

I won't all write the code for you, but I'll point you in the right
direction (or at least a good workable direction):

1) i hv to export few reports daily to a certain location on my company's
network.. can i set something to let access do it automatically itself?

Create a form with a Timer event which performs an action at a certain time.
Here's an example of similar code:

Sub Form_Timer ()
Dim AppTime As Double
If IsNull(Me!txtTime) Then Exit Sub

AppTime = CDbl(Me!txtTime) * 86400 ' number of seconds in a day
If Timer >= (AppTime - 300) Then ' 60 * number of minutes
MsgBox "You have an appointment at " & Me!txtTime, , "REMINDER"

Me.TimerInterval = 0 ' Reset interval to
stop checking
End If
End Sub

2) i hv a report which contains fifty something pages, and i need to export
each page as 1 file (i.e. 5X files).. can access do like that instead of
export all pages into 1 file?

If you export the report as HTML, Access will create a separate web page for
each instead of 1 long report. Other than that, you'll need to create a loop
with the ID's of each record and run the report once for each ID.

3) how can i set to display 3 records only in each pages even the page still
have space to display the 4th record?

Use the OnFormat event to count the records and move to the next page as
soon as there are 3 records. Something like:

If Me!MyControl Mod 3 = 0 Then
Me!MyPageBreak.Visible = -1
Else
Me!MyPageBreak.Visible = 0
End If

4) in page setup's column.. i can change the column width but may i know
what's the function of HEIGHT?? as i found nothing change even i hv changed
the height size.

You can change a section height, or you can use the CanGrow property to
allow the section to grow as needed.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access