Recent content by Faberman

Hi, I have installed a 60-trial of Office 2007 to see if I can resolve a problem I currently have with Acc2000 : I currently use the "outputto" command in the Report_Page event of the report to output an RTF file, which is then converted to a PDF and then e-mailed to customers. i.e...

Not sure if this has been discussed already, forum searches yielded no results: I have an mdb that I have ported to SQL server. I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO. While it seems that most operations can be replicated using ADO...

Not sure if this has been discussed already, forum searches yielded no results: I have an mdb that I have ported to SQL server. I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO. While it seems that most operations can be replicated using ADO...

Not sure if this has been discussed already, forum searches yielded no results: I have an mdb that I have ported to SQL server. I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO. While it seems that most operations can be replicated using ADO...

Not sure if this has been discussed already, forum searches yielded no results: I have an mdb that I have ported to SQL server. I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO. While it seems that most operations can be replicated using ADO...

Not sure if this has been discussed already, forum searches yielded no results: I have an mdb that I have ported to SQL server. I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO. While it seems that most operations can be replicated using ADO...

Not sure if this has been discussed already, forum searches yielded no results: I have an mdb that I have ported to SQL server. I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO. While it seems that most operations can be replicated using ADO...

Not sure if this has been discussed already, forum searches yielded no results: I have an mdb that I have ported to SQL server. I would like to continue using Access as the front-end, and have begun to re-write the GUI using ADO. While it seems that most operations can be replicated using ADO...

Hi. I have a report, within which are 2 subreports. Each subreport is the result of a crosstab query. They sit side-by-side on the main report page. Each crosstab query produces monthly sales totals and a line total for the current year and the previous year. I would like to show the % sales...

WOW!! Thanks you EMP - the thread reference you advised me of - http://www.access-programmers.co.uk/...ad.php?t=64141 did the trick. I altered the query to : TRANSFORM nz(Sum(AmountQueryLastYear.SumOfAmount))+0 AS SumOfSumOfAmount SELECT AmountQueryLastYear.DeliveryName...

Thanks for coming back ReclusiveMonkey. I have copied the expression into a column in the query design grid and set the "total" option to "Expression". Running the query results in the same as before, a tabular result set with blanks where there are no values for a particular customer in a...

Hello. I have a simple crosstab query, which is designed to give a monthly total (numeric) and a yearly total for the value of orders placed by a number of customers. The query is based on another query which simply extracts order records for a particular year. For some customers, certain...