A
angie
i would like to print a list with all the tables/forms/queries/reports of my
database.
is that possible to happen?
database.
is that possible to happen?
F
fredg
Tools + Analyze + Documenter
Select the Options wanted before you start printing or be prepared
with lot's of paper and ink.
J
Jeff Conrad
Hi Angie,
In addition to the built-in Access Documentor (Tools | Analyze | Documentor) that Fred mentioned, I
would suggest you try my new "Doug Steele Object Documentor" Add-In for Access. This add-in will
create a nice report of all your database objects for easy reference. The report will list all the
objects by category in alphabetical order in a three-column layout. It looks very sweet in my
opinion and it's even easier to use than the Access Documentor. Plus, you get a nice report saved in
your database that you can open again any time you wish! There is one version for Access 97 and
another version that works for 2000, 2002, and 2003.
After installing, which takes all of about a minute to do, you simply do:
Tools | Add-Ins | Doug Steele Object Documentor
That's it! Poof! A nice slick report created in your database in just a couple of seconds.
You can find the free Add-In on MVP Doug Steele's site here:
http://members.rogers.com/douglas.j.steele/Documentor.html
Hope you like it!
In addition to the built-in Access Documentor (Tools | Analyze | Documentor) that Fred mentioned, I
would suggest you try my new "Doug Steele Object Documentor" Add-In for Access. This add-in will
create a nice report of all your database objects for easy reference. The report will list all the
objects by category in alphabetical order in a three-column layout. It looks very sweet in my
opinion and it's even easier to use than the Access Documentor. Plus, you get a nice report saved in
your database that you can open again any time you wish! There is one version for Access 97 and
another version that works for 2000, 2002, and 2003.
After installing, which takes all of about a minute to do, you simply do:
Tools | Add-Ins | Doug Steele Object Documentor
That's it! Poof! A nice slick report created in your database in just a couple of seconds.
You can find the free Add-In on MVP Doug Steele's site here:
http://members.rogers.com/douglas.j.steele/Documentor.html
Hope you like it!
K
Kim
That website is no longer available. Is there another link?
J
Jeff Conrad
Hi Kim,
Doug moved in next door to me now.
You can now find his site and that particular add-in here:
http://www.accessmvp.com/djsteele/Documentor.html
Hope it helps in your projects.
--
Jeff Conrad
Access Junkie
Bend, Oregon
in message:
Doug moved in next door to me now.
You can now find his site and that particular add-in here:
http://www.accessmvp.com/djsteele/Documentor.html
Hope it helps in your projects.
--
Jeff Conrad
Access Junkie
Bend, Oregon
in message:
K
Kim
Thank you very much for the update link.
However now I have another problem that I've been trying to fix. Half of my
wizards aren't working. I've tried everything I've been able to find online.
The registry sandbox value's at 2, I've reinstalled and "fixed", registered
the dll, etc, Compiled all code. Any other ideas?
The Add-in manager gives me the error "Microsoft Access can't find the
wizard, or there is a syntax error in the Declarations section of Visual
Basic module. The wizard you need may be missing from the Libraries key of
the Microsoft Access section of the Windows Registry." Not the first time
I've gotten this message - I had given up trying to fix it and have been
working around the wizards.
However now I have another problem that I've been trying to fix. Half of my
wizards aren't working. I've tried everything I've been able to find online.
The registry sandbox value's at 2, I've reinstalled and "fixed", registered
the dll, etc, Compiled all code. Any other ideas?
The Add-in manager gives me the error "Microsoft Access can't find the
wizard, or there is a syntax error in the Declarations section of Visual
Basic module. The wizard you need may be missing from the Libraries key of
the Microsoft Access section of the Windows Registry." Not the first time
I've gotten this message - I had given up trying to fix it and have been
working around the wizards.
J
Jeff Conrad
in message:
You're welcome.
Which wizards exactly are not working?
So you receive this error *every* time you use the Add-In Manager? Not
just installing one of mine?
Which Access version are you using?
Without knowing exactly what you have tried, you might want to try Repairing your
Access version. See if any of these links help.
Damaged Installation of Access 2003:
http://support.microsoft.com/default.aspx?scid=kb;en-us;825444#9
The symptom may not apply here, but the resolution may help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;288300
You're welcome.
Which wizards exactly are not working?
So you receive this error *every* time you use the Add-In Manager? Not
just installing one of mine?
Which Access version are you using?
Without knowing exactly what you have tried, you might want to try Repairing your
Access version. See if any of these links help.
Damaged Installation of Access 2003:
http://support.microsoft.com/default.aspx?scid=kb;en-us;825444#9
The symptom may not apply here, but the resolution may help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;288300
K
Kim
Access 2000. The input wizards, subreport etc., add-in manager (always - not
just when I'm installing one of yours) are not working every time. I've tried
repairing and reinstalling. I have all of the latest fixes/patches from
Microsoft. Just pretty aggravated with it at this time.
just when I'm installing one of yours) are not working every time. I've tried
repairing and reinstalling. I have all of the latest fixes/patches from
Microsoft. Just pretty aggravated with it at this time.
J
Jeff Conrad
"Kim"wrote in message:
Take a look at this KB article:
Wizards do not start when you try to start any of the Access 2000 wizards:
http://support.microsoft.com/kb/q242218/
And maybe this one as well:
ACC2000: Error Message When Running Access Wizards
http://support.microsoft.com/?id=303769
You can also try registering DAO360.dll.
From Start --> Run you would type the following:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"
Note: You may need to change the path to DAO360 if this is different on your machine.
Hope that helps,
Take a look at this KB article:
Wizards do not start when you try to start any of the Access 2000 wizards:
http://support.microsoft.com/kb/q242218/
And maybe this one as well:
ACC2000: Error Message When Running Access Wizards
http://support.microsoft.com/?id=303769
You can also try registering DAO360.dll.
From Start --> Run you would type the following:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"
Note: You may need to change the path to DAO360 if this is different on your machine.
Hope that helps,
K
Kim
Any other ideas? Tried all of those. : (
Jeff Conrad said:
J
Jeff Conrad
in message:
You know, you're not making this easy Kim.
I would suggest using Microsoft's Eraser 2000 utility.
A quick Google search yielded not only where to find the file, but this very
informative post by someone at Microsoft. Maybe this information may help
in your situation as well.
My name is Frank Miller. Thank you for using the Microsoft Access
Newsgroups.
This error message usually means that there is a corrupt file on the
machine. The file can be the database file, one of the application (Access
in this case) files, an operating system file, or, in rare cases, a
hardware failure.
As the database works correctly in another machine, I would start with the
Access application. As there is no information specifying what is causing
the error, I would start by removing Office (or stand-alone Access if
Access is not part of Office).
Beyond that, the following may help....
This behavior is typical of a damaged file. The file could be a user
database, an Access application file, or an operating system file.
I would first try a new blank database and see if the problem still occurs.
If it does, then the database file is not at fault.
I would next try to make sure that I reboot and then close any utility
applications running in the background, such as virus checkers and try
again. If the problem is resolved, then the utility that was closed may be
interfering with the application or operating system.
If the problem continues, we could try removing the Access/Office
application and reinstall to replace the application files with fresh
copies. Specific steps are mentioned below in the event that this is
necessary.
There are several reasons why the operating system might hang while working
in an Access Form or Report that can occur even after insuring that the
database file is valid.
Out of memory or disk space:
The operating system needs about 100MB for Office 2000 in the drive where
windows is installed. As this number drops, less space is available for
temporary work space. Depending upon the system activities, erratic
behavior can occur as the amount of free disk space diminishes. If the
space is low enough, the operating system can't perform even simple error
recovery for problems caused by insufficient space and everything crashes.
If your disk space is below 100 MB, try to free up some hard drive space
and try again.
Applications running in the background:
By pressing Ctl, Alt and Del at the same time, you can open the Close
Program dialog box in Windows 98. The only application besides Access that
needs to be open here is Explorer (which is the operating system). Any
other application is suspect and may be interfering with Access (or any
other program). Virus scanners and other application that inspect files
that are in use are particularly suspect. Sometimes these applications will
become damaged and can, in turn, damage other applications as they are
running in memory. After shutting down and powering back up, select each
application in the Close Program dialog box and with the exception of
Explorer, click the End Task button. Once all tasks have been ended but
Explorer, open Access and see if the problem still occurs.
Mismatched or invalid files:
Even when Access/Office 2000 is removed from the system and reinstalled,
some files and windows registry settings are left behind on purpose as they
may be shared by other applications. These files are not reinstalled during
Office setup if they already exist. You can run the utility, Eraser 2000,
to remove the files left behind after you uninstall Microsoft Office and
it's components. You can review and download Eraser 2000 at:
http://support.microsoft.com/support/kb/articles/Q239/9/38.asp.
Before reinstalling Office, run the Windows 98 Scandisk and Defrag on your
hard disk and delete the '\Program Files\Microsoft Office' folder.
Remember that an uninstall does not always remove all of the files from
this folder. When doing this, remember to check for any user files that
may have been saved to or created in this location (for example, any custom
templates that may have been saved to the '\Program Files\Microsoft
Office\Templates' folder).
How to proceed:
The following are steps can be used to address a hanging of the operating
system while using Access 2000. At any time a step successfully resolves
the issue, STOP THERE. Do not complete the remaining recommendations.
There are many possible causes for this error: Memory conflicts with
Windows drivers, i.e. video or printer; incorrect registry entries for the
Microsoft Access components; mismatched DLLs where other programs have
installed a different version of a shared component that is not compatible
with Microsoft Access.
1) Make sure everything is shutdown except Windows. Place your
Access/Office 2000 CD in the appropriate drive. Click Start -> Run. In the
Open dialog, type the following syntax substituting the drive letter as
necessary:
F:\setup.exe
This will start a normal setup process in Maintenance Mode. Proceed by
selecting Repair Office, then selecting Repair Errors. Follow this all the
way through. When it is successfully completed, reboot your PC. Then test
your form controls. This process installs application files that it finds
to be damaged or missing and re-write the application's operating system
registry entries. It also reinstalls the application shortcuts.
2) Make sure everything is shutdown except Windows. Place your
Access/Office 2000 CD in the appropriate drive. Click Start -> Run. In the
Open dialog, type the following syntax substituting the drive letter as
necessary:
F:\setup.exe
This will start a normal setup process in Maintenance Mode. Proceed by
selecting Repair Office, then selecting Reinstall Access/Office 2000.
Follow this all the way through. When it is successfully completed, reboot
your PC. Then test your form controls. In addition to what is performed in
step 1, Reinstall replaces all the Access/Office application files.
3) Uninstall Access/Office 2000 by doing a Remove Office from the
Maintenance Mode dialog box.
Run a very handy utility, Eraser 2000, to remove a noticeable number of
files left behind after you uninstall Microsoft Office and it's components.
You can review and download this handy utility at:
http://support.microsoft.com/support/kb/articles/Q239/9/38.asp.
In addition to running Eraser 2000 to clean a user's system, it is
important that the '\Program Files\Microsoft Office' folder be deleted
prior to reinstalling Microsoft Office 2000. Remember that an uninstall
does not always remove all of the files from this folder. When doing this,
remember to check for any files that may have been saved to or created in
this location (for example, any custom templates that may have been saved
to the '\Program Files\Microsoft Office\Templates' folder).
Run the Windows 98 Scandisk and Defrag on your hard disk.
Install Microsoft Access/Office 2000 Professional doing a Custom install to
choose all the Access options. When completed successfully, restart your
PC. Test to see if the problem is resolved.
For additional information, please see article:
Q218873 - OFF2000: Troubleshooting Office Kernel32.dll Errors Under Win 95
http://support.microsoft.com/support/kb/articles/q218/8/73.asp
I hope this helps! If you have additional questions on this topic, please
reply to this posting.
Regards, Frank Miller
Microsoft Support
Good luck,
You know, you're not making this easy Kim.
I would suggest using Microsoft's Eraser 2000 utility.
A quick Google search yielded not only where to find the file, but this very
informative post by someone at Microsoft. Maybe this information may help
in your situation as well.
My name is Frank Miller. Thank you for using the Microsoft Access
Newsgroups.
This error message usually means that there is a corrupt file on the
machine. The file can be the database file, one of the application (Access
in this case) files, an operating system file, or, in rare cases, a
hardware failure.
As the database works correctly in another machine, I would start with the
Access application. As there is no information specifying what is causing
the error, I would start by removing Office (or stand-alone Access if
Access is not part of Office).
Beyond that, the following may help....
This behavior is typical of a damaged file. The file could be a user
database, an Access application file, or an operating system file.
I would first try a new blank database and see if the problem still occurs.
If it does, then the database file is not at fault.
I would next try to make sure that I reboot and then close any utility
applications running in the background, such as virus checkers and try
again. If the problem is resolved, then the utility that was closed may be
interfering with the application or operating system.
If the problem continues, we could try removing the Access/Office
application and reinstall to replace the application files with fresh
copies. Specific steps are mentioned below in the event that this is
necessary.
There are several reasons why the operating system might hang while working
in an Access Form or Report that can occur even after insuring that the
database file is valid.
Out of memory or disk space:
The operating system needs about 100MB for Office 2000 in the drive where
windows is installed. As this number drops, less space is available for
temporary work space. Depending upon the system activities, erratic
behavior can occur as the amount of free disk space diminishes. If the
space is low enough, the operating system can't perform even simple error
recovery for problems caused by insufficient space and everything crashes.
If your disk space is below 100 MB, try to free up some hard drive space
and try again.
Applications running in the background:
By pressing Ctl, Alt and Del at the same time, you can open the Close
Program dialog box in Windows 98. The only application besides Access that
needs to be open here is Explorer (which is the operating system). Any
other application is suspect and may be interfering with Access (or any
other program). Virus scanners and other application that inspect files
that are in use are particularly suspect. Sometimes these applications will
become damaged and can, in turn, damage other applications as they are
running in memory. After shutting down and powering back up, select each
application in the Close Program dialog box and with the exception of
Explorer, click the End Task button. Once all tasks have been ended but
Explorer, open Access and see if the problem still occurs.
Mismatched or invalid files:
Even when Access/Office 2000 is removed from the system and reinstalled,
some files and windows registry settings are left behind on purpose as they
may be shared by other applications. These files are not reinstalled during
Office setup if they already exist. You can run the utility, Eraser 2000,
to remove the files left behind after you uninstall Microsoft Office and
it's components. You can review and download Eraser 2000 at:
http://support.microsoft.com/support/kb/articles/Q239/9/38.asp.
Before reinstalling Office, run the Windows 98 Scandisk and Defrag on your
hard disk and delete the '\Program Files\Microsoft Office' folder.
Remember that an uninstall does not always remove all of the files from
this folder. When doing this, remember to check for any user files that
may have been saved to or created in this location (for example, any custom
templates that may have been saved to the '\Program Files\Microsoft
Office\Templates' folder).
How to proceed:
The following are steps can be used to address a hanging of the operating
system while using Access 2000. At any time a step successfully resolves
the issue, STOP THERE. Do not complete the remaining recommendations.
There are many possible causes for this error: Memory conflicts with
Windows drivers, i.e. video or printer; incorrect registry entries for the
Microsoft Access components; mismatched DLLs where other programs have
installed a different version of a shared component that is not compatible
with Microsoft Access.
1) Make sure everything is shutdown except Windows. Place your
Access/Office 2000 CD in the appropriate drive. Click Start -> Run. In the
Open dialog, type the following syntax substituting the drive letter as
necessary:
F:\setup.exe
This will start a normal setup process in Maintenance Mode. Proceed by
selecting Repair Office, then selecting Repair Errors. Follow this all the
way through. When it is successfully completed, reboot your PC. Then test
your form controls. This process installs application files that it finds
to be damaged or missing and re-write the application's operating system
registry entries. It also reinstalls the application shortcuts.
2) Make sure everything is shutdown except Windows. Place your
Access/Office 2000 CD in the appropriate drive. Click Start -> Run. In the
Open dialog, type the following syntax substituting the drive letter as
necessary:
F:\setup.exe
This will start a normal setup process in Maintenance Mode. Proceed by
selecting Repair Office, then selecting Reinstall Access/Office 2000.
Follow this all the way through. When it is successfully completed, reboot
your PC. Then test your form controls. In addition to what is performed in
step 1, Reinstall replaces all the Access/Office application files.
3) Uninstall Access/Office 2000 by doing a Remove Office from the
Maintenance Mode dialog box.
Run a very handy utility, Eraser 2000, to remove a noticeable number of
files left behind after you uninstall Microsoft Office and it's components.
You can review and download this handy utility at:
http://support.microsoft.com/support/kb/articles/Q239/9/38.asp.
In addition to running Eraser 2000 to clean a user's system, it is
important that the '\Program Files\Microsoft Office' folder be deleted
prior to reinstalling Microsoft Office 2000. Remember that an uninstall
does not always remove all of the files from this folder. When doing this,
remember to check for any files that may have been saved to or created in
this location (for example, any custom templates that may have been saved
to the '\Program Files\Microsoft Office\Templates' folder).
Run the Windows 98 Scandisk and Defrag on your hard disk.
Install Microsoft Access/Office 2000 Professional doing a Custom install to
choose all the Access options. When completed successfully, restart your
PC. Test to see if the problem is resolved.
For additional information, please see article:
Q218873 - OFF2000: Troubleshooting Office Kernel32.dll Errors Under Win 95
http://support.microsoft.com/support/kb/articles/q218/8/73.asp
I hope this helps! If you have additional questions on this topic, please
reply to this posting.
Regards, Frank Miller
Microsoft Support
Good luck,