Recent content by MikeRussell

OK I have sorted it out. Sorry if I wasted anybodies time. I should not be doing 'Loop While Dir <> ""' as this does in fact carry out another Dir request, but should use 'Loop while MyFile <> ""' cheers

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

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

Thanks guys, Madawc, I should have said that after restricting the records on the sub report, I then only wanted to display a summary field, so this solution probably wouldn't work. cheers. GMcNamara. Thanks this solution works a treat. cheers.

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

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?

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, , , &quot;Confirmation of Bank Account Transfer&quot;, emailtxt, False, False Tempemail is a...

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

Try Datediff() =DateDiff(&quot;d&quot;,[INDATE],[OUTDATE]) will give you the difference in days

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?

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

Construct a query containing only the Transc_no and Equipment_no fields, set this query to View Totals. Set the Transc_no field Total to 'Max' and the Equipment_no field to 'Group By'. Save this query as 'qryMaxTransc_no', which will produce the last Transc_no number for each Equipment_no...

Ken, I have just found my problem, I had compiled to a new directory and therefor the .rpt file was not in the same place as the .exe. My next problem is how to automate the output, database login etc. Cheers Mike.

Thank Ken, I am trying the first choice, compiled reports, at the moment and have downloaded the Report Compiler. Running the compiled report now gives me the following error 'Print Engine Error - Invalid File Name' I will do some investigation of this, but in the mean time if it means...

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