Search results

  1. S

    Automate exporting a report

    Hi! my company's just gone and bought Adobe Acrobat so that we can send our reports via e-mail woithout losing the formatting. previously we were using snapshot + i easily managed to automate exporting + e-mailing through a macro. however there's no such thing as exporting to pdf. so could...
  2. S

    Shortcut

    I have a quick simple q. ive got a main menu (form), and i would like it to open whenever i type a shortcut key,eg Ctrl+K Any help appreciated
  3. S

    formula question

    im not sure which function or formula will be able to do this, but im sure u can help me out. ive got the folloing in a report: Amount Income/Expenditure ............ ............................... ............ ............................ I want to calculate the profit, i.e...
  4. S

    union query

    Ive got a problem concerning union queries. I have a financial statement report based upon a union query which combines data from 4 tables. Its quite complicated, with a lot of calculations and parameters, but the basic structure is as follows: SELECT [Date], [Income], "" As Expenditure...
  5. S

    iif function???

    ive got an invoice for a mail-ordering system. ive also got a form to enter in the order details. if a certain condition is met i need a table with various headings and values to be inserted. if this condition is not met, i don't want the table to be inserted. i managed to do this by having IIf...
  6. S

    help

    is it possible to have a field in a table that performs a calculation because i have a 'total cost' field in a table, and in the corresponding form the calculations are performed and it givesthe total cost, but this is not shown on the table??? appreciate any help
  7. S

    blank pgs

    i recently put a page break in a report which works, but a blank pg is always printed at the end. can u help?????
  8. S

    date

    NEED MORE HELP: union queries the database is a bookshop. ive got a problem concerning 2 oif the tables: misc. expenditure (rent , bills etc.) + book expenditure (purchasing books fom suppliers). ive also done a report based upon a parametr query which allows produces details of expenditure in...
Back
Top Bottom