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...
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, , , "Confirmation of Bank Account Transfer", 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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.