I have been asked to set a database up so that the users can choose which fields they want to include in reports. Is this possible? Keep in mind the end-users know nothing about Access and would need it all very automated.
The only thoughts I have on the issue would be to create a form with all of the possible fields and a check-box for the user to select the fields. Then I would set the value of the Visible property for the fields in the report accordingly, but the formatting of that report seems like it would be messy.
Thanks
3  1820  nico5038 3,080
Recognized Expert Specialist
Can be done with a lot of code for the report, but I would just dynamically create a SELECT query and open that to them and/or offer them the possibility to save that in an excel spreadsheet.
Idea ?
Nic;o)
.
 ADezii 8,834
Recognized Expert Expert
I have been asked to set a database up so that the users can choose which fields they want to include in reports. Is this possible? Keep in mind the end-users know nothing about Access and would need it all very automated.
The only thoughts I have on the issue would be to create a form with all of the possible fields and a check-box for the user to select the fields. Then I would set the value of the Visible property for the fields in the report accordingly, but the formatting of that report seems like it would be messy.
Thanks
It can be done but would involve creating a Custom Wizard which would be fairly complex to say the least. As far as your alternative, you are right, the formatting of the Report would be messy. You could also dynamically build a SQL statement from User selected Fields and use that as the Record Source for the Report but then you would also have to program the Control Sources for the Bound Controls, Labels, etc. and that would really be complex. In short, there seems to be no easy solution for what you would like to accomplish.
NeoPa 32,579
Recognized Expert Moderator MVP
I have been asked to set a database up so that the users can choose which fields they want to include in reports. Is this possible? Keep in mind the end-users know nothing about Access and would need it all very automated.
The only thoughts I have on the issue would be to create a form with all of the possible fields and a check-box for the user to select the fields. Then I would set the value of the Visible property for the fields in the report accordingly, but the formatting of that report seems like it would be messy.
Thanks
I have a report that works on similar but very restricted lines.
I can make assumptions about the layout from which fields are to be shown and I know I can fit them onto the line of the report. Doing it freeform is almost certainly a bridge too far.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: DC_DBA |
last post by:
I want to 'grant sysdba to a user' for an application. (At least that
is what I believe so far after having had this problem dumped on me 2
days ago.) The support we get from the application vendor is lame, to
say the least. Our application users dont know anything.
1. The Oracle 9i server is installed on a Sun Solaris system.
2. I work with Sybase and hence don't know any Oracle.
3. I can start sqlplus but dont know where to go after...
|
by: Lord Asriel |
last post by:
I'm a newbie in mysql and I've a question about user definition in
Mysql.
According to informations collected from manuals I believed that a
user definition specifying host="%" on mysql server 'A' granted me
connection from whatever client (with command "mysql -hA -uuser -p");
but executing that command from server, to say, 'B', mysql denies
access to user@B. The matter can be solved defining a new user with
host B (it's to say...
|
by: Todd Beaulieu |
last post by:
Hello,
I'm using the configuration block to store user settings in the app.config
file. As this exe will reside on a network drive, I can't have users trying
to update the master app.config file. I want each user to read/write to a
file in their user directory.
Does anyone know how to do this?
|
by: Renato Neves |
last post by:
The following code is working fine, i can create the user in the Active
Directory and "enable" it.
My problem is that, when i'm trying to authenticate him, i can't get to
work!! The user and pass is correct, but it can't authenticate. If i try
other user created in the AD, it work just fine!!!
<------------------------------------------------------------------------------------------------------------->
< ...
|
by: siliconmike |
last post by:
On my FreeBSD system, apache would run under user: www
Apache would run php script which would accesses mysql as user: xyz,
passwd: pqr
Mysql server would itself run with --user=mysql command line variable..
So, what user would need to be setup in the privilege table ? xyz or
mysql ?
Or is mysql user removable in my case ? (it was defaultly installed)
| | |
by: zlst |
last post by:
Many technological innovations rely upon User Interface Design to elevate
their technical complexity to a usable product. Technology alone may not win
user acceptance and subsequent marketability. The User Experience, or how
the user experiences the end product, is the key to acceptance. And that is
where User Interface Design enters the design process. While product
engineers focus on the technology, usability specialists focus on the user...
|
by: Josema |
last post by:
Hi,
Im starting to do the navigation of a portal, and for it, im using
usercontrols....
Actually i have a user control in the top of the page that has some menus
(contact, register, etc...)
Depending of the menu that the user will clik i make a LoadControl to the
specific user control. i start to see some problems following this way...
|
by: Pete Wittig |
last post by:
Hello,
I am wondering if it is possible to create a networked application with C#
that is seen as a windows user. For example, if Bob logged onto windows and
then started the application, any access to the network made through the
application would be seen as 'C# application user' and not 'Bob'.
What I want to accomplish is to create an encrypted folder on a server where
files within the folder can be accessed through the application,...
|
by: Martine |
last post by:
Hi there!
I have a problem with programmatically adding user controls to my
mobile webforms. If I load my usercontrol programmatically (in the
Page_Load), the object is instantiated, I have access to the methods
and properties from the Page_Load, no problem there. But as soon as I
want access to the user control from another procedure on the same
page, I get the next error message:
"Object reference not set to an instance of an...
|
by: geoffreyfishing |
last post by:
I have tried posting everywhere, but no one has given me an answer so far. I am willing to try everything short of a clean install of vista.
My Problem:
Some process has a locking handle on the Users NTUSER.DAT file, so windows attempts to unload it:
Log Name: Application
Source: Microsoft-Windows-User Profiles Service
Date: 6/13/2010 8:54:01 AM
Event ID: 1530
Task Category: None
|
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...
| | |
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,...
|
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...
|
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,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| | |
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();...
|
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...
| |
