Recent content by JoeMiller

Did you verify that the clock on your report server is set correctly? Joe Joe Miller joe.miller@flotech.net

I’ve made a report that has two parameters “TeamID” and “TechID”. When you select a value(s) for Team ID it then limits the TechID parameter to just the members of the selected Team and defaults to selecting all TechID’s. This works perfectly via the Report Manager interface. What I’m trying...

I did it in the query feeding the report originally. But after reading your post, I tested it in the control in the report and it worked both places. If it still doesn't work, what version of Access are you using? Joe Miller joe.miller@flotech.net

This does work, I've used it many times and tested it prior to posting. Are you sure you set the CanGrow property of the control displaying your memo to "Yes"? Joe Miller joe.miller@flotech.net

Replace my message of "Memo Exists" with the fieldname of the memo you want to show. =IIf(Len(MyField)>0,MyField,"Memo doesn't exist") Joe Miller joe.miller@flotech.net

You could count the length of the string: =IIf(Len(MyField)>0,"Memo exists", "Memo doesn't exist) HTH Joe Miller joe.miller@flotech.net

Sounds like someone changed the destination output for the printer on the server's printer queue. Go to the server storing the queue, and check it in the properties of the printer in Start-->Settings-->Printers. Joe Miller joe.miller@flotech.net

This is a function I use all the time to round things to the nearest decimal place that I need. It rounds by a factor of 10. Place the code below in a module: 'Function to round a number to a factor (1,10,100,1000,etc..) Function RoundCC(x, Factor) RoundCC = Int(x * Factor + 0.5) / Factor...

It's also possible that this is a network user name from a network that SQL Server can't connect to. Was this server part of a domain and then disjoined? What you could be seeing is the SID for the user, which are normally numbers preceded by the letter "S", eg. S-12330-12-1-1-123123 HTH Joe...

So if you only want to split when there are six characters, surround my statement with an if/then that checks the Len() of your control, ie: If Len(MyPostCodeControl) = 6 Then MyPostCodeControl = Left(MyPostCodeControl,3) & " " & Mid(MyPostCodeControl,4,10) End If Joe Miller...

I don't know what the code your using is but it would seem to me that if you did something like this it would work: MyPostCodeControl = Left(MyPostCodeControl,3) & " " & Mid(MyPostCodeControl,4,10) Hope that helps! Joe Miller joe.miller@flotech.net

Set up a text box and put this in as the control source: =1 Then set the "Running Sum" in the text box properties to Over Group or Over All, whichever is applicable. HTH Joe Miller joe.miller@flotech.net

Can't do it... you can however add subreports (if applicable) each having 56cm in and of themselves to get more space... Joe Miller joe.miller@flotech.net

I've seen printer drivers do this. I'm willing to bet you upgraded a printer driver to a new version which changes the pagination and cuts off your fields... Joe Miller joe.miller@flotech.net

While pulling the JetDirect card before doing the cold reset does indeed keep the settings intact on newer models. The JetDirect card may be the problem in this case and it would be better to start off from scratch and reconfigure it as well as the printer. That is why I didn't mention it in...