User Profile

Collapse

Profile Sidebar

Collapse
PeterW
PeterW
Last Activity: Aug 1 '07, 11:09 AM
Joined: Aug 30 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • PeterW
    replied to Access Printer Preview
    If the report has always 3 pages, with the same content, then you can try to split it into 2 reports, one for the first 2 pages and the other for the third page. Each of them, of course, can then be designed separately. To print them you can put the printing commands one after the other, so that when you press the button (or whatever you do to print), the final result will be 3 pages, formatted as you desire.
    See more | Go to post

    Leave a comment:


  • Hi,
    Here is the beginning of the class object, including the form_current:

    Option Compare Database

    ' Declare an instance of our class
    Private CF As clsConditionalF ormattingDataSh eetView


    Private Sub Form_Current()
    ' Call our redraw function.
    ' We have to do this here because of a bug using
    ' Withevents to sink a Form's events from a Class module.
    CF.Redraw...
    See more | Go to post

    Leave a comment:


  • PeterW
    started a topic Using Stephen Leban's A2KConditionalFormatting

    Using Stephen Leban's A2KConditionalFormatting

    Hi all,
    Lately I used Stephen Leban's A2KConditionalF ormatting example to highlight the current row in a continuous form (Access 2k) and it worked perfectly. The only problem is that the properties of fonts in the text boxes on the highlighted row (color, bold, italic) are disabled. I know I have to insert the commands needed to enable the properties, but I couldn't find a suitable event for this.

    Any ideas ?
    Thanks
    See more | Go to post

  • Thanks, but it doesn't work. Anyway, meanwhile the user has changed his requirements and the color issue has been dropped.

    Thanks again
    See more | Go to post

    Leave a comment:


  • PeterW
    started a topic Different background colors in a continuous form

    Different background colors in a continuous form

    Hi everybody,

    I know this issue has already been posted by others and I viewed all the threads dealing with it, but I still couldn't find the whole answer to my problem.

    So here we go:
    I have a continuous form named frmEmployees, which has 4 controls: EmployeeNumber, EmployeeName, EmployeeType and Dept. The form is sorted alphabetically and there are 3 employee types. What I need is to have a different background...
    See more | Go to post
No activity results to display
Show More
Working...