|
Listbox from Query
Thought this would be easy...
A report is based off a table: tblServer
There is another table: tblServerIPS, which stores the IPAddresses of each
server (1 to many).
On a report, I want to display server data (name, serialtag, etc.) along
with all the IP addresses of the server.
What is the best way to accomplish this? I've tried the Listbox control and
have been unable to to ...
|
6 |
31.08.2006 04:02:22 |
|
|
**** Print the record in the form.
I followed this procedure from allenbrowne.com. It opens my report with no
data.
What I have is a form with two subForms. First subForm is labeled Test, this
has test name, control name, lot number and in use date. (About 44 data
entries.)
Second subForm is labeled Test Results, has Lan-ID (Person entering data),
date, load # and test results. For each test I could have many results ...
|
1 |
31.08.2006 00:16:01 |
|
|
Fields on Report Duplicating only one entry
I have a report created from Excel to record employee’s time. I am new to
writing SQL so I need some assistance in creating this, if this is the
solution. I have a query for each employee’s time worked for the week, the
report needs to display the employees time for the week, but the fields are
duplicating only one entry down the whole page. My fields on the report are;
left row, Job...
|
2 |
30.08.2006 21:27:02 |
|
|
Report Count using Visual Basic
I have a form that "filters" a report.
It works fine but now I would like to have a message pop up anytime the
criteria entered has no results. Right now I get a report with no data.
How to I capture the amount of records using VB?
I run my report as follows:
DoCmd.OpenReport "repAssyNo", acViewPreview, , strMod & "AND" & strDraw1 &
"AND" & strDraw2, acWindowNormal
--
-CL...
|
5 |
30.08.2006 17:55:01 |
|
|
Can this be done?
I have two columns in the table that feeds my report. One column determines
the color of a report control and the other column determines the content.
Both columns contain data, the first contains a color code e.g. 1=Yellow,
2=Red, 3 = Blue etc.
Obviously the report controls must overlay each other and the content of the
color column must not display. The content of the content column must...
|
4 |
30.08.2006 17:02:01 |
|
|
Results of Multiple Queries to one report
I am new to reports and have a db that creates a number of different results
in various queries ... Can I display the results of multiple queries in a
single report ??
Any pointers would be appreciated
Many Thanks...
|
4 |
30.08.2006 16:56:29 |
|
|
Calculating a total in a report
I have one column that I would like the grand total to print in the footer
section of the report. Can you tell me the correct expression to use and if
I can do this in report design view?...
|
2 |
30.08.2006 16:55:13 |
|
|
how do i use > and < in a querry
how can i use the greater than or less than symbols in a query so that i can
find a certain range of numbers?...
|
4 |
30.08.2006 16:52:52 |
|
|
Formating Fields
I am creating a report in desing view. Is there a way to have each field
that I add to the report match the current field's format? I don't want to
have to keep change the size and the font etc... each time I add a field. Is
there a way to make the report fields default to a certain format and size
etc...?
Let me know.
Thanks,
Stephanie...
|
2 |
30.08.2006 16:48:31 |
|
|
Page set up
Is there a way to verify if a label report was created with Continuous Feed
selected as the label type? I have some label reports that were created with
the Label Wizard which allows the user to select the label type of Sheet or
Continuous Feed. I need to verify they were created correctly (there are a
lot of different reports) and wondered if there was a way to see the label
type in t...
|
1 |
30.08.2006 16:16:02 |
|
|
Report gives extra page
I have a report set up that has group headers and footers for "model"
In the group footer I have a page break.
It works well in terms of starting a new page for each model, but I also get
a blank page at the end. How do I get rid of that blank page?
--
-CLSWL...
|
3 |
30.08.2006 15:13:01 |
|
|
Font Properties Problem
I have a report based on a crosstab query trending data by week. I have set
the column names in the query so I have fields in the report as new data is
entered. I brought the data fields into the report and formatted them all
the same; Arial 10 BOLD.
Week 32, 33. and 34 display Arial 10, BOLD
Week 35 will not display bold no matter what I do.
Any Ideas Anyone?
--
Jeff C
Li...
|
1 |
30.08.2006 13:27:02 |
|
|
Choose function in Access
I have a database listing Hymn names. I have a lookup table indexed with
numbers 1-3 and names Processional, Communion, Recessional. The database
field [UseFor]is a lookup field and automatically stores the number 1-3 for
the selection.
When I try to write a report using this database, I want the field [UseFor]
to display the name Processional, Communion, Recessional.
Under the Cont...
|
3 |
30.08.2006 13:24:03 |
|
|
bind a virtual recordset to a report
hi folks,
using A97. here's the scenario: i have an Excel worksheet which is printed
out as a blank form with lines in columns, which is filled in by hand (don't
ask). the leftmost and middle columns are pre-filled with sequential numbers
calculated in the spreadsheet so that on the first printed page you see
numbers 1 - 20 in the left column, 21 - 40 in the middle column; second page
41 ...
|
1 |
30.08.2006 13:23:04 |
|
|
Can't Export Data To Excel
Dear all,
I preview a report, the I press icon Analyze It With Ms Excel, but it
doesn't work.
Please guide me to solve it.
Thanks.
Vensia
...
|
2 |
30.08.2006 13:00:08 |
|
|
Header of Subreports in Main report
Hi,
I am a n00b in building reports in Access and have the following
question. I have created several reports, which in some instances have
different headings than the other ones. All these reports I would like
to see in one main report.
I guess, this can be done with a subreport in a mainreport. I have done
so, however cannot see the headings of the subreports in the one
combined repor...
|
2 |
30.08.2006 12:37:48 |
|
|
Running Reports
When I run a report, is there a way to use the "Microsoft Date and Time
Picker Control, Version 6"? To Pick My start and ending date for the report
I have a Expense Report That I need to Pull Between Dates
Any help would be GREAT...
|
2 |
30.08.2006 09:44:41 |
|
|
Sorting and Grouping - Changed Behaviour in Access 2003 versus 200
I believe the behaviour of Sorting and Grouping has changed from Access 2000
to Access 2003. I have a report with a Sub-Report in the Page Footer of the
main report. The Sub-Report uses the Link Child Fields and Link Master Fields
properties to determine the content of the sub-report in the page footer.
When the field values change and the page footer prints - the values in
Access 2000 t...
|
2 |
30.08.2006 09:41:21 |
|
|
Access Chart Wizard - can design view show my data not preset?
When creating a report using chart wizard I want to change the labelling of
the series/legend etc. But when I go to design view to do this, it often
shows me different data to that which my chart is based on, thus not allowing
me to change the labels. Can I force it to show my data?...
|
1 |
30.08.2006 08:59:02 |
|
|
Paramaters
Between [Expense Starting Date? (m/d/yyyy)?] And [Expenses Ending Date?
(m/d/yyyy)?]
This is my formula that i have in the criteria of my query
When running the report i have to enter Expense Starting Date 8/1/2006
and Expense Date 8/31/2006. This works, but is there a way to have a
calender to be able to pick my starting date and ending date.
Any help would be GREAT...
|
6 |
30.08.2006 08:06:16 |
|
|
Grabbing only certain records for total
In a report I have certain records tagged as true or false, if a record is
true I want to include it in a calculation if it is false I want to ignore it
in the total, any ideas how to do this
Thanks...
|
2 |
30.08.2006 02:49:56 |
|
|
Sub-Report won't always display..
hello there,
I am trying to dynamically assign a report (and its sub-report) resultset
values from various form filters, ie. toggle buttons, combo boxes, via a
SELECT INTO query being ran then assigned as the report's record source..
I have the sub-report 'link child fields - link master fields' functionality
linked to the parent report correctly as far as i can see.
The issue I am hav...
|
1 |
29.08.2006 23:43:31 |
|
|
I want a Grand Total from the Wizard -- no Groupings!
I want a simple tabular report with a grand total at the bottom of the
report. The wizard won't give me a Grand Total row unless I have a group-by.
Ideas? I know I can do it manually, but I've begun a campaign to have the
wizard do as much as possible for me.
--
Jim...
|
4 |
29.08.2006 22:46:01 |
|
|
Access prints [none] on header of report
Hello,
Would anyone be able to help with the following query:
Access 2000 reports that have been in use for some time are now, all of
a sudden, printing with the word and brackets [none] in the top left
hand corner of the page. The [none] problem does not display in Print
Preview view, and there are no unaccounted for labels, text boxes or
fields. The word and brackets display only on ...
|
1 |
29.08.2006 21:15:23 |
|
|
Filter not working for report
Good morning! My problem is complicated to explain, I will try to be as clear
as possible.
I have a report containing a main section + 2 sub reports. The total of 3
sections all have different filters in the report filter. In a form, I have a
multi-select drop down to choose the desired departments to include in the
report.
When running the report, it looks like the multi-select wo...
|
4 |
29.08.2006 17:54:22 |