IIf works in query but not in report01206 (6/7/2010 10:30:37 PM) UtfDoes the IIf function work differently in queries from the way it works in
For example, this works in a query:
(I can hid the last name "Smith" i...
Group totals in dynamic report31250 (4/26/2010 8:05:01 PM) UtfI have a report that dynamically gets control source for five columns based
on user input through a form. The report successfully shows text boxes
(currency format) with approporiate fields (control source)...
Crosstab Graph Report not showing Parameters in text box31244 (6/7/2010 5:30:42 PM) UtfI have a report using a crosstab query in a graph. The query is asking for
parameters. When I try to pass the parameters to a text box on the graph
they will not pass through. I am building it in text bo...
Invalid Sheet Name on Export11402 (6/7/2010 6:36:59 PM) UtfWhen I export a report from Access to Excel via DoCmd.OutputTo I get an error
from Excel saying Invalid Sheet Name. What can be causing this and how I do
to keep this error from happening?
First Letter of each word11497 (6/7/2010 5:48:31 PM) UtfI have the following in a text box field:
=IIf([Comp Entered By] Is Null,"",Left([Comp Entered By],1) & Mid([Comp
Entered By],InStr(1,[Comp Entered By],",")+2,1))
the field "Comp Entered By" is based of...
Automatically name a report when exporting to PDF12188 (6/7/2010 4:17:19 PM) shm135Hello,
I have a form with a command button that opens my report in print
preview mode in Access 2007. When I click the Export to PDF/XPS
button, the default file name is the name of the actual report withi...
stLinkcriteria no longer working (since 2007 upgrade)11115 (6/7/2010 3:28:21 PM) arathraWe have just upgraded to 2007 and are having a few minor problems. I've seen
similar threads online but can't find the solution exactly for us.
If I open a report then it shows the report with ALL the recor...
PageSetup properties keep changing21034 (6/7/2010 1:39:33 PM) PayeDocHello All
I recently had some mdb corruption problems, that I THINK I've solved - by
creating a new mdb and importing all objects. A new problem has now started
that is either coincidental or is somehow re...
Report made of a query cross table5874 (6/2/2010 11:47:01 AM) UtfHi everyone
It must be very simple for you guys but i can't find it: How to make a
report, made of a query cross table, but only show records that the total of
all months are diferent than zero (0). Negati...
Resource For Help With Access13927 (5/30/2010 7:03:59 PM) SteveI provide help with Access applications. I specialize in designing the
tables for a new database and fixing problems and adding new functionality
in existing databases. My fee could be as low as ten dollars...