|
by: ~TheIcemanCometh~ |
last post by:
I have a textbox field on a report that shows an Address. The field is
built up in code when the user selects the customer in the following
manner:
ShipAddress = CustomerName & vbCR & CustomerAddress & vbCR & Customer
City (etc.)
This is done and put into the ShipAddress field on another table.
|
by: Mike Bosschaert |
last post by:
Hi,
I have an Access 2000 frontend and a SQL server backend connected with
an ODBC-link. On a report I have a control called 'gender'. In the db
I have values 1 (male) and 2 (female). In the report I want to show
the text value.
If I use the controlsource "GENDER" than the report shows a 1 or a 2.
If I use the formula:
=IIf(=1;"male";"female") I get an error message (#Error).
|
by: CSDunn |
last post by:
Hello,
I have a situation with MS Access 2000 in which I need to display report
data in spreadsheet orientation (much like a datasheet view for a form). If
you think of the report in terms of what a spreadsheet might show, the
column names will actually be dynamic, based on data from a SQL Server 2000
database. The row data will also come from the same database. So in this
case, I will have a main report and a subreport. I've already tried...
|
by: CSDunn |
last post by:
Hello,
I have a format issue on an Access 2000 ADP report that I am going to
attempt to explain from a 'ten thousand foot view' :
I have an Access 2000 ADP report that has a SQL Server 2000 Stored Procedure
as its record source. The Proc is called MM_rptTeacherGroupingTest_sp. In
order to help communicate the issue I am having with the report, please take
a look at the following:
http://www.valverde.edu/home/policy/ReportLayout.htm .
|
by: Newbie |
last post by:
Hi all,
I am having three queries which I combined using an union query and each
query has a cost field. In the report when I try to get the sum() I
get a number with many decimal zero's all my cost field in the query are
single and have decimal property set to three. Any ideas why I am getting
such a long number after using the Sum() function? Pleaase advice.
--
'With Thanks'
|
|
by: Alison Givens |
last post by:
Hi all,
I have been suffering with this problem for weeks now. I tried several
newsgroups, but nobody can tell me how to solve this problem. The problem: I
have a webform that shows a Crystal Report. In the page_init I export the
report to a pdf. When I hit the printbutton, the PDF shows. When I close the
form, the PDF is deleted from the server. So far, so good.
This works for all reports, exept for reports with parameters. The...
|
by: Dentharg |
last post by:
Hi!
I've created an C# project, added DataSet and created a table adaptor
(WorkerClothesReport).
I've created several GetData() functions and can preview their output.
Next, I've created a Crystal report with WorkerClothes as data input.
In my main window I've added report viewer and initialized it with
|
by: Michael Fay in SB |
last post by:
I built my application with Access 2003 and made a distribution using
the Microsoft Office Access 2003 Developer Extensions.
(I also install Jet 8 as a follow-on action at the end of the
installation.)
I can install the application on my development PC and on a "bare" PC.
Regardless of the PC where I install, in the installed application (but
not the development version)
File->Export from a Report brings up a dialog box containing...
|
by: Mark D Powell |
last post by:
I have installed Analysis Server (AS) and Reporting Services (RS) on
SQL Server 2000 before. Now I have been asked to install these on a
failover Cluster we have.
Previously I just ran the SQL Server 2000 install program off our
network disk and then ran the SP4 patch to install AS. When I ran the
install and chose AS there was no indication from the software that it
recogned that I wanted it to install on a cluster. After it said it...
|
by: sierra7 |
last post by:
Hi, I have a report that displays the correct data in Preview but displays #Name? when printed. (Access 2003)
The field is unbound but the control source is read from a form
=!. & " (Week " & !! & " to Week " & !! & ")"
ie. it shows a date range in text that is formatted in the form after the user has selected a week number range from the two combo boxes, and then the contents of the combo boxes.
The dialogue form is kept open until...
|
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: 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: 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: 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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
|