|
|
|
Grid Line for First Field in detail
Thu, 9 Oct 2008 09:56:09 -0700
I can get grid lines around each field except the first field.
How do I get a grid line on the left side of the first field:
Here is my code:
For Each CtlDetail In Me.Section(acDetail).Controls
With CtlDetail
Me.Line ((.Left + .Width + intLineMargin), 0)-(.Left + .Width + _
intLineMargin, Me.Height)
En ...
|
"This expression is typed incorrectly, or it is too...
Thu, 09 Oct 2008 16:31:01 GMT
Can someone tell me what is wrong with my query
SELECT MTCQ.MONTH, MTCQ.YEAR, MTCQ.DISTRIBUTOR, MTCQ.UPC, MTCQ.[ITEM
DESCRIPTION], MTCQ.SIZE, MTCQ.[CASE PACK], MTCQ.[DIRECT IMPORT], MTCQ.[BDM
STATUS], Sum(MTCQ.tncp) AS SumOftncp, Sum([Tbl_Cumm Actual Results].[BILL
UNITS]) AS [SumOfBILL UNITS], Sum(([BILL UNIT ...
|
grid lines in group header
Thu, 9 Oct 2008 09:00:05 -0700
I am trying to add grid lines to a group heade 0 in a report.
I can get the grid in the detail section, but how do I get the same in a
group header0
Here is my code for detail section
Detail:
For Each CtlDetail In Me.Section(acDetail).Controls
With CtlDetail
Me.Line ((.Left + .Width + intLineMargin), 0)-(. ...
|
Drop Down Box
Thu, 9 Oct 2008 08:44:14 -0700
I created a report that displays a specified health record, the user types in
the health record number and then the report comes up with all the
information. I would like to create a drop down box on the report which
would allow the user to select the manager/technician that filed created the
report to be s ...
|
Bordering for Report
Thu, 9 Oct 2008 08:36:03 -0700
I have designed a report which is a certificate for candidates atteneding a 1
day course. It has page header, details and page footer. I am using the page
header and footer for logos and page details for candidate details.
I need to draw a page border continuously across the page header, details
and page fo ...
|
error 0x80080296 no results?
Thu, 9 Oct 2008 08:20:00 -0700
Says this Error, but no download works, it tells you to do. ...
|
Creating a report from a query
Thu, 9 Oct 2008 08:19:01 -0700
I am having problems pulling in the information I want from my query to my
report due to table relationships.
I have created a report from a query that shows the number of animals sold,
died or transferred for the month. This query comes from a disposition
table, every animal that is sold, died or transfer ...
|
|
|
Conditional Formatting
Thu, 9 Oct 2008 08:12:06 -0700
I am simply trying to highlight any field value that is equal to "No". I can
not get this simple conditional formatting to work. Am I missing something
or can you not do this with yes/no fields?
--
Thanks,
Amy ...
|
Teamplate Report for different tables
Thu, 9 Oct 2008 04:44:01 -0700
Good morning,
I created a Database file in Access, then created a Table and a Report.
And I updated some Data and saving it in a new Table with a different name.
How can I update my Report from my first Table, without creating a new
Report for the second Table? I have MS Office 2007 with Windows Vista.
Thank ...
|
Good morning,
Thu, 9 Oct 2008 04:36:00 -0700
--
Roger ...
|
|
|