Search results for query: *

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

One thing you can try is to cold reset the printer to clear all settings the printer has back to HP's default. WARNING: This will erase any settings in the printer, including network card settings so you will need to have your network admin reconfigure these after the cold reset. Before...

If you did this with a monospaced font you could very easily accomplish this using simple math and a known field length. IE: I have a table contents report with a variable length chapter name and then the page number at the end. I separate the chapter name from the page number with period's...

Make sure you are in a code window when you type in "CreateGroup" otherwise help may not show it. If it still doesn't show it then you may not have installed the VBA help when you installed Office. You can check by putting your Office cd in the drive and checking the installed...

WinXP will not be listed there is no need for it. Because it is the same as Win NT/2K it falls under that category. When the XP client connects to the server it first sees if the driver on the server is adequate for it, if it is not then the OS checks to see if it has its own built in driver...

Does anyone know where I might acquire a copy of "Norton Ghost for Netware 2.0"? I have a VERY old Netware 3.2 server which I would like to migrate to new hardware by cloning the disk drive to a bigger unit. I was hoping to do it with Norton Ghost but it is a product that is no...