Recent content by tonyflavell

I'm using a PageViewerWebPart to show a document when we have to edit it's properties. However I can't get to the document itself, only the library it's in. So the part shows the library, not the document. It would be nice to see the document, via embedded viewer, in that webpart, when...

If a query for a report returns "Friday" in a field, can someone tell me how do get it to display the day before in the report printout. ie "Thursday" or "Wednesday" in the query shows as "Tuesday" in the report.

Why use an invisible form? Why not create and compare recordsets, or have I misunderstood what you are trying to do? Regards Tony

Glad to have helped! Regards Tony

As long as it works - what the hell!! Regards Tony

Hi there Open the report in design mode, Goto File, Page Setup, select the "Page" tab, select "Use Specific Printer", selct the printer you want the report to go to. This will associate that printer with the report. Just a thought! Kind regards Tony

Fingers crossed. Thanks for the feedback, I appreciate it! Regards Tony

The only thing I can think is that the autoincrement is reset to the last record + 1 if the database is compacted. Could it be that records are removed from the table, which is then compacted, thereby changing the stored incremental number. Regards Tony

So what happens? Tony

Hi there Sorry, maybe I misread your original question. Do you mean that "item" is grouped, with "amount" sorted? Regards Tony

Hi there Surely your main sort should be on "item" and a subsort on "amount"? Regards Tony

Hi there I use the following code to add a new contact to Outlook. I'm sure it can be modified to do what you want with the inclusion of a loop through the table of names. Declarations Public golApp As Outlook.Application Public golNameSpace As Outlook.NameSpace Initialise Outlook Function...

Hi there Just an idea but say you had an [InvoiceDate] field in your query, you could create a field (say [Total]) in your query with the expression DSum("[FieldToSum]","Domain", "[Invoice Date] < " & Now()) This would create a running total in the "Total" field for every record as the...

Hi Look forward to your report! Regards Tony

Hi there What is copied and where it is pasted depends where the focus is at the time of processing the code. Presumably your main form has the focus after the "SelectRecord" command so it is the main form record which is copied, not the related subform record. You need to add code to give the...