IIf works in query but not in report
Mon, 7 Jun 2010 15:30:37 -0700
Does the IIf function work differently in queries from the way it works in
reports?
For example, this works in a query:
lastName: IIf([Last]="Smith",Null,([Last]))
(I can hid the last name "Smith" in the lastName field.)
However, I cannot use the same IIf as a control source in a report. It
generat ...
|
Invalid Sheet Name on Export
Mon, 7 Jun 2010 11:36:59 -0700
When 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 word
Mon, 7 Jun 2010 10:48:31 -0700
I 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 off of a lookup table of names.
I want the above code to only give me the initials of any given name like: ...
|
Crosstab Graph Report not showing Parameters in text box
Mon, 7 Jun 2010 10:30:42 -0700
I 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 box in an expression.
Any suggestions? ...
|
Automatically name a report when exporting to PDF
Mon, 7 Jun 2010 09:17:19 -0700 (PDT)
Hello,
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 within
Access. I've used VBA to change the report caption to match a field on
my form called PROGRAM. However, ...
|
stLinkcriteria no longer working (since 2007 upgrade)
Mon, 07 Jun 2010 15:28:21 GMT
We 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 records.
If I open it with a button with this code, it shows ALL the records:
Dim stDocName As String
...
|
PageSetup properties keep changing
Mon, 7 Jun 2010 14:41:20 +0100
Hello 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 related to my having done the mdb
rebuild.
The page setup properties of various reports changes, periodic ...
|
|
|
easiest way to create gridlines in an Access 2003 report
Sun, 6 Jun 2010 18:58:45 -0700
Does anyone know an easy way to create gridlines in an Access 2003 report so
that it resembles a spreadsheet, other than manually drawing vertical and
horizontal lines? ...
|
Trying to calculate difference between two times in an access repo
Sun, 6 Jun 2010 11:26:46 -0700
I am trying to calculate the difference between two times in an access report
and don't know what the correct expression is.
My report has a column of "Start" and "End" that has the start time of the
project and the end time of the project. I need the difference between the 2
so I created an expression for ...
|
Access report date problem.
Sun, 6 Jun 2010 02:42:08 -0700
I have created a lot of graphs to show various information. The problem I'm
having is that I need the graphs to show the last 14 days of data. The
criteria I have used is >Now()-15. This seems to work fine until it comes to
the end of the month and then it will not cross over into the next month
untill it ha ...
|
