Search results for query: *

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

Hi again In practice, if the CounterTable in my earlier code is locked by a user, additional code to retry the CounterTable is not neccessary because "Number of Update Retries" is set to 4 at a "Update Refresh Interval" of 250 msec. This is easily far in excess of the time required to update...

Hi there You presumably have a table which has fields [ProductType] and [Manufacturer] for all the combinations. Your first drop-down menu sets the product type (say TV) your second drop-down menu would have the following SQL in the "RowSource" attribute. (set "RowSourceType" to "Table/Query")...

I have just read my post and realised that it gives the impression that the function should be called with "u" or "c" as parameters. To clarify:- CNames(1) returns the User and CNames(2) returns the Computer Name Sorry about this! Tony

Hi there I found that this works well for all versions of Access to get the "User" name and the "Computer" name for whatever reason. The declarations and the function must obviously be in the same module otherwise change "Private Declare Function" to "Declare Function". Private Declare...

Hi there Just noticed this thread. I developed a database for telephone sales for a local Health Spa. This system has 27 simultaneous users and after many trials the issue of duplicate records was eliminated by using the following code in the "OnLoad" attribute of the main entry form. Set MyDb...