Snaking Report with Fixed Columns
I need a report with anywhere from 3 to 5 columns across. I want the column
headings (evenly spaced) to print with existing data (dates all coming from
one field) first and then a bunch of blanks below for the length of the page,
like so:
TERR1 TERR2 TERR3 TERR4
__________| __________| __________| __________|
__________| __________| __________| __________|
__________| __________| __________| __________|
__________| __________| __________| __________|
__________| __________|
|
3/11/2010 5:59:01 AM
|
0
|
=?Utf-8?B?RGFuYSBGLiBCcmV3ZXI=?= <DanaFBre...@discussions.microsoft.com>
|
|
Testing with Access 2010
I'm currently testing an application under Access 2010 Runtime. The
application is developed in Access 2003 and works under Access 2003 and 2007
just fine. As I anticipate that some of my users (there are over 1,000
worldwide) will eventually want to use Access 2010, I decided to run some
tests.
Anyway, I'm having a few "issues." The one I'm trying to work on right now
deals with the Lebans Report-To-PDF software (which is now unsupported).
Again, it works fine in 2003 and 2007 (as it did back in A2K ... but I no
longer support that).
All my reports are internally define
|
3/11/2010 2:14:10 AM
|
1
|
"Bob Howard" <i...@churchtrax.com>
|
Passing values between reports
Here is the deal,
I have a billing system that uses multiple reports. All reports get open
when I run the system. Everything works fine when there is data in all the
reports, and data summaries gets passed from all reports to the summary
report. Sometimes in one or more reports in a certain month, there is no
data, and instead of passing 0 (zero) from the these reports that do not have
data to the summary reports. I get #Error or #Name. (The summary values to be
passed are usually in the footer section of the reports)
I use this on the summary report to get the values from the re
|
3/10/2010 10:40:01 PM
|
1
|
=?Utf-8?B?TWFqZWQ=?= <Ma...@discussions.microsoft.com>
|
Report not updating after splitting database
I have created a database and have several reports that all worked fine. I
split the database and have added more entries in the ACCDE front end. I am
able to add and can exit the program and go back with all of the new
information still there.
However, when I go to run the reports, the only information that is showing
up is what was in there before I split the database. I have created several
reports, some based on dates and one that does a search based on the ID
number. All of these reports will only show the original information or will
show up blank if I try to find th
|
3/10/2010 4:48:02 PM
|
3
|
=?Utf-8?B?TGVhcm5pbmcgYXMgSSBnbw==?= <Learningas...@discussions.microsoft.com>
|
Average in a Sub Report Not Working
I have created a report that has 2 sub reports in it. The report consists of
call handling data for 6 agents. One of the subreports contains a field that
averages the data among the 6 agents. When I run the sub report on its own,
the average field works fine. When I run the main report the average field
only uses the one agent. So if Jane Doe's data was 94%, then her "team
average" is also 94%. When I go to the next agent, John Smith's data was 87%,
and the "team average" listed there is also 87%. It should list the average
of all (e.g. 94+87/2=90.5%).
Thanks for any help!
|
3/10/2010 2:41:04 PM
|
3
|
"MichelleM via AccessMonster.com" <u44...@uwe>
|
Settings Textbox in Chart
I have a report with a chart inserted. There is a texbox [Text Box 1] I would
like to programattically on the format event of the report.
Thanks
|
3/10/2010 2:31:01 PM
|
6
|
=?Utf-8?B?SGFyb2xk?= <Har...@discussions.microsoft.com>
|
Displaying info from multiple records in a report
I have a query that, as an example, returns records containing Employee Name,
Employee #, Employee Team, & Employee Address. My report displays up to
three records per page, one under the next. The number of records per page
depends on the Employee Team field which can be the same for multiple
employees One, how do I display multiple records per page and two, how do I
do that based on Employee Team? Kinda new to Access and any help is
appreciated.
|
3/10/2010 4:59:01 AM
|
7
|
=?Utf-8?B?VGhlV2l6YXJk?= <allb...@allbeit.com>
|
Counting Unique Values within a Group
I have a report that lists students by grade and the amount of money donated
by that student's family. If the parents are divorced, the student's name is
listed twice, once for each parent. I want to count only the unique student
record in each grade. DCount is giving me the count for the whole school
regardless of what group detail i put it in. How do I count only the unique
records within each grouping?
Thanks in advance.
|
3/10/2010 3:10:01 AM
|
2
|
=?Utf-8?B?U2NvdHQgQWxicmlnaHQ=?= <ScottAlbri...@discussions.microsoft.com>
|
11x17 Print
The Printer being used DOES have a Driver that supports 11x17.
In the Report "File - Page Setup", 11x17 IS available, but the Setting
doesn't always work on some Reports. I've tried Setting the 11x17 in
Report Preview, and in Report Design...neither works.
Any TIPs? TIA - Bob
|
3/9/2010 11:59:12 PM
|
2
|
=?Utf-8?B?Qm9iIEJhcm5lcw==?= <BobBar...@discussions.microsoft.com>
|
Custom Grouping
I need to group a report by dates that are within 45 days of the end of the
month, such as:
For the month of: Earliest Date Latest Date
January 12/17/2009 1/31/2009
February 1/14/2010 2/28/2010
Etc.
I also need the first and last month to have custom dates because it is for
a report that goes by the Federal Fiscal Year of Oct-Sept, so:
For the month of: Earliest Date Latest Date
October 10/1/2009 10/31/2009
November 10/16/2009 11/30/2009
…
September 8/16/2010 9/30/2010
October 9/16/2010 9/30/2010
|
3/9/2010 11:58:01 PM
|
2
|
=?Utf-8?B?a2M=?= <...@discussions.microsoft.com>
|
Get fiscal year to show in a report
I have a database that I'm trying to get a report to sort on my fiscal year.
I have a module that I set up (below) to set the dates for my fiscal year.
Function FiscalYear() As Date
Dim dtFiscalYear As Date
Dim strFiscalYear As String
Dim intMonth As Integer
intMonth = Month(Date)
'this will tell you the current month
If intMonth < 11 Then
strFiscalYear = "11/1/" & Year(Date) - 1
Else
strFiscalYear = "11/1/" & Year(Date)
End If
dtFiscalYear = CDate(strFiscalYear)
FiscalYear = dtFiscalYear
End Function
I then add
|
3/9/2010 9:41:01 PM
|
4
|
=?Utf-8?B?RGF2aWQgTWNDb3JtYWNr?= <David McCorm...@discussions.microsoft.com>
|
rows in a report
I have a text box with a number in it. How would I make that many rows in a
report based off the number in the text box?
Thanks in advance!!!
|
3/9/2010 8:52:06 PM
|
11
|
=?Utf-8?B?UEo=?= <...@discussions.microsoft.com>
|
Custom Grouping
I have a table with dates and expenses. Billing cycle starts on on the 24th
of each month, and I need to divide the month into four parts (approx). I
want there to be a header for the week starting date, followed by seven days.
Therefore, the week may start on Wed, 24-Feb and end on Tues, 3-Mar. For
example, I want the report to appear like:
Week Starting Date Expense
24-Feb
24-Feb $10
25-Feb $15
26-Feb
|
3/9/2010 6:36:15 PM
|
1
|
=?Utf-8?B?KkdsZW4q?= <G...@discussions.microsoft.com>
|
Printing Question
I have a report that I have been doing in Excel but is better done in Access.
However, the report is too large to print on a single page and that is a
necessity. With Excel, I just adjusted the scaling. I can't seem to do that
with Access I've also tried exporting from Access to Excel, but the
calculated fields are not exported.
Any suggestions on how I can print the report on one page?
|
3/9/2010 6:10:01 PM
|
1
|
=?Utf-8?B?cmFuZGxlc2M=?= <randl...@discussions.microsoft.com>
|
Printing Question
I have a report that I have been doing in Excel but is better done in Access.
However, the report is too large to print on a single page and that is a
necessity. With Excel, I just adjusted the scaling. I can't seem to do that
with Access I've also tried exporting from Access to Excel, but the
calculated fields are not exported.
Any suggestions on how I can print the report on one page?
|
3/9/2010 6:04:05 PM
|
1
|
=?Utf-8?B?cmFuZGxlc2M=?= <randl...@discussions.microsoft.com>
|
Printing Problem
I have a report that I have been doing in Excel but is better done in Access.
However, the report is too large to print on a single page and that is a
necessity. With Excel, I just adjusted the scaling. I can't seem to do that
with Access I've also tried exporting from Access to Excel, but the
calculated fields are not exported.
Any suggestions on how I can print the report on one page?
|
3/9/2010 6:00:04 PM
|
2
|
=?Utf-8?B?cmFuZGxlc2M=?= <randl...@discussions.microsoft.com>
|
Where do I initialize variables in a report?
Hi,
Where do I initialize public variables in a report?
I have a public variable where I put a sequential item number on each print
line. In the On Open event, I initilalized this ublic variables to 0. I then
do a print preview and a print. The print preview works fine, but the print
picks up the count from where the print preview left off.
I moved my initialization the the Report Header On Print event and it works
fine.
Is this the right way to initialize this variable or is there a more
appropriate event to initialize my variable. I tried On Activate, but that
di
|
3/9/2010 5:44:08 PM
|
8
|
=?Utf-8?B?RGVubmlz?= <Den...@discussions.microsoft.com>
|
Consecutive dates
Hi all,
Was wondering if I could get some help/insight/direction on how to tackle an
issue. I have a table that contains employee info along with dates that the
employee was absent. What I want to do is query this table to get all the
dates where an employee is absent consecutively and only apply one day of
chargeable hours.
For Example:
employeeID DateAbsent ChargeableHrs
ABC123 01/05/2010 8
ABC123 01/06/2010 8
ABC123 01/07/2010 8
ABC123 01/08/2010 8
ABC123 01/25/2010
|
3/9/2010 5:06:28 PM
|
3
|
"AccessUser777 via AccessMonster.com" <u44...@uwe>
|
Assemby Report
I have a report I need to create in Access 2003. The design has products
that are made up of sub products (which can have sub products), how can I
show the sub products by displaying them to the right of their parent
products, almost like a tree view control on a form?
|
3/9/2010 4:26:07 PM
|
2
|
=?Utf-8?B?RG9u?= <...@discussions.microsoft.com>
|
Reporting only current date forward
Hi everyone,
I have a report in which I only want it to show the events that are either
today or in the future and not show any of past events.
Can you help me out with this one. I just got this db already created
piecemeal and trying to sort thru everything.
Thanks
Lily
|
3/9/2010 2:24:05 PM
|
1
|
=?Utf-8?B?TGlseWJpdHQx?= <Lilybi...@discussions.microsoft.com>
|
Cancel = True - error
Hello All
I have a number of reports where I have set the OnNoData event to Cancel =
True. This works fine where the user attempts to open one of the report
usign a button created with the wizard for that purpose, but if they click a
button where the OnClick event includes lots of DoCmd OpenReport commands,
when the code reaches a report with no data they get a message that the
OpenReport was cancelled - and the code stops.
What do I do?
Hope someone can help
Many thanks
Leslie Isaacs
|
3/9/2010 12:29:19 PM
|
1
|
"PayeDoc" <enquir...@gppayroll.org.uk>
|
Snakeing report
I have a members database with people divided into groups or categories etc.
The report I am trying to do is have many columns at the group header level
with only one field - the fullname of all those members in the detail
section for that group. What I would like to have is this information
snaked through about 3 columns in this detail section. Is there any
way of doing it? Could it be a macro? Except I cannot think how to go
about it!
|
3/9/2010 11:10:22 AM
|
1
|
"Mervyn Thomas" <mervyn-tho...@ntlworld.com>
|
Report header below page header
I want a report heading on the first page - but I would like it to be below
the page header (so that my page header is identically positioned on all
pages).
Alternatively I want a part of my page header only displayed on the first
page.
How can this be made?
--
Diane
|
3/9/2010 10:29:01 AM
|
1
|
=?Utf-8?B?RGlhbmVQRGF2aWVz?= <DianePDav...@discussions.microsoft.com>
|
Access asks for parameters
I have aform with [date1] , [date2] and [print] controls on it.
I want to retrieve data from several tables using a query.
The query contains [datespan] Between [date1] And [date2].
The Print button on the Forms has a "where clause" ( [datespan]>=[date1] And
[datespan]<=[date2].
Also there is a graph to be printed that has the same sorting as the where
clause.
I get 3 pop-ups asking for date1 and date2. If I give the dates three times,
I get the print. Otherwise I get nothing.
If I re-type "date1" and "date2" in the form's text boxes (design view), the
result is OK. Until next
|
3/9/2010 8:19:02 AM
|
2
|
=?Utf-8?B?Sm9obiBG?= <Jo...@discussions.microsoft.com>
|
View/Print Individual Reports
Here is what I have:
I have a database for tracking therapy clients. Client data is in one table.
Therapy progress notes are in another with a one-to-many relationship. I have
a form w/ subform set up to receive the data. I have a query set up to tie
the two tables together and feed into a report. (Tables/Forms and Queries all
do what I want them to properly) Right now, the report contains data from
every client and progress note.
What I want is to be able to place a button on the subform for the progress
notes, so that when it is clicked it generates the report with just that
|
3/8/2010 8:53:01 PM
|
14
|
=?Utf-8?B?U3RldmU=?= <St...@discussions.microsoft.com>
|
Print several reports as one
I have several reports (8) that I would like to print as one. It's just
easier to have one big report to present to someone (email) than to print 8
reports and combine them somehow.
I have tried the macro route - it prints them all but as separate reports.
I have tried the switchboard route - same thing.
The only thing left is a Master report with 8 subreports. I am having
trouble with getting blank pages (every other page) and how do I handle
headers? The reports will have slightly different headers. All of the reports
are 2 pages. I can get a header on the first page only.
|
3/8/2010 7:29:01 PM
|
3
|
=?Utf-8?B?V2FybWFu?= <War...@discussions.microsoft.com>
|
Group Header
I have a text box named "txtCount" and the control source it is counting
tranches for each customer. I want this report to look at the highest number
of tranches for each customer. So ABC company has the highest number of
tranches I want that many rows for each customer. Can this be done? I was
thinking in the On Format of the group header.
|
3/8/2010 5:33:01 PM
|
0
|
=?Utf-8?B?UEo=?= <...@discussions.microsoft.com>
|
move fields independently
I'm trying to create a report with several fields...when I create the report,
all the fields are smashed together horizontally. I can't seem to pull one
field down separately, as all fields are connected. Is there an easy way to
"disconnect" the fields?
Thanks in advance...
|
3/8/2010 3:44:01 PM
|
2
|
=?Utf-8?B?ZnJldHM1NQ==?= <fret...@discussions.microsoft.com>
|
Running Total in report using net of two columns in third column
I have a client time/fees database of over 22k records. I have a report
which provided a summary of all time booke and all fees charges to that
client. What I require is two additional columns the first which provides a
running total of time bookings and the second which provides a running total
of the net of the time booked field less the fees charged field, i.e. the net
of time bookings which have not been invoiced.
I can do this in excel but in access I appear to be getting data from other
clients which should not be included in the report.
|
3/8/2010 9:17:01 AM
|
1
|
=?Utf-8?B?U291dGggRXNzZXg=?= <SouthEs...@discussions.microsoft.com>
|
Page Breaks for last 5 records
Hello,
I have a report that is grouped on [SessionNum] with many records under each
[SessionNum]. The records are sorted ascending by [EntryNum].
What I would like to do is insert a page break on the last 5 records of each
[Session].
Is there cody that could be written for this?
|
3/8/2010 2:11:01 AM
|
1
|
=?Utf-8?B?Uw==?= <...@discussions.microsoft.com>
|
How to prevent totals from doubling in printed report
I accumulate some totals in the Detail format event. WHen I vies the report,
these totals are correct, but when I print the report, they are doubled. I
now know when printing, Access processes the report twice. Since all of my
reports must be able to be viewed as well as printed, how can I use VBA code
to skip the accumulation on either the first or the second pass? Also, how
can I determine if the report is being Viewed or Printed?
Thanks,
|
3/7/2010 7:49:02 PM
|
1
|
=?Utf-8?B?R29sZGFy?= <Gol...@discussions.microsoft.com>
|
When is "collate" possible?
I have two reports, both with pagination. When I print one, "collate" is
the default, and the checkbox is enabled. When I print the other, the
"collate" checkbox is not checked and it is disabled. What is different
about these reports that affects the "collate" print attribute?
TIA
LAS
|
3/7/2010 4:30:57 AM
|
1
|
"Laurel" <FakeM...@Hotmail.com>
|
Merging results from multi-selection fields
I've created a database with several fields containing multiple selections.
I'm hoping to display the results in 1 grouped field. Is this even possible?
I am an Access novice.
|
3/6/2010 10:52:01 PM
|
0
|
=?Utf-8?B?Um9Nb00=?= <Ro...@discussions.microsoft.com>
|
Highlight between 3 fields
Hello
I would like to inquire about the best way in this for highligts
There are three fields
[Price1] [Price2] [Price3]
In the report, which field contains the Lower price between the 3 fields
will look highlight color example red color.
If all fields contain numbers I would like to show the lower figure the
value of a red highlight color.
When there is figures in all these fields
[Price1] [Price2] [Price3]
Three can use the following to show the red color on Price1
[Price1] <[Price2] AND [Price1] <[Price3]
But if one of fields inside is Null
|
3/6/2010 4:14:01 PM
|
4
|
=?Utf-8?B?SGlnaGxpZ2h0IGJldHdlZW4gMyBmaWVsZHM=?= <Highlight between 3 fie...@discussions.microsoft.c
|
Linking from a report to a form for same record
How can you make a report that allows you to have a link or button for each
record that displays which you can click and it will open a form for that
specific record?
This maybe easy, but I am still new to access. I appreciate any support that
can be provided.
|
3/5/2010 7:47:39 PM
|
2
|
"AaronBergquist" <u58...@uwe>
|
Repeating Information
Is there a way to have a field(s) only appear once on a page with multiple
columns? It seems silly to have it repeat the information that is constant
again in the next column. I just need the variable information to be in the
next column.
For example, the listing of sizes are the constant and only need to be
listed once on the left side of the page and the pricing for the different
items listed in each column to the right of the sizes.
|
3/5/2010 6:59:01 PM
|
9
|
=?Utf-8?B?anlvdW5nNzI5?= <jyoung...@discussions.microsoft.com>
|
MS e-learning 5456ae lab
I am on the "Manually01" lab. Number 4 says to "expand the Categories field
list, in the Field List pane, click the plus sign". Where is this Field List
pane? I can't find it.
|
3/5/2010 6:11:02 PM
|
0
|
=?Utf-8?B?QnJpYW4gUw==?= <Bri...@discussions.microsoft.com>
|
Total unchecked check boxes
Hello,
How do you sum unchecked check boxes?
Thanks in advance,
Ellen
|
3/5/2010 3:02:01 PM
|
2
|
=?Utf-8?B?RWxsZW5N?= <Ell...@discussions.microsoft.com>
|
Code to read email from Outlook
Anyone have code to read incoming email messages from ONE email address, or
experience with the functionality in Access2007 to do this process. I have
an upcoming project that will require this and I haven't looked into this
area.
Example: emails that are sent to support@blah.com are added to a table in
the database (everytime the user presses a button or a timer starts a
process). The "body" of the email goes into one field and the "from" email
address goes into another field.
Thanks,
Mark
|
3/5/2010 1:20:19 PM
|
0
|
"Mark Andrews" <mandrews___NOSPAM...@rptsoftware.com>
|
Cannot delete subreport
I am using Access 2003 and have a report I did a while back with a simple
subreport. I want to remove the subreport but for the life of me can't figure
out how to do it. Any help would be greatly appreciated. Thanks.
|
3/5/2010 12:16:02 AM
|
1
|
=?Utf-8?B?U3RvbmV5UGV0ZQ==?= <StoneyP...@discussions.microsoft.com>
|
Access Subreport Can Grow Problem
I have an acces reprt with three sub reports and other controls. My problem
is that the firs two subreports grow as needed and push everything under them
down fine. The third one grows but does not push the controls below it down.
All of the properties are identical between the three reports. I cannot
figure out why two of them are acting the way i want them to, and on is not.
I even created a brand new report and in it are my three subreports with a
line after each one. same result. The first two lines get pushed down the
third is covered by the subreport. Has anybody had this p
|
3/4/2010 10:52:01 PM
|
2
|
=?Utf-8?B?Sm9obm55?= <Joh...@discussions.microsoft.com>
|
Center Text
Hello all,
I have what would seem to be a very small problem, but I am unable to answer
it myself. I have a report that I am trying to create and each record can
have one of three categories. If there are multiple records for, let's say,
Group1, then I want a text box to span both records and center the text
within the report. This would be the equivalent of a rowspan in html.
I have no idea where to start. Am I missing something really simple?
The data is structured as the following:
Group1 | Record 1 | Some cool info
Group1 | Record 2 | Some cool info
Group 2 | Recor
|
3/4/2010 9:18:22 PM
|
4
|
"pib311 via AccessMonster.com" <u52...@uwe>
|
Only ID numbers are printing
I have Access 2007. I have two tables Contact List and Asset List. I am
trying to print two reports. I want to print the owner and the companies
they lease to from the Asset List. Also from the Contact List I would like
to list the Companies and their Lessors. When I try to do the asset list one
it only gives me id numbers. What am I doing wrong?
--
helpme
|
3/4/2010 8:36:01 PM
|
1
|
=?Utf-8?B?VmFuZXNzYQ==?= <Vane...@discussions.microsoft.com>
|
display report title on a report with columns
Hi,
I have set up a report that displays a list of words in three columns. The
title of the report does not show up in print preview. I have unchecked the
"same as detail" checkbox on the column tab of the page setup dialog box.
What am I doing wrong?
|
3/4/2010 7:34:09 PM
|
1
|
=?Utf-8?B?S2FyZW4=?= <Ka...@discussions.microsoft.com>
|
need help sorting text by trailing Numbers Value
I am looking for some help sorting a text field (PartNumbers) alphabetically
but correctly depending on the value of the ending few charachters if theyre
numbers..
Here is some sample data
an960pd10
an960pd300
an960pd6
i would like it sorted like this
an960pd6
an960pd10
an960pd300
any ideas?
Thanks
Barry
|
3/4/2010 7:18:04 PM
|
6
|
=?Utf-8?B?QmFycnkgQSZQ?= <Barr...@discussions.microsoft.com>
|
Trying to sort data into multiple columns on the report.
Access 2007 I have 1 data column that I want to get on a report, but I want
it to break into two/three columns like so and have some space inbetween the
columns:
1 7 13
2 8 14
3 9 15
4 10 16
5 11 17
6 12 18
The reason is this is a single checklist for people to fill out and multiple
pages is unacceptable. The list will be printed.
Thank You.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201003/1
|
3/4/2010 6:25:35 PM
|
3
|
"Hoardling1 via AccessMonster.com" <u43...@uwe>
|
Display in Report
I have a field named CR, the field size is long integer and the input mask i
have as 00\-00000. In this record i enter the case number of a case which is
something like 09CR12345, this field currently displays as 09-12345, i want
to change this so that in a report it inputs the CR instead of the dash -
can someone help.
|
3/4/2010 5:54:01 PM
|
1
|
=?Utf-8?B?bGV0dHlnODI=?= <letty...@discussions.microsoft.com>
|
subreport repeating parameters
dazed and confused here....
i have two subreports that i added to a blank report.
they each run off a different query.
one gives me totals of all results of audited cases.
the other gives me the details of those cases.
the problem is, when i run the report, it asks me twice for the parameters.
both queries have the same parameters.
what am i missing?
--
terri
|
3/4/2010 3:42:01 PM
|
3
|
=?Utf-8?B?dGVycmk=?= <te...@discussions.microsoft.com>
|
Calendar Error (Duane's Calendar)
I'm getting a runtime error 13 -- type mismatch and not sure why i'm getting
the error. The error is pointing to this line below. The report worked
great, but when I start adding more appointments, this error pops up.
Me.ClassID.Top = lngTopMargin + DateDiff("n", datSchedStart, Me.ClassTime) *
lngOneMinute
Dim lngTopMargin As Long
Dim lngOneMinute As Long 'size of one minute in twips
Dim datSchedStart As Date
datSchedStart = #8:00:00 AM#
lngOneMinute = 12
lngTopMargin = 1440 'timeline starts 1" down in section
Me.MoveLayout = False
Me.ClassID.Top
|
3/4/2010 3:31:01 PM
|
14
|
=?Utf-8?B?TkZM?= <...@discussions.microsoft.com>
|
count weeks in report
Hi!
I have a report that is grouped by week. Week 1 with various totals, week 2
with various totals etc.
Now, at the bottom of the report I want to count the actual number of weeks
the report shows.
Please help
--
BS
|
3/4/2010 2:42:01 PM
|
1
|
=?Utf-8?B?S2FudG9y?= <Kan...@discussions.microsoft.com>
|
Zoom Size in a Report
All the reports in my database (AC2000) open at 100% in printpreview. the
database is split and the backend is on only 1 unit. I have the database on
5 PCs: 3 local and 2 in another state. the local user has 2 desktop units
and 1 laptop. the remote user has one of each, both with the frontend
resident and the backend on an external hard drive that can be switched as
necessary.
The problem is that all reports open as 'Fit' on both remove units but as
100% on the local units.
I have checked and 'Track name Auto Correct' is NOT checked on any PC. why
would this setting
|
3/4/2010 3:56:01 AM
|
4
|
=?Utf-8?B?U3RldmUgUw==?= <Ste...@discussions.microsoft.com>
|
Report with pictures
I am trying to create a report with a picture (attachment field) in
the section header and a list of items in the detaild section.
The challage I have is that I want to show the picture to the left of
the items, not above.
Is there a way to have the picture that is in the section header to
"bleed" into the detail section, or does anyone have other
suggestions?
This is what I am tying to accomplish:
I have grouped on the item.
I can do this:
-------------
! !
! Picture !
! of item !
-------------
Item Size 1
Item Size 2
Item Size 3
It
|
3/4/2010 3:38:49 AM
|
6
|
Rolf <n...@wessman.com_remove_this>
|
Subtotals
I have a sales order report that I want to display the units ordered subtotal
if the ship quantity is zero and/or the line item is open; and the units
shipped if the quantity shipped is greater than zero and/or the line item is
closed. (if any quantity is shipped that line item is closed). currently I
have this for the line item subtotal:
SubtotalSO: CCur(tblSOTransactions.UnitPriceSO*[UnitsOrderedSO])
And it displays the units ordered subtotal regardless of whether the line
item is open or quanities have been shipped, creating a larger total for the
entire report. I'm sure th
|
3/4/2010 12:29:02 AM
|
1
|
=?Utf-8?B?TG9yaSBMZVJveQ==?= <LoriLe...@discussions.microsoft.com>
|
Multi-Table Reports
Having difficulty creating a report that involves multiple tables in Report
Wizard. Followed step-by-step instructions in book...doesn't work. Unable
to locate solution/answer to question on Help...?
--
Thxs-ddtadams
|
3/3/2010 10:52:01 PM
|
1
|
=?Utf-8?B?ZGR0YWRhbXM=?= <ddtad...@discussions.microsoft.com>
|
Report_Grouping
I have a report with many fields from one table. Six of the fields are memo
fields that can grow. I am trying to add a grouping to each of the memo
fields so that I can force a new page and / or keep together.
The memo fields are not showing on the field/expression dropdown. They are
valid fields and are present in the field listing.
Do I have too many other fields? Is there a limit? Can you not sort/group
on memo fields?
I tried having each of the memo fields as a subreport, but that does not
work either.
Any help you can give me is appreciated.
--
Teach me t
|
3/3/2010 9:37:02 PM
|
2
|
=?Utf-8?B?bSBzdHJvdXA=?= <mstr...@discussions.microsoft.com>
|
Report Gridlines
In generating reports, I have frequently drawn horizontal and vertical lines around my detail controls using the height of the Section to make the vertical lines uniform (rather than using borders which can differ in height). Now, using 2007 I can't get my code to work. Any thoughts on why?
Thanks
Here is my code:
'top horizontal line
Me.Line (0, 0)-((ddt_comment.Left + ddt_comment.Width), 0)
'vertical line on left margin of 1st column
Me.Line (0, 0)-(0, Me.Height)
' additional vertical lines between columns
Me.Line (ddt_name.Left, 0)-(ddt_name.Left, Me.Hei
|
3/3/2010 9:36:43 PM
|
0
|
Liz Taylor
|
double side report print
I have a report to print out on double side print, but it comes flip
on the back, any way from MS access to configure the back side
printing orientations?
Your information is great appreciated,
|
3/3/2010 5:32:03 PM
|
0
|
iccsi <inu...@gmail.com>
|
can grow / can shrink , control position conflict
I've got a report with several text boxes and/or sub-reports in the detail
section, and I'm having trouble keeping their horizontal alignments as
needed. Maybe someone can clue me into the "caviats" (or to a usefull
source that goes into the details and work-arounds...)
Many thanks in advance,
Mark
Here's the conditions I've got...
- the detail section is organized in three (3) columns (these are purly
graphic, and comply with the "format" of the report)
- in each column are 1 to seveal text boxes and/or sub-reports,
- currently the first control in each columnis a text bo
|
3/3/2010 5:09:35 PM
|
2
|
"Mark Kubicki" <M...@TillotsonDesign.com>
|
charts from Data just in two different reports
Basic charting seems to require the information to be in a table. I however
have the information only in a report. The two in question are COUNT(*) and
the other is week number where the control source =Format$([Dated],"ww",0,0)
Could anyone give me a pointer how to graph these please and as I have two
similar such reports is it further possible to graph both together on a
single chart
Many thanks
Richard
|
3/3/2010 3:45:01 PM
|
1
|
=?Utf-8?B?UmljaGFyZCBH?= <Richa...@discussions.microsoft.com>
|
SUM of COUNT?
I have a report based on a crosstab query that counts the number of enquiries
from an advertising source for a year and sorts them into months
So columns are by date and rows give the source and the value is the count
of enquries in the source.
I want to total the number of enquiries in the month on the bottom of the
report. I have tried putting a text box in the report footer that uses the
value field and set it's running sum property to over all but it just gives
the sum for the source and not all the sources added together.
Is it possible to do this?
|
3/3/2010 3:28:01 PM
|
8
|
=?Utf-8?B?UGV0ZXJX?= <Pet...@discussions.microsoft.com>
|
Group Rows by Subtotal or Count
Have a report that has 97 rows and I want to "Subtotal" the Count of Rows to
30, so I would end up with three "groups" of 30 and one "group" of 7.
However, all the group, sort, and totals are by field or names. Once I have
them in Groups of 30, I want the Subtotal amount for that group. How do I
create this Subtotal Count in the Field Footer of the Report? Thanks.
|
3/2/2010 11:21:01 PM
|
1
|
=?Utf-8?B?UnNraW5uZXI0?= <Rskinn...@discussions.microsoft.com>
|
Treeview
I am able to present data in tree view mode in a form,
Can this be done using the same tyype of code in reports?
Pat
|
3/2/2010 11:10:03 PM
|
1
|
=?Utf-8?B?UGF0cmljaw==?= <Patr...@discussions.microsoft.com>
|
Master/Child what section
Using Access 2007
As for back as Access 97 I have designed reports with the PageHeader section
containing the Master data and the Detail Section containing the Child data.
And a PageFooter containing more Master Data.
Trying to do a similar report now (Quotes in the PageHeader and Quote Items
in the Detail section) think Order and Order Items if you want.
Linking fields are QuoteNum in both.
Opening this report in report view has ex: QuoteNum 5000 and its data in the
PageHeader (as expected) but the Detail Section contains repeating lines of
QuoteNum 5000 items. Thirty repeats
|
3/2/2010 8:41:03 PM
|
4
|
=?Utf-8?B?Q2x5ZGU=?= <Cl...@discussions.microsoft.com>
|
Check Box Grouping
Hello,
When I group on a check box field, I get duplicate records. Would anyone
know why this would happen?
Ellen
|
3/2/2010 5:45:01 PM
|
5
|
=?Utf-8?B?RWxsZW5N?= <Ell...@discussions.microsoft.com>
|
saving an access report as a txt file
I have an Access 2000 database file that is being used in access 2003.
Everything works fine except when you try to export a report to a txt file
the file cuts off lots of data making it useless. I have tried all 4 formats
with the same reult. Yet if the same report is exported in Aceess 2000 it
works fine. What am I missing or not setting up for?
--
the Dataman
|
3/2/2010 5:16:01 PM
|
7
|
=?Utf-8?B?RGF0YW1hbg==?= <Data...@discussions.microsoft.com>
|
Update Report
I have a report that doesnt show all of my data from the table. It worked the
first time, then yesterday I added more entries. It only shows the older
entries now. I'm sure this is probably something simple that I'm overlooking,
but can someone please tell me how to get my Report to update so that it
shows all records in the table every time? Thanks for your help!!
|
3/2/2010 1:20:01 PM
|
10
|
=?Utf-8?B?dHNxdWFyZWQxNTE4?= <tsquared1...@discussions.microsoft.com>
|
ID number showing
I created a report that collects its data from a query. When I run the query
the correct information displays. When I run the report one of the fields
displays the ID number of the data table rather than the text entered into
the table.
--
bmorganh
|
3/2/2010 6:20:01 AM
|
1
|
=?Utf-8?B?Ym1vcmdhbmg=?= <bmorg...@discussions.microsoft.com>
|
simple format question
i have the following entered as the format for a text box:
(000) 000-0000" x"000
but am getting a display that looks like this:
(000) 212-6757 x760
when it should be:
(212) 675-7760
The field has number data type and the last 3 digits (the phone number
extension) is not always included (I suspect that i may need to break the
extension out to a seperate field (?)
any thoughts would be greatly appreciated
-mark
|
3/1/2010 7:10:46 PM
|
3
|
"Mark Kubicki" <M...@TillotsonDesign.com>
|
Subheaders
I have a report built to show year one projects, then subcategory of space
projects and repair projects. I also have budgets for each project, each
category (repair and space), Grand Total, and then an overall running sum.
My year one projects id#s start with 1112, year two with 1213. I can't figure
out how to get a label for year one and year two. It puts year one and year
two on year one projects and year two projects. I have grouped on project
year and project category (space or repair.) Thanks!!!
--
Milton Purdy
ACCESS
State of Arkansas
|
3/1/2010 3:11:02 PM
|
9
|
=?Utf-8?B?Z29sZmlucmF5?= <golfin...@discussions.microsoft.com>
|
Sub Report's Size
I have a sub report which has different number of records depending upon the
Account No. in the Main Report. I want the sub report to be resizable to
reflect all the relevant entries. How to do so?
--
Thanx & Best Regards,
Faraz!
|
3/1/2010 11:42:02 AM
|
1
|
=?Utf-8?B?RmFyYXogQS4gUXVyZXNoaQ==?= <FarazAQure...@discussions.microsoft.com>
|
Join problems
Access 2007
I am trying to produce a simple query or at least I think that it should be
simple. I apologize in advance as to how I am going to explain but could
not think of any other way to express what I am trying to do..
First part of the query returns this
qryTestSfActive
tblRegStudio.NotActive tblRegModels.NotActive Active PageName StudioID Stage
FALSE FALSE TRUE SF Icssa-110 GISILLA
FALSE FALSE TRUE SF Icssa-110 Montane
FALSE FALSE TRUE SF Icssa-110 Nirvanna
FALSE FALSE TRUE SF LATA-010 ALEXEA
FALSE FALSE TRUE SF LATA-010 Amanna
FALSE FALSE TRUE SF LATA-010 Anyta Paz
|
3/1/2010 1:09:35 AM
|
7
|
"Biss" <raleygrou...@hotmail.com>
|
Table-like Outline and Collumm that sums prevous values up
Hello
The report I would like to have should be in a tabular form just like the doc
document I have attached.
However, until now I have not found out how to set the report into a tabular
outline. It is quite uncomfortable and time intensive to set up this report
by using lines and the different text fields. In addition, it will not look
any good at the end..
Also, I would need a columm that is able to sum up the values before. Just
like the "total" under each semester.
Are the issues solvable?
Greets,
Hubertholz
attached:
http://rapidshare.com/files/357082410/Transcri
|
2/28/2010 6:32:21 PM
|
4
|
"hubertholz" <u58...@uwe>
|
Design view arrange
Hello,
I am trying to make a custom report in design view, but I want a group of
text boxes that have the OnGrow property set to yes, not to affect the bottom
one that I have put them far from them.
The thing is that in print preview, when the fields grow, I want a few
textboxes to stay in place (fixed).
Is there a possibility to do that?
Thanks!
|
2/28/2010 9:52:01 AM
|
5
|
=?Utf-8?B?SnVsaWE4Mg==?= <Juli...@discussions.microsoft.com>
|
Emailing report sections
Access 2007
I have a report that I sorted bye sales groups, In each sales group are the
details.
I need to email to each group their part of the report. I would even be ok
with coping and pasting the groups.
So far I have run into a blank wall..
Thanks in advance
Bob
|
2/28/2010 1:06:48 AM
|
4
|
"Biss" <raleygrou...@hotmail.com>
|
Printing or Not Printing Pictures
Using Access 2007. This may not be the best approach but this is what I have
done... I am trying to create a home inspection database. In my table for
bathroom I have the following fields referring to pictures: TPic as an
Attachment to add pictures of a toilet (don't laugh!); SPic for sink; VHPic
for Venting/Heating; BTPic for bath-tub; SHPic for Shower.....
On the form for each area (I have the form set-up as pages / tabs) each
attachment field is on the applicable page. That works fine. The user can
add as many pictures as they want easily.
I can put the attachment fie
|
2/26/2010 9:49:01 PM
|
0
|
=?Utf-8?B?bmhkZWU=?= <nh...@discussions.microsoft.com>
|
memo field expansion in details section of report?
Hi,
I have a Access 2003 report.
I have added a memo field to the details section. I have carriage returns in
the field and some of the records returned have memo fields with anywheres
from 1 to 15 carriage returns.
I would like to dynamically expand the vertical size of the details section
to only show the required space to show all 15 lines in the memo field, if
this is possible.
So that if I had 3 detail lines as so:
detail line 1,: memo field has 15 carriage returns
detail line 2: has 1 carriage return
the detail section will really only be approximately 16 lines in
|
2/26/2010 7:26:54 PM
|
1
|
"Haggisns" <u58...@uwe>
|
Why don't my MS Access Charts Take?
I have created a query, and a blank report.
I add a chart, and select the query as data source, using six fields
and fill out the rest.
BUT, when I go to look at my graph, it DOESN'T pick up the data. I
only goes back to showing the 1st Quarter, 2nd Quarter, 3rd Quarter,
default data! (and not my own...)
Any tips?
|
2/26/2010 5:56:17 PM
|
1
|
Zoomiest <zoomi...@gmail.com>
|
Query/Report Help for Date Difference
Good Morning. I am trying to figure out how to calculate the number of days
between two dates. I have a table callled events. That table has event
date, event type, event outcome. I am pretty new to Access and need help.
For example a defendant will have an Advisement Date (AA as stored in the
table) and say a Preliminary Hearing date (PH). When i enter information I
will enter the date, event type and the event outcome will be (PD for
Pending, CN for Continued, or CP for completed). For example Case Number
10-12345 will have an AA on 01/05/10 which is Completed and a Pre
|
2/26/2010 3:45:02 PM
|
8
|
=?Utf-8?B?bGV0dHlnODI=?= <letty...@discussions.microsoft.com>
|
User input criteria appearing on report
I have a report that asks the user for beginning and ending dates. How can I
get these dates to print on my report? TIA
--
Logo
|
2/25/2010 7:55:01 PM
|
5
|
=?Utf-8?B?TG9nbw==?= <L...@discussions.microsoft.com>
|
Help needed - want to count categories within a category on a repo
I have demographic information captured in a demographic table(5 categories
of ages - 24 to 34, 35 to 44, 45 to 54, etc., 5 categories of educational
level - high school, some college, etc., 5 categories of household income
level - under 25K, 26 to 50K, etc., 5 ethnic groups - caucasian, asian, etc.)
I have one field for age, one field for educ. level, one for ethnic group and
one for hh income within my demographic table. Drop-down boxes hold the
various values for EACH of these fields (see above).
I have several courses for which I need to show registrations (from my
registr
|
2/25/2010 7:09:01 PM
|
5
|
=?Utf-8?B?TGF1cmE=?= <La...@discussions.microsoft.com>
|
Print Report If Sub-Report Has Data
I have a series of reports that I only need to print if their sub-report has
data in it. If there is not sub-report data I don't need to print the
report. Pretty standard report based on a query made at the report.
Sub-Report based on a table that filters out results specific to that report.
--
Thanks As Always
Rip
|
2/25/2010 2:53:02 PM
|
2
|
=?Utf-8?B?UmlwcGVy?= <Rip...@discussions.microsoft.com>
|
Format Address
How can I format this ([account name] & ", " & [customer street address] & ",
" & [city] & " , " & [state] & " , " & [zip code]) in a query to show on a
Form or Report to look like this below.
Account Name
Customer Streer Address
City state Zip Code
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1
|
2/25/2010 2:45:36 PM
|
2
|
"turks67 via AccessMonster.com" <u48...@uwe>
|
Crosstab Report
Thank you for taking the time to look into this problem. Using Access2007,
How can I create a report that looks like this?:
‘ ColumnHead
(AuditorID)
‘ Satisfactory
Unsatisfactory
RowHead1(FloorProgName)
RowHead2(FloorProgCriteriaShortDetails) 0 1
RowHead2(FloorProgCriteriaShortDetails) 1 0
RowHead2(FloorProgCriteriaShortDetails) 2 0
RowHead2(FloorProgCriteriaShortDetails)
|
2/25/2010 2:32:15 PM
|
1
|
"T5925MS via AccessMonster.com" <u58...@uwe>
|
Excel Spreadsheet pasted into report functions??
Ive found that i can copy and paste a section of an excel spreadsheet into a
report.
If i then double click on the pasted image it seems to open up excel within
access.
Im not sure how this is working as im still new to access.
What i was wondering is if its possible to embed calculations in the
individual excel cells that with be calculation using the data held in the
Tables I have present in my Access Database.
Many thanks for any help :)
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201002/1
|
2/25/2010 12:25:17 PM
|
0
|
"mark909 via AccessMonster.com" <u58...@uwe>
|
Need subreport column headers to repeat when data goes onto next p
Hello,
I've a subreport that has columns of data. I need the column headers to
repeat when the data spills onto the next page so that users will know the
type of data they are viewing. How can I do this?
Thank you for the help,
|
2/24/2010 6:14:01 PM
|
4
|
=?Utf-8?B?TG9uZGEgU3Vl?= <Londa...@discussions.microsoft.com>
|
Need help with using a bar graph in a report
I have a report that separates information about representatives by manager.
I need the graphs to give a quick summary on a few stats from each rep but
only show for that manager's team and not all information.
For example:
Manager A has RepA, RepB, and RepC under him. Each rep has Aux1, Aux2, Aux3
information which needs to be displayed. My goal is to show Manager A with
his Reps A,B, and C of their Aux1, 2, and 3. Then, under the next manager
Header I want Manager B to show Rep D, E, and F with their Aux1, 2, and 3
information. Etc thru Manager G.
Please help...
|
2/24/2010 5:35:02 PM
|
4
|
=?Utf-8?B?V2VzbGV5X0RhbGxhcw==?= <Wesley_Dal...@discussions.microsoft.com>
|
Date Difference
Good Morning. I am trying to figure out how to calculate the number of days
between two dates. I have a table callled events. That table has event
date, event type, event outcome.
For example a defendant will have an Advisement Date (AA as stored in the
table) and say a Preliminary Hearing date (PH). When i enter information I
will enter the date, event type and the event outcome will be (PD for
Pending, CN for Continued, or CP for completed). For example Case Number
10-12345 will have an AA on 01/05/10 which is Completed and a Preliminary
Hearing on 02/05/10 which was C
|
2/24/2010 5:35:01 PM
|
4
|
=?Utf-8?B?bGV0dHlnODI=?= <letty...@discussions.microsoft.com>
|
Dialog Form for filtering report
I have a custom dialog form with an unbound list box, an option group, and
some check boxes, by which the user configures his report. There are command
buttons for Preview and Print. The user clicks the various controls on the
dialog box, then click Preview. If he doesn't like the result he closes the
preview, and clicks few more boxes in the dialog form and previews again.
I must be needing some kind of requery because once certain records are
filtered out, they won't come back just by rechecking the appropriate
checkbox. The dialog form has to be manually closed and reopen
|
2/24/2010 4:20:02 PM
|
5
|
=?Utf-8?B?b2xkYmxpbmRwZXc=?= <oldblind...@discussions.microsoft.com>
|
Page setup / page / size??????
Hi,
When you are in design view and you click on 'Page setup / page / size' are
the options listed based on the printer you have installed or are they
options that Access knows? If I select any of the options listed will they
work on any printer?
Thanks,
Phil
|
2/24/2010 4:08:01 PM
|
1
|
=?Utf-8?B?UGhpbGxpcA==?= <Phil...@discussions.microsoft.com>
|
Report not displaying correctly on a different computer
Hi
Not sure what is causing this. I have a quite complex report in Access 2007
that necessitates 53 columns, all next to each other; and with 53 fields in
the header showing the date 'vertically' in dd-mmm format.
On my Desktop and my Laptop they work fine - the Preview and Print options
all show the date clearly. I transferred the DB to a user's laptop - (they've
been using an earlier version in 97 and 2003 format for 9 years or so) and
the date just shows as #### in everyone of the 53 fields.
Thought at first that it was the vertical aspect of the field that was
throwing it ou
|
2/24/2010 3:57:53 PM
|
3
|
"pwdpwd via AccessMonster.com" <u57...@uwe>
|
Duplicate Paramters
I am using Access 2002. I have a report that is grouped by txtCourseTitle
and the information is in the group footer. I have another report that I
want to show up on this report so I dragged it into the same group footer.
Each of these reports has their own parameters to enter for Year and Quarter.
When I run the report the first reports parameters run, I enter both of
them, then the report that was dragged into the group footers' parameters
run. The problem is they run twice. Can anyone tell me why and know how I
can fix it to not do that. If the report is run outside of the rep
|
2/24/2010 2:48:02 PM
|
2
|
=?Utf-8?B?QW5u?= <...@discussions.microsoft.com>
|
Can a Subreport print it's textboxes on the Main report?
I'm having a heck of a time creating a monthly report for work. It has to
sum daily values and group them as monthy totals. It also will show fees
that are received once a month. I created a subreport for these fees but
they need to blend in with the other data.
How do I get the subreport's results to line up with the main report ones?
TIA for any help...
--
Logo
|
2/24/2010 8:24:01 AM
|
3
|
=?Utf-8?B?TG9nbw==?= <L...@discussions.microsoft.com>
|
Underline a portion of Text via VBA
In my report I have a textbox named: Text110
Controlsource ="Svc " & [Svc/Qtn] & " No.: " & [QtnNo] & [QtnAB]
The result in the preview is like below :
Svc Revised-Estimation No.2010/2356
My requirement is to under line only the portion 2010/2356 only via VBA code.
I may have put the line manually under the text, but the description inside
the text keep changing some time Estimate, some time Revised-Estimate,
therefore the allingment of the line underneath changes. That is the reason
for a code, which will draw a line exactly calculating like from
Right(Text110,9)
Pl
|
2/24/2010 6:56:01 AM
|
5
|
=?Utf-8?B?SXJzaGFkIEFsYW0=?= <IrshadA...@discussions.microsoft.com>
|
Sorting a simple grid style report
Access 2007.
I have a simple report (no vba code) (called an Unrelated Object) that
selects all data in the table and prints it in a format like an Excel sheet.
If I click on an entry in the report I can then filter by that column to
shorten the report.
I cannot figure out how to get the sort options in the filter panel to be
active so I can sort on the column.
|
2/23/2010 10:58:02 PM
|
0
|
"SBCUser666" <u58...@uwe>
|
Change Record Source
I'm trying to change the RecordSource of a report based on the value given in
a combobox, but it's not working. Any advice to get me pointed in the right
direction would be greatly appreciated!
Here's the code I have now:
Private Sub Report_Open(Cancel As Integer)
If Forms!frmReportType!cboReport = "Original" Then
Me.RecordSource = qryBilling
If Forms!frmReportType!cboReport = "Amended" Then
Me.RecordSource = qryBillingAMENDED
End If
End If
End Sub
|
2/23/2010 8:38:02 PM
|
10
|
=?Utf-8?B?VGFyYQ==?= <T...@discussions.microsoft.com>
|
Send report with subforms via email (.rtf) ?
Hi,
The company I work for uses an Access 2003 application that I am familiar
with but I did not create myself. We find it useful to be able to email
copies of certain reports to customers. Currently, we are able to do this
for most reports by opening the report in Print Preview mode. We then
right-click on the previewed report and choose Send To => Mail Recipient and
choose "RTF" as our desired format. This works great except for one
particular report. I believe the problem with this one particular report is
that it makes use of two SubForms. When we try to send this re
|
2/23/2010 7:41:01 PM
|
1
|
=?Utf-8?B?UGF1bCBLcmFlbWVy?= <PaulKrae...@discussions.microsoft.com>
|
Using a Calculated Control in a Report
I have a report that uses a query for record source, so in my report
procedure I can simply reference the fields by name.
However, one important value is from a calculated text box. I need to use
this value in selecting records for the report, but I don't know how to
reference it from within my procedure. If I had stored it in the table as a
field (e.g. tStatus), I could just reference it by name:
' String for Where Conditions, where Status is in a list of selected values.
Dim strWhereStatusIn As String
strWhereStatusIn = " and tStatus in ("
Instead, I have a te
|
2/23/2010 7:39:02 PM
|
2
|
=?Utf-8?B?b2xkYmxpbmRwZXc=?= <oldblind...@discussions.microsoft.com>
|
Circular Reference Error
Can anyone see what would be causing me to get a circular reference error???
Thanks!
SELECT [BartS1Report].Customer_ID, [BartS1Report].Customer,
[BartS1Report].Service_Address, [BartS1Report].Employee,
[BartS1Report].Manager, [BartS1Report].Type_of_System,
[BartS1Report].Raw_Water, [BartS1Report].Treated_Water,
[BartS1Report].Cycles, [BartS1Report].Inhibitor_Level,
[BartS1Report].Range_1, [BartS1Report].Range_2, [BartS1Report].Range_3,
[BartS1Report].Range_4, [BartS1Report].Range_5, ((SELECT Sum([XX].[ZZZ]) FROM
[BartS1Report] AS [XX] WHERE [BartS1Report].Customer_ID &
[B
|
2/23/2010 6:59:01 PM
|
3
|
=?Utf-8?B?VGlh?= <...@discussions.microsoft.com>
|
Reports duplicating rows of information
Hi,
I have inherited an Access 2000 database. Whilst i am in the process of
bringing to a useable standard, it is producing an unusual glitch.
I have a form which is used for orders, which the data is subsequently used
for producing order forms and invoice sheets. At random times the Report
will replicated lines of data from one of the subforms. The data only
appears in the table once and I can only see this error on the forms
themselves.
I am bound to have many other queries as I have become used to using 2007.
Thanks in advance
Charlotte
|
2/23/2010 4:46:01 PM
|
3
|
=?Utf-8?B?Q2hhcmxpZQ==?= <Char...@discussions.microsoft.com>
|
Bold Font vs NOT Bold Font
I have an Access Application that prints labels for medical devices. I am
printing the Greek Symbol "Capital O with a Slash" (Ø) using Arial Unicode
MS, 14 pt. (Symbol commonly used for diameter.) Not Bold. I have also
set the font weight to Very Light or Thin as an experiment.
Right next to it (In a different control), is the number 10, Using Arial, 14
pt. Bold. Next to that in a different control also is "mm", using Arial 10
pt. NOT bold.
Looks fine in print preview. However, when I print it on any of my 4
printers, the Greek Symbol appears bold! It is at least
|
2/23/2010 4:45:01 PM
|
1
|
=?Utf-8?B?dGtvc2Vs?= <tko...@discussions.microsoft.com>
|