Search results

  1. B

    Snapshot Viewer

    On this board, David R mentioned something called snapshot viewer. What exactly is that and where could I get info on it ?
  2. B

    Report Background

    Yeah it worked thank you !
  3. B

    Report Background

    *BUMP*
  4. B

    Output to Word wrong

    Is the snapshot viewer included in Access ? Anyway what is done is done, and it currently works great I can send it to anyone who has an internet browser and they can see the report which is great since Im not dealing with tech poeple.
  5. B

    Output to Word wrong

    I only had big problems trying to view reports in Word with the Office liason thingy. I tried several things but the reports I use are image intensive, use lines, rectangles and lots of formating which makes them untralatable in Word. I either manually convert queries in Excel files, transform...
  6. B

    ABS Function

    The ABS function returns the absolute value of a number, this is simply the number without a minus sign if there was one. For exemple : Before After 1 1 12 12 -34 34 -23 23 It has limited uses.
  7. B

    Displaying 2 graphs on a report

    You just create one graph, then create another. You first click on the graph button specify the values then do it again... If it`s too squeezed either reduce the size of both graph or place one above the other instead of side to side.
  8. B

    Access Reports to PDF

    The way I do it is I have Adode Distiller ( PDF Writer ) and after my report is created, I go in print and Distiller is listed as a printer, you select print in file and your report is now a pdf. I don't know how to automate it since PDF is Adode propriety format. Which makes it kinda of hard...
  9. B

    Report Background

    What is the easiest way to set a background for a report via programmation ? I don't want to set it manually when I create the report because I want to user to select the background he wants in a form. I have tried playing with the picture property by doing : Me.Picture =...
  10. B

    Basing a recordset on a query

    Yeah it worked, im ok, thanks for the awnser.
  11. B

    Basing a recordset on a query

    Unfortuntly the current use does not use a report. I am using the recordset to write to a text document HTML tags. Also when I try to set the query as the form as record source I get an error. The reason is that the query uses information from a a field on the form that is not set when the forms...
  12. B

    Basing a recordset on a query

    Hi, I have a problem with an access application. What I want to do is create a recordset and instead of doing what I am currently doing : Dim rsProduits As New Recordset stQuery = "SELECT * FROM Produits WHERE " & WHEREClause & " ORDER BY NoSousCategorie;" rsProduits.Open stQuery...
Back
Top Bottom