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

    iif function???

    Thanks Thamks a million John..it worked...really appreciate ure efforts
  3. S

    Outputting reports

    Thanks...although its not the perfect solution, it seems the best output format + ill probably just stick to it. but i just have 2 more quick q's: 1-can someone edit snapshot 2-isn't it possible to export to word and retain all the formatting
  4. S

    iif function???

    (Note: ive tried to make it as clear as possible but if you still don’t understand the problem pleases don’t waste your time and just leave it. Thanks anayway) This isn’t the real database-its just something I did in a few minutes but it shows exactly what my problem is. PLEASE FOLLOW THESE...
  5. S

    iif function???

    ok im abit busy 2day..ill send it 2morrow.thanks alot
  6. S

    iif function???

    let me just make it abit clearer...ive got an order form where details of the order are entered. sometimes a certain product is not in stock, in which case there is an option to put 'not available' next to eac product. now when a product is not available, a table (not an access table) appears in...
  7. S

    Shortcut

    Thanks the key press was the solution..i didn't check ot the create thing though
  8. 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
  9. S

    formula question

    THANKS alot...it worked
  10. S

    union query

    THANKS A MILLION...the *-1 did the trick...i just can't believe how easy it was but it just didn't click Once agains thasnks alot
  11. S

    formula question

    No...let me just make it clearer: the amount field has the totals, whilst the income/expenditure field only says whether it is income or expenditure
  12. 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...
  13. 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...
  14. 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...
  15. S

    date

    UNION QUERIES Thanks a lot…the union query was the solution and it worked. However ive got a few more questions concerning this topic and would appreciate if anyone could answer them: 1- I wanted to put a parameter on the query, but it wouldn’t work. So I created a normal query, added all...
  16. 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
  17. 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?????
  18. 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