Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tonyflavell

    Change fixed url to a relative/dynamic url

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

    Day/date functions

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

    Path to MY DOCUMENTS

    I want to open an Excel sheet, from Access, which is in the MY DOCUMENTS directory. How do I specify this for the current profile? Eg: Dim objXL as Excel.Application Dim BaseDir as String BaseDir = "C:\My Documents\UsagesReport.xls") Set objXL = CreateObject("Excel.Application")...
  4. tonyflavell

    Excel formatting from Access

    I export a query from Access to an Excel sheet using "OutPutTo" and then use formatting commands to format the sheet. The problem is that the first time I export the query it remains unformatted, if I then repeat the export it formats perfectly however many times I run the query until Access is...
  5. tonyflavell

    Hide preloading forms - Acc97

    I wish to preload and hide 6 forms at startup either before the application main menu appears, or in the background with the application main menu displayed. I can't seem to achieve this without a great deal of annoying screen activity. The forms are seen to load and then disappear (with...

Part and Inventory Search

Back
Top