473,799 Members | 2,935 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access Report Issue

13 New Member
I have an access Report A generated by Query A, I copied Query A as Query B and replaced some columns by adding new columns. So when ever I run
Report A now referred to Query B I am getting the pop windows "Enter Parameter Value" to enter the value for the columns I deleted. I have to click OK…. To get rid of it then the report is displayed.
Can anyone please let me know how to get rid of Parameter Value window.

Thanks
Mar 26 '07 #1
6 1462
Rabbit
12,516 Recognized Expert Moderator MVP
Go to query B and get rid of anything that refers to the columns you deleted.
You also have to do the same for report A.

If you need report A for query A and report A for query B then you'll have to create a report B.
Mar 26 '07 #2
ssq
13 New Member
Thanks Rabbit, sorry i forgot to mention that i already did what you said but still the same error ?
Mar 27 '07 #3
Denburt
1,356 Recognized Expert Top Contributor
I copied Query A as Query B and replaced some columns by adding new columns.
Now create a NEW report for query B if you copy Report A to create a report B then you will have this problem. You will want to open query B and make sure the prompts are not comming from there since the sort order of an MS Access query can be stored in the properties page, and might be overlooked. Hope this helps.
Mar 27 '07 #4
ssq
13 New Member
Thanks, i am trying to do that, i should i add "Master Index Header" that was in the previous report.

Thanks once again for the quick response.
Mar 27 '07 #5
ssq
13 New Member
I mean i have to had "Master Index Header and Footer" which was existing in the previous report, how can i insert "Master Index Header and Footer" ?
Mar 27 '07 #6
Denburt
1,356 Recognized Expert Top Contributor
Use that as the Main report put a sub report on there, once you do that you can change the source to report A or Report B.
Mar 27 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2950
by: Joris Kempen | last post by:
Hi people, I know that the question has come around sometimes: How to open an Access Report using ASP and export it to for example RTF. I'm trying to implement the first method of David Cline: http://www.15seconds.com/issue/981216.htm
3
2399
by: pbbriggs | last post by:
I will try to be as descriptive as possible, but this error has me stumped and I am not sure what relevant info to include.... I am running Access XP on a Windows XP machine. I initially began developing an app in Access 2000 but converted it several months ago to XP. So the app is now Access XP format also. My app is crashing on a regular basis, with the totally non-descript Microsoft error (Microsoft Access has encountered a...
2
2681
by: Tom | last post by:
I have a report where one field tends to be rather lengthly and ends up being several lines long while another field has several short entries. The problem I have is that the first of the short entries is aligned with the record's other entries, but subsequent entries are listed below the first record. Does anyone know how I can get rid of the annoying gap between the first and second entry for that one field?
13
3941
by: salad | last post by:
Hi Guys: I was stuck. I needed to send a report to a file. My beautiful report(s) in Access were going to require loss of formatting with RTFs, a PITA in WordMailMerge, sending it as a text file...whatever. I described my situation to the guy I'm doing work for and he did some research for me and came up with the following link. http://www.novapdf.com/ The part that should excite us Access developers is their SDK
9
2535
by: Fish Womper | last post by:
I am at best a part time developer of Access databases. I use Access 2.0, as this is all my employer has on its computers. Even so, to use this ancient version requires a fairly convoluted installation procedure on each PC on which it is used. I am self-taught from the help files that come with Access 2.0 and from painful experience. I've never attended any type of training course on how to develop databases in Access. I have no idea...
9
2465
by: badboybrown | last post by:
Hello, Is it possible to step through the "Create MDE" process and see what is causing Access to crash? I tried, unsuccessfully, many times to create an MDE from my database. But, randomly, I checked the "Allow Full Menus" in the Startup section. I was then able to create an MDE. That worked once. It has not worked since and I don't particularly
5
2602
by: rick m | last post by:
We have a fairly good sized Access database that contains some info on the children our agency sees. We also have 40+ templates that require some info from the database be inputted into them, such as the name of the child, their address, etc. At this time staff will look into the database for that info and enter it into the form. Management wants to automate this a bit so each of these templates is a report. That leads to my question. ...
3
8492
by: Jason.Forget | last post by:
I have created a 4 Reports using the Reports Wizard in Access 2003 and the text in a memo field is being cut off. This is an inconsistent issue being that it is affecting just one of the reports. The field on the report is set to Can Grow as is the Header. The total text if 697 characters. I have read the following articles and found that they do not pertain to my issue: http://www.mcse.ms/archive153-2004-12-1311942.html ...
16
11137
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might know one way or the other whether that was true or not, or could point me to an article or help text that would. What I have seen so far online and in Access 2007 help seems to confirm the above. But that (or at least (b)) seems incredible that it...
10
9126
by: Snoopy33 | last post by:
I have a DB that I developed on access XP (2002) and deployed over a year ago. No one has had problems printing any of the reports within the DB until we started loading 2007 on new computers. The access 2007 users cannot print one of the reports. This is maddening since I cannot duplicate the issue on any computer that runs 2003 or below. Is there something going on that I'm not seeing? Does anyone have any suggestions at all on...
0
9688
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9544
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10490
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10259
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10238
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10030
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6809
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
3761
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2941
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.