Recent content by LJtechnical

Hi All, I have a report where depending on a form value I may or may not have the report footer.visible set to true. The problem I have is that when set to false the report displays 1 less than it should for the built in [Pages] function. The following highlights my problem: If actual Report...

Hi All, I have a successful report which lists products in a quotation entered via a form. This report can then be printed automatically to PDF format and hence emailed to customers. I would really like the report to include hyperlink information to the product information sheets on our...

Thanks for that. I was just using the wrong event it would seem. Still worthy of a star though.

Hi, I have a button which outputs a report to pdf, all works perfectly. Now I would like to enable the user to hold down the control key and click the same button to have the report out put to word. I'm fine with the output to word bit, but not so sure how or where to code the control key bit...

Hi All, I am trying to make a report print to PDF automatically using a record no: for the file name. The following code does the job quite well, by utilising the Rename command twice. stQuoteNum = Me![QuotationNo] stDocName = "QuotePDFUK" DoCmd.Rename stQuoteNum, acReport...

I think you have hit upon the problem, though it seems strange to me. It is the main form that is causing the warning the delete query works fine and produces no errors. For the main form record I have used both DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdDeleteRecord And...

Hi All, I have a form with a subform. On the main form I have delete button which runs an on click event as follows: a delete query to delete the asociated records of the subform. Select and Delete main record. Now this all seems to work fine but after the event has completed I get a message...

Hi All, I have a form - subform etc, I want to update the unit price on the continuos subform for each record when the currency is changed. The following After Update procedure changes only the record which is selected, yet when I step through the loop it seems to carry out the correct number...

Thanks Michael, Had thought is was as you say the order in which things occur, unfortunately the search engine is down at the moment so can't delve any deeper, will try later. LJTechnical

Hi All, I have a report, for quoting products with usual fields in the detail section, item number, description quantity etc. I want it to look like a table so I have lines between fields which works fine. However I have an additional field which may or may not contain information depending...

Thanks Phil, Unfortunately there is a mass of fields, which as you say makes the procedure slightly long winded. In the end I simply created two append queries with the quote number as the criteria. One query for the main form and another for the subform, works like a charm, I always overlook...

Hi All, I have a form "Quotes" and Subfom "Quote Content" I am trying to set up a method of revising the quotation i.e. copying the record to a new rec and changing the unique quote number(suffixing with R1 etc). The latter is quite simple, its the copying record bit thats causing me a...

Hi Tom In the decimal places properties change from auto to 0. LJT

Hi All, I have a form "Quotes" and Subfom "Quote Content" I am trying to set up a method of revising the quotation i.e. copying the record to a new rec and changing the unique quote number(suffixing with R1 etc). The latter is quite simple, its the copying recod bit thats causing me a headache...

Thanks Mr Ken Reay, A case of having stared at the problem so long, I couldnt see the woods for the trees. The main form had two controls displaying the quote number, one very small one barely visible to the naked eye, honestly! Thanks again