Hi Jennie,
You're very welcome. I'm glad to hear that you're problems are solved!
Since you used the Microsoft web portal to post your question, please
consider going back in and marking my first response as an answer. This will
help to ensure that this posting will be easier to find, if someone else has
a similar problem and they enter the appropriate keywords in a search. It
also helps me get a little closer to a silver badge, from my current bronze
level <shy smile>.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
You are the best! It works great and solves many problems I have had with two
different databases! Thanks!
__________________________________________
:
Hi Jennie,
I have had some success in the past fixing this type of shutdown problem by
opening Access with the /decompile switch. If you only have one version of
Access installed on your PC, then you can:
1.) Click on Start > Run
2.) Enter: msaccess /decompile
3.) Navigate to your database. Hold down the shift key while opening the
database.
4.) Compact the database (Tools > Database Utilities > Compact and Repair
Database)
If you have more than one version of Access installed, then create a
shortcut that points to the appropriate version of msaccess.exe with the
/decompile option included in the target. Here's an example for my PC:
"C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE" /decompile
To show all records for a combo box, if left blank, try something like this
as the criteria for the applicable field:
Like [Forms]![NameOfForm]![NameOfComboBoxControl] & "*"
For example,
Like [Forms]![fdlgAskForDatesAndCity2]![cboCity] & "*"
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
I want to run a report based on parameters entered into a form, a begininng
and ending date in text boxes and one more parameter in a combo box. I want
to put "ALL" in the combo box. I copied the info from the Solutions databse,
but everytime I try and use it i get an error message (Access has experienced
and error and will shut down) and Access shuts down. Any idea why?
If I can't get this to work is there anyway, in the query, to have "between
(beginning date) and (ending date)" as one criteria and for the combo box
have it show all records if left blank?
