Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MatthewsP

    How to control report page set-up with VBA?

    I found the answer I was looking for in thread702-560490. Big thank you to BobJacksonNCI!
  2. MatthewsP

    Need help with implementing chart in a subreport

    I have a subreport that I want to show as a graph. The source is a crosstab query that returns data looking like the following: ScenarioID Type Q1 Q2 Q3 Q4 -------------------------------------------------------- 1 Required # # #...
  3. MatthewsP

    How to control report page set-up with VBA?

    I am using Access 2000, and very often when I open a report in Preview mode, the report has lost its page margin and orientation settings. (For example, I have a report that is supposed to open in landscape and have 0.5 inch margins; about 1/3 of the time it opens in portrait with 1 inch...
  4. MatthewsP

    Taking the last part of a string from the right

    You were almost there. Use the InStrRev function: Function FixFileName(PathString As String) Dim LastBackslashPos As Integer LastBackslashPos = InStrRev(PathString, "\") If LastBackslashPos <= 0 Then FixFileName = CVErr(xlErrNA) Exit...

Part and Inventory Search

Back
Top