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. mdarren

    exporting to word or html

    Falcon is correct that Snapshot viewer comes with Office installs 2000 and later. You can get an accurate representation of your report by creating a pdf. Unfortunately, Access does not make this as easy as does Word or Excel. As with those applications, you must have Adobe Acrobat installed...
  2. mdarren

    exporting to word or html

    You could try this code. MS says .snp (snapshot) files can be published to the web as easily as HTML. This is good for static reports only: DoCmd.OutputTo acOutputReport, "SpecSheet", acFormatSNP The final part of this argument would be , "c:\my documents\specsheet" or...
  3. mdarren

    NEED HELP Synchronizing two Subreports

    Melissa, I do a lot of work with reports and subreports, but I don't understand what you mean by "synchronizing" the subreports. Can you be more specific about what you are trying to accomplish? Describe what it is doing now and what it is you want it to do.
  4. mdarren

    Calculating a Correlation Coefficient

    Thank you for your advice. I'll give it a shot. If it doesn't work, I may keep the query and push this function back to the DBA to perform in Excel. Matthew
  5. mdarren

    Calculating a Correlation Coefficient

    I have two sets of data on which I need to calculate the correlation coefficient on a report. In Excel, this would be =Correl(B3:B25,D3:D25) However, I can't seem to find a similar built-in Correl function in Access and, not being a math wizard, I can't seem to decipher the various examples...
  6. mdarren

    Columns in SubReports

    Lionel, thank you for pointing me in the right direction. I tried this and it still did not work - MS says I must remove controls for pictures in my mainreport, but I have a watermark (embedded picture) that might be preventing the solution from working. Glad to know that this is a "known...
  7. mdarren

    Columns in SubReports

    My subreport has 2 columns which displays correctly when I run just the subreport. When I run the main report (which contains the subreport in the detail section), the subreport is ignoring the columns. I can't columnize the main report because of the complicated layout, watermark, etc. Why...

Part and Inventory Search

Back
Top