Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
group : microsoft.public.access.reports      view archive
page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>



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 ...


page nr.: page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us