Solved

Access 2000 "The Wizard is Unable to Create Your Report"

Posted on 2001-07-16
9
2,707 Views
Last Modified: 2007-11-27
Hey, I am working in a default installation of Access 2000 on a W98 SE machine. While using the Report Wizard in a small, straight forward database, the above message appeared when the report was generating, and the resulting report was blank with no fields or labels. I checked available patches from MS, and nothing seemed to address such a problem. Any Ideas? Thanks in Advance, BIll
0
Comment
Question by:westone
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6286773
Can you provide some more background:
Are you using more than 1 table (or query) in the report?  Are you trying to create a chart?  Did you try the repair and compact?  Do you have all the add-ins for the DB that you need?
0
 

Author Comment

by:westone
ID: 6287510
Sorry, this is a simple 1 table report that simply displays all the fields in the table sorted on the key. There are no add ins listed in the addin manager, and further I would not know which one(s) I might need in any event. I did run repair and compact and it made no difference in the behaviour. Can you offer any further suggestions or advice? Thanks, Bill
0
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6287535
I would re-run the set-up program by going to control panel/add remove programs/
Choose custom installation and try installing all of the components for Access.  To do this, tell it you want to run everything from your hard disk.
I dont know if this article will help, but give it a try:
http://support.microsoft.com/support/kb/articles/Q208/5/53.ASP?LN=EN-US&SD=gn&FR=0&qry=The%20Wizard%20is%20Unable%20to%20Create%20Your%20Report&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC

0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:westone
ID: 6287722
Thanks, I will give it a try, but it will have to be later this week. It is dinner time here and I am heading out of town in the a.m. I will keep you posted on the results when they are in. Thanks Again, Bill
0
 
LVL 6

Accepted Solution

by:
PsychoDazey earned 100 total points
ID: 6289550
You're welcome.  Good luck.
Eric
0
 

Author Comment

by:westone
ID: 6299753
Well, I have loaded all of the available options onto my HD, and that made no difference. So I completely uninstalled Access 2000 from the PC, then re-installed it as you suggested: custom, selecting all options installed and run from the HD. Unfortunately, this still made no difference in the symptoms. I'm no genius, but this is just a small, simple database base from a tutorial for Access I found on the internet, and I don't see anything about the construction of the db that could be causing this problem. I beleive it must be a bug or fluke of some sort. Too bad there is no indication in the error message of what the cause might be. I viewed the knowledge base report you indicated, and although that scenario does involve the same error message, it is not what is happening in this situation. I can construct the report manually, and this case it is not that big of a deal, but very quickly the report wizard will be a big time saver on the creation of reports, and I will not want to live without it. I appreciate your input, PsychoDazey, I wish there were more input from others so as to provide other leads to followup on. Thanks, Bill
0
 

Expert Comment

by:amp072397
ID: 6744820
westone:

I see that you've logged in just a few days ago.

This is a free technical support site.

Experts who answer questions here receive no pay or other compensation except Expert points as a result answering questions and being awarded points.

As a result, and as a Moderator of this forum, my goal is to ensure that Experts and Askers alike no longer allow questions to get stale.

Please provide that feeback now. It's greatly appreciated!

If you need any help at all in cleaning up this or any other questions, don't hesitate to contact me via email. I will assist in any way that I can.

thanks
amp
community support moderator
amp@experts-exchange.com
0
 

Expert Comment

by:amp072397
ID: 6783834
westone:

You have several open questions:

http://www.experts-exchange.com/jsp/qShow.jsp?qid=20259273
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20230398
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20151403

To assist you in your cleanup, I'm providing the following guidelines:

1.  Stay active in your questions and provide feedback whenever possible. Likewise, when feedback has not been provided by the experts, commenting again makes them receive an email notification, and they may provide you with further information. Experts have no other method of searching for questions in which they have commented, except manually.

2.  Award points by hitting the Accept Comment As Answer button located above and to the left of that expert's comment.

3.  When grading, be sure to read:
http://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp#3
to ensure that you understand the grading system here at EE. If you grade less than an A, you must explain why.

4.  Questions that were not helpful to you should be PAQ'd (stored in the database for their valuable content?even if not valuable to you) or deleted. To PAQ or delete a question, you must first post your intent in that question to make the experts aware. Then, if no experts object after three full days, you can post a zero-point question at community support to request deletion or PAQ. Please include the link(s) to the question(s).
CS:  http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
At that point, a moderator can refund your points and PAQ or delete the question for you. The delete button does not work.

5.  If you fail to respond to this cleanup request, I must report you to the Community Support Administrator for further action.

Our intent is to get the questions cleaned up, and not to embarrass or shame anyone. If you have any questions or need further assistance at all, feel free to ask me in this question or post a zero-point question at CS. We are very happy to help you in this task!


thanks!
amp
community support moderator

2/4
0
 

Expert Comment

by:Pete-Panaroni
ID: 14532110
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question