Recent content by Evan_S

I have "Subreport B" within "Report A" I would like to be able to suppress the printing of "Subreport B" depending on a value displayed on "Report A" I don't seem to be able to get the syntax correct. Is it possible to do? Thanks, Evan

I have a subreport in the "footer" section of the main report. The main report and the subreport have different page header fields. Everything works fine with this exception: On the first page of the subreport (above the "report header" the page header of the main report prints (only on the...

Originally, I did try to link the tables, however I couldn't use the "seek" command with the linked tables. I also couldn't create a needed "index" on the linked table. I did find a solution to that problem posted somewhere, that was supposed to let you use "seek" and "index" but I couldn't get...

Thanks for the quick reply. What do you mean by "build up a connection?" Do I have to open the database first, before I attempt the TransferDatabase? I'm a little unclear....but that's not unusual. Thanks again. Evan

DoCmd.TransferDatabase acImport, "c:\myfolder\Test.mdb", acTable, "tblTest", "tblTest" The above code works fine, with the exception that upon execution it prompts for a password, since "c:\myfolder\Test.mdb" is password protected. I really wouldn't like to remove the password protection if at...

Dim db2 As Database, rs2 As Recordset Set db2 = CurrentDb() Set rs2 = db2.OpenRecordset("ListFiles") Dim varitem as variant --------------------------------- It doesn't bomb...no error messages. It just doesn't find any files. It does in Access 2002, but not in Access 2003. I switched the...

Reference Libraries - Access 2003 The only difference are the versions. (i.e. MS Access 9.0 Object Library vs. MS Access 11.0 Object Library). It wouldn't let met substitute earlier version in Access 2003. The library order is the same. Why did you doubt my seriousness?? It's a real issue...

I attempted use some code from an old project (Access 2000) in a new project (Access 2003). The code uses "FileSearch" to search a directory for specific files. It worked beautifully in my old project, but seems to be ignored in Access 2003. I'm sure this has something to do with the...