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

    Dir() skipping alternate files in a directory!

    I have got some code that should cycle through a directory returning every *.rtf file name in turn, but it skips every other one. Thier are forty *.rtf files in the directory, but only 20 get returned, being alternate ones. The relevant section of the code is: myfile = "" Do If myfile =...
  2. MikeRussell

    Passing a parameter to a sub report

    I have a variable in my main report @enddate, which stores a date value, this is currently in the Page Header. My main report is based on many tables, but the main one is STMTRPT. I have created a parameter format in my subreport Pm-@enddate. The subreport is based on a single table CFLOWS...
  3. MikeRussell

    Restrict a sub report by a variable in the main report

    I have a variable in my main report @enddate, which stores a date value, this is currently in the Page Header. My main report is based on many tables, but the main one is STMTRPT. The main report/sub report link is STMTRPT.DEAL_NO -> CFLOWS.DEAL_NO My sub report is based only on the CFLOWS...
  4. MikeRussell

    Can you format a Memo field?

    I want to privide a form for my users that allows them a free text field (Memo?) for input. I would also like them to be able to format their text e.g. the use of bold, allignment and choice of font. Can this be done?
  5. MikeRussell

    SendObject does not work more than Once in a loop

    I am using the following code in a loop. It worked fine with MSAccess2000, WinNT and Outlook98, but now doesn't work with MSAccess2000, Win2000 and Outlook2000. DoCmd.SendObject , , , Tempemail, , , "Confirmation of Bank Account Transfer", emailtxt, False, False Tempemail is a...
  6. MikeRussell

    Query runs like a dog in 2000!

    I have converted our mdb from 97 to 2000. Most went smoothly but, a query that is linked to two ORACLE tables, via the Merant ODBC driver, now runs like a dog. It used to take about 3 mins, but now runs for over two hours and retrieves every record in the linked table! Any ideas. We are...
  7. MikeRussell

    Can I export many Report Definitions?

    I have 180 reports in the same directory and I want to exort the Report Definition for them all. Can I do this without having to load each reort individually?
  8. MikeRussell

    97 to 2000 convert failes with no message

    I am trying to convert an Access97 database to an Access2000 database on a machine running Office 97 under NT workstation with Access2000 installed. The convert seems to be running ok, but then just stops, no messages or anything and no new converted mdb either. MSDN suggests I need Office2000...
  9. MikeRussell

    Clarification sought on Runtimes

    Can anyone tell me exactly what is meant by “Royalty-free runtimes”. I am currently on V8 Professional and want to know if I need to upgrade to the Developers version. I want to design a report and save it, but not with the data, so that when my users run the report it queries the database...

Part and Inventory Search

Back
Top