If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
repeated records when i copied the controls.b
i made a costum report of many controls in the detail section and it fits
five records max based on a query, my problem is if there is less than five records then it leaves the remaining sheet blank, i want to be able to have five records on a sheet even if there is no data in the rest of them so that data can be filled by hand later on. i tried copying all the controls and pasting them but it only displays one record repeated 5 times. thanks for ur help |
#2
|
|||
|
|||
You haven't really said what you would expect to see in the blank areas. You
could add lines with code like below. The code could be modified to print any text or whatever. '--------------------------------------------------------------------------- ------------ ' Procedure : Report_Page ' DateTime : 8/9/2004 14:13 ' Author : hookomd ' Purpose : '--------------------------------------------------------------------------- ------------ ' Private Sub Report_Page() Dim intNumLines As Integer Dim intLineNum As Integer Dim intDetailHeight As Integer Dim intPageHeadHeight As Integer On Error GoTo Report_Page_Error intNumLines = 5 intDetailHeight = Me.Section(acDetail).Height intPageHeadHeight = Me.Section(3).Height For intLineNum = 1 To intNumLines Me.Line (0, intPageHeadHeight + intLineNum * intDetailHeight)- _ Step(Me.Width, 0) Next On Error GoTo 0 Exit Sub Report_Page_Error: Select Case Err Case 2462 'no page header intPageHeadHeight = 0 Resume Next End Select MsgBox "Error " & Err.Number & " (" & Err.Description & _ ") in procedure Report_Page of VBA Document Report_Report1" End Sub -- Duane Hookom MS Access MVP -- "Alexm" wrote in message ... i made a costum report of many controls in the detail section and it fits five records max based on a query, my problem is if there is less than five records then it leaves the remaining sheet blank, i want to be able to have five records on a sheet even if there is no data in the rest of them so that data can be filled by hand later on. i tried copying all the controls and pasting them but it only displays one record repeated 5 times. thanks for ur help |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
New records can't be seen | rleblanc | Using Forms | 6 | August 14th, 2004 02:43 PM |
append Query duplicating records | Alex | Running & Setting Up Queries | 1 | July 8th, 2004 01:31 PM |
Copying new records | John | General Discussion | 0 | June 25th, 2004 04:02 PM |
How to Manipulate the group and sorting in a report? | Jorge Novoa | Using Forms | 2 | June 9th, 2004 01:12 AM |
Finding and deleting repeated records in WORD Document. | Richard | General Discussion | 1 | May 23rd, 2004 02:01 AM |