Converting from MS-Access 2003 to 2007
Sat, 5 Jul 2008 17:23:19 -0500
This is in regards to customizing the ribbon.
If I create a "USysRibbons" file and set "StartFromScratch" = true, how do I
display a custom toolbar for a report on the "Add-Ins" tab?
...
|
Vertically Aligning Fields in a Sub-Report
Sat, 5 Jul 2008 07:08:01 -0700
Iâ??m putting together a report for a service database where each service
ticket can have multiple call reports, and each call report can have multiple
engineers associated with the report. While all the dataâ??s getting on to the
form, the vertical alignment shifts if thereâ??s more then one service engineer ...
|
Order Details in horizontal list instead of vertical list
Sat, 05 Jul 2008 13:56:07 GMT
Is it possible to have the order details to be listed horizontally which is
seperated by a comma after each value instead of the default vertical listed.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200807/1
...
|
Graph won't display Zeroes
Sat, 5 Jul 2008 05:51:27 -0700 (PDT)
My report has a bar-graph of items per month for the past year.
In months where zero items were produced, I want to show zero
but the chart skips the zero months.
How can I make every month show? All 12 months even where production
was zero. ...
|
Decimal Problem
Fri, 4 Jul 2008 23:04:01 -0700
Hi
My report is based on the following expression in my query in one of the
text box:
Balance: Format$(nz(([sumofpoamt]-[paidnet]),[sumofpoamt]),"$0.00")
This works fine but when I added another text box to sum the total, Access
ignore the decimal number. For example:
8.00
9.00
6.25
Access displa ...
|
Automated way of adding suffix on dates? i.e. th, st,rd
Fri, 04 Jul 2008 15:43:29 GMT
Hi!
Is there a way that Access will automatically add the suffix to a number for
say 4th July, so the "th" in this case, or 3rd November - "rd"?
Or should I add a table to look it up?
Thanks!
Russell.
--
Message posted via http://www.accessmonster.com
...
|
mailto: in access report
Fri, 4 Jul 2008 08:16:37 -0700 (PDT)
I have a Access 2000 report that I export to our intranet site, via a
macro. The output format is MS-DOS text, and the output file name is
staff.html. The report works fine but I want to add a field
containing e-mail address's to the report. I have created a text box
on the report containing the e-mail field ...
|
|
|
printing report preferrences
Fri, 4 Jul 2008 10:02:40 -0400
OK, I have several reports that I print out on 8.5 x 14 landscape and then I
have several reports I need to print on 8.5 x 11 portrait. How do I code
that.
I can only find one way of doing it and that's in Page Set up which means
the user has to make that adjustment. I want to make that adjustment in the
...
|
you must define a sort field or expression for group header or footer
in the report you tried preview or print
Fri, 4 Jul 2008 06:52:23 -0700 (PDT)
I got the following message while I preview the report.
"you must define a sort field or expression for group header or footer
in the report you tried preview or print"
This is a subreport of the main report.
Any informaiton is great appreciated, ...
|
Why does Last function return the second to last instead of the la
Fri, 4 Jul 2008 05:50:01 -0700
I have created 2 reports, in each of which I use the Last function to return
an invoice number from the last record for different clients, but instead of
displaying the last record, I see the second to last record. Why could that
be? I am not a programmer. ...
|
