I have a data entry form that contains drop-down lists such as
'Assigned to:' with a list of staff member names. Those names end up as
numerical codes in the main table ('ProjectInfo') of the Access
database. Is there some way - such as a SQL satement added to a query
already set up in Access - to add a statement such as 'if 1 then
'Smith', if 2 then 'Brown', if 3 then 'Williams' ', and so on? That
would be an automated way to quickly get names, instead of numbers, to
appear in project status reports.
Otherwise, I have to use the more manual approach I'm using now, which
is to manually update a "linker table" called 'Project_Person nel' by
typing in the inserted values (inserted via use of a data entry form)
from 'ProjectInfo' into 'Project_Person nel'. For example,
'Project_Person nel', for each ProjectID, contains three numerical
fields: one for the code for the Director's name, one for the code for
the Program Manager's name, and one for the code for the Staff Person's
name.
This "linker table", Project_Personn el, links back to smaller tables
such as the one comprised of the list of names of Directors; the one
comprised of the list of names of Program Managers; and also, the one
comprised of the list of names of Staff Members. That's the way I'm
currently using to get names, rather than numbers, to appear in the
project status reports created in Access. 1 1531 km*******@hotma il.com wrote: I have a data entry form that contains drop-down lists such as 'Assigned to:' with a list of staff member names. Those names end up as numerical codes in the main table ('ProjectInfo') of the Access database. Is there some way - such as a SQL satement added to a query already set up in Access - to add a statement such as 'if 1 then 'Smith', if 2 then 'Brown', if 3 then 'Williams' ', and so on? That would be an automated way to quickly get names, instead of numbers, to appear in project status reports.
Otherwise, I have to use the more manual approach I'm using now, which is to manually update a "linker table" called 'Project_Person nel' by typing in the inserted values (inserted via use of a data entry form) from 'ProjectInfo' into 'Project_Person nel'. For example, 'Project_Person nel', for each ProjectID, contains three numerical fields: one for the code for the Director's name, one for the code for the Program Manager's name, and one for the code for the Staff Person's name.
This "linker table", Project_Personn el, links back to smaller tables such as the one comprised of the list of names of Directors; the one comprised of the list of names of Program Managers; and also, the one comprised of the list of names of Staff Members. That's the way I'm currently using to get names, rather than numbers, to appear in the project status reports created in Access.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Use the same ComboBox on the report as you use on the input form. After
copying it to the report change it's ControlSource to the corresponding
column name in the report's query.
You can copy the ComboBox from the form to the report:
1) Open form in design view - copy ComboBox (right click on control,
select copy).
2) Close form & open the report in design view.
3) Click the section you want to place the ComboBox & right click &
select Paste.
4) Move the ComboBox to the location you want.
5) Close & save the report.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQjIF0YechKq OuFEgEQKkoQCgrW 7ucOUsiNABIypO7 VB21OIcAqgAn3Aq
GomFPob4lqFzbVp arvd07Kds
=dg4P
-----END PGP SIGNATURE----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John |
last post by:
Hi all,
I would like to use the Report building and printing capabilities of the
MSAccess DB. I have a ASP.NET page which does calculations based on data in
a MSSQL Server and once done will need to have the abiliity to print from IE.
The results can be over 1000 rows or greater, therefore using a datagrid,
even with paging set to on, is a cumbursome way for the users to print all of
the data. Is there a way to create the reports in...
|
by: Sigurd Bruteig |
last post by:
Hi all!
I have a problem printing multiple reports. The code i use is:
Dim stDocName As String
stDocName = "rptInvoice"
DoCmd.OpenReport stDocName, acNormal, , " = date()"
The problem is that invioce details is printed several times on the same
invoice and only the first page is shown as first page, even if all reports
have only one page.
I gess I have to loop trough the code, but I can't figure out how to.
|
by: gudia |
last post by:
I want to Programatically generate Access reports in the pdf format
using some tool and then email them to people in the same code. Right
now I am trying to do this with pdf995 using VBA (emailing is a
separate issue, which pdf995 does not addresses).
I downloaded pdf995. It controls printing via pdf995.ini file. In the
VBA code, I have DoCmd.OpenReport "Report2", acViewNormal. I am having
the following problems right now.
(a) I do...
|
by: John Smith |
last post by:
Is there anyway to convert/export/copy an Access report into a
Powerpoint slide?
I know I can publish via Excel/Word but these remove formatting etc
and therefore always require some degree of manipulation.
My report data obviously changes from time to time and I want to avoid
having to reformat/update manually.
Thanks
|
by: cyranoVR |
last post by:
This is the approach I used to automate printing of Microsoft Access
reports to PDF format i.e. unattended and without annoying "Save As..."
dialogs, and - more importantly - without having to use a commercial
program such as Adobe Acrobat and its associated API.
The technique uses Ghostscript and Redirection Port Monitor - two free
programs for creating PDF documents provided free by Russell Lang. The
actual automation requires VBA...
| |
by: IC_Clearly |
last post by:
I'm running Server 2003 and wonder how well WTS works when printing an
Access report to a client. Any suggestions would be appreciated.
Thanks.
IC
|
by: booner |
last post by:
Is there any way to show an existing access database (.mdb) report inside a
vb.net application?
Any/all pointers much appreciated.
BBB
|
by: charvi |
last post by:
can i generate more than 1 excel sheets when a command button is clicked
for eg
i search for 2 names of audit dept and click print command button where records will be printed in excel
again if i search for other 2 names and if i click print command button reports will not be printed.and gives error i have to close the program and load the program again
|
by: MLH |
last post by:
How do I ensure my reports are being printed in
max resolution of 1200dpi ? That is, can Access
control the setting?
|
by: Qtip23 |
last post by:
Hello All,
So I have a my database information placed on a SharePoint site now that there is an immediate need for a web-based application in my division.
I am able to print Access Reports from SharePoint but this annoying non-breaking space mark --   -- keeps printing out as well.
Is there a way to handle or suppress that from occuring when printing out Access reports?
Thanks,
|
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: 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...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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...
| |