Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JoeMiller

    Report running at wrong time

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

    SSRS 2008: Cascading Parameters in a Data Driven Subscription

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

    Record code

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

    Record code

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

    Record code

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

    Record code

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

    HP-5si Issue

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

    uncontrolled rounding and decimal places

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

    Suspicious user account

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

    Postcode woes

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

    Postcode woes

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

    Report Data Number Expression/Function

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

    report section height

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

    Access 97 - Font sizes changing randomly - cut off words ??

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

    I have a HP Laserjet 5 with a serious printing problem

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

    I have a HP Laserjet 5 with a serious printing problem

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

    A97 - Dot leaders between fields in a report

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

    Modifying Report Grouping/Sorting in VBA

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

    hp4050 and win xp problems

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

    Acquire Norton Ghost for NetWare 2.0

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

Part and Inventory Search

Back
Top