Search results

  1. R

    Calculating in a Query

    Ok..I am stuck.... I need to calculate labor costs in a query based on the Length of a counter top.. I would like to make a module to do the calculations for me, but I am having a tough time getting it to work.. I made my Module, but when I call it from the Query, it tells me I need to define...
  2. R

    Emailing Report Question

    How do I change the file name of a report I am sending.. it defaults to the Query name that the report is based on.. I would like to change it to either a default name(Robs Report.snp) or have it use a filed name from the report(jobname.snp).. Here is the code I am using... Dim stDocName As...
  3. R

    pop up calculator

    Is there a function or a button I can add that will pop-up a calculator..let the user do some calculations and then paste it to a box??? I need to calculate Square footage of counter tops and instead of them using a calculator then having to type the number in, they can just use the button...
  4. R

    Drawing in Access

    I work at a Solid Surface fabrication shop in NJ, where we make Kitchen and bathroom countertops....Is there a way I can have users input dimensions into a form and have access draw a counter top from those measurements??? I have seen it done in other programs, but have no clue on where to...
  5. R

    Sort by color then count of color..

    I am having a brain fart and can't figure this out.. I have a database with kitchen orders in it.. I need to make a Query that sorts the kitchens by color and tells me how many of each color.. Can someone point me in the right direction.. Thanks
  6. R

    OLE Image and faxing

    Here is a good one.. I have set up Access to fax a report.. It works great except our compqny logo does not appear on the fax.. The logo is an OLE Image.. I though it was Win Fax at first..but if I fax from word or any other program, it works fine.. If I export the document to snapshot viewer it...
  7. R

    Setting criteria from a form to run a Query

    I want to open a form and fill in a few check boxes..Then hit a button to print out a report based on the criteria I checked off.. For example.. I want to print out who we have quoted in the past week in New Jersey.. I can make a query and run it, and it works fine.. But I want to make it simple...
  8. R

    Converting Decimals to Fractions

    I am using Access to price out Corian vanity tops. Its working great, except that I need to input thye sizes in Decimals..Is there a way I can use fractions?? I know in Excel there is a command that I can change to convert it to a fraction..Is there a way in Access??
Top Bottom