Search results

Chris: Wow, you did a lot of work. Thanks. This is probably beyond me but I'll take a look. I saw you earlier solution using "OutputTo". This is nice but I was trying to trap the procedure in a string via code so that I can update a table ... Thanks for all your help.

Thanks for responding. I am trying to document an existing Access system (tables, queries, forms, reports, modules ...). I was able to get all the query names and their sql statements via ...QueryDefs.Name and QueryDefs.sql. Now I am trying to get all the functions and procedures names and...

Did you ever get this resolved? I've got a similar issue using SendObject to email a report in Rich Text format. It worked great in Access 97 but NOT in Access 2002. The only unique thing about this report is that it uses the DecimalPlaces property to change display format depending on a...

Just tried it and it worked fine in Access 2002. The only thing I noticed when I copied your code was the funny quotes in [Fname=”somefile.xls”]. I had to replace them with ["].

Is the code in functions and procedures available by stepping through collections? For example, the SQL code of a query is available via ...QueryDefs(queryname).SQL I am using DAO in Access 2002. Thanks in advance.