Recent content by Samual

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

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

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

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

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

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

Thanks the key press was the solution..i didn't check ot the create thing though

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

THANKS alot...it worked

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

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

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

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

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

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