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

    Bind a runtime variable in Select statement?

    Thanks for the help. I will try the options you suggested.
  2. jackiev

    Bind a runtime variable in Select statement?

    I suspect this has a simple solution. Please help this SQL code newbie. This select statement : Select g.NOTIF_NAME, h.AW_NOTIF_EMAIL, g.NOTIF_ACTIVITY_DATE from NOTIF g, NOTIF_DETAIL h where g.aw_notif_seq = h.aw_notif_seq and h.AW_NOTIF_EMAIL like '&email' order by 1,2 gives me error...
  3. jackiev

    WebFocus SQL Report: Excel97 - ok, Excel2000- No query Info

    Using Webfocus Developers Studio (Managed reporting) to create a SQL RPEORT. Once report is created when output format is set to Excel 97, report displays ok, however, has a Report Header every 55 lines. When output format is set to Excel 2000, result is 'No query information to decode'. Other...
  4. jackiev

    conditonal field select

    Exactly what I needed. Thanks.. Just for cosmetic sake, is there a way to disply 0 instead of (null) for the missing months?
  5. jackiev

    conditonal field select

    How do I format a select statment that will retrieve fields from multiple records based on coditi0ns: example: Table contains: ID , month , days off count 123 , jan , 15 123 , feb , 8 123 , mar , 3 456 , jan , 2 456 , mar , 5 I want my select result to show: 123, 15 , 8 , 3 456, 2 , (null)...
  6. jackiev

    Who is running the report - USERNAME

    I would like to inbed some minor security in a report to display different fields based on the name of the user who is running the report. How do I extract the USERNAME? example: if USERNAME is 'staff' then display names & phone numbers or if USERNAME is 'boss' then display names, phone & dollars.
  7. jackiev

    Mystery References(what to set??)

    Those hints both helped. Thanks.
  8. jackiev

    Mystery References(what to set??)

    I am a relative newbie to VB programming. I can create simple programs, no problem. Now I need to be able to make changes to existing programs--I have the source code, saved to a network. But when I open the code modules, the correct references & components are not set, so the component cannot...
  9. jackiev

    Microsoft Games, Solitare, Freecell, Minesweeper.

    Yes, this does "uninstall" the games. When you look at start>programs>accessories>games is empty. BUT if you search for file freecell*.* ( or spider or winmine or sol or mshearts or pinball) on your C; drive you will most likely find other copies. I found all of the games again in I386 (a...
  10. jackiev

    Microsoft Games, Solitare, Freecell, Minesweeper.

    Ok--I must be doing something WRONG!! I have gone to the sysoc.inf, removed the HIDE.. gone to Control Panel, Remove Windows Components, removed the games. (Windows KB 314614)(This took the games out of Start>programs>accessories>Games (now shows empty). rebooted several times. The games...
  11. jackiev

    HP ScanJet 4C (pc/isa) connect with USB????

    ok, thanks. I have been looking at the cost of cards & scanners. I am now polling the users to see if this scanner is really used as much as it used to be. Thanks for the info.
  12. jackiev

    HP ScanJet 4C (pc/isa) connect with USB????

    Have an OLD system (166mhz,96ram, NT) set up with an HP Scanjet 4c scanner connect using a SCSI card. Would like to replace the old system with a new W2K 1.8mhz 512ram, but do not have any ISA slots for the SCSI card. I am in water way over my head here.... Have found a source for a cable with...
  13. jackiev

    hibernate, sleep or shutdown?

    Replacing a Dell Optiplex Gs 5166M with a Dell Precision 360 Minitower (Windows NT4.0 sp6). One very useful funtionality of the 166 is the shutdown to a restart window. "It is now safe to power off your computer, or click restart button". Since the CPU was located behind a closed cabinet, the...
  14. jackiev

    Query to select distinct field(but display entire record)

    That was exactly what I needed. Thanks!!
  15. jackiev

    Query to select distinct field(but display entire record)

    This is what I have: TABLE: INFO Name Val1 Val2 Val3 Jim 1 2 3 Jim 4 7 9 Jim 3 7 2 Kate 1 2 8 Sally 3 5 4 Ann 3 2 1 I want to select the FIRST record for each name, & get all the fields of the record, sort by name. My...
  16. jackiev

    Registry Value DontDisplayLastUserName missing

    I have a Win NT sp6 machine connecting to a Novell Network with Novell Client 4.90. Just upgraded to Client 4.90. In the prior client, the Novell logon user name defaulted to the last user name--displayed the last logon name when the login screen appeared. This was good--our autologon just...
  17. jackiev

    Could not find External Window Handler

    We have a VB6 program that uses the Acrobat Control for ActiveX to view PDF documents. The workstation/PC that this program runs on is showing signs of impending failure, so we are building a replacement workstation. The VB6 program & Adobe Acrobat Reader 4.0 have been loaded to a new...
  18. jackiev

    Can't SAVE or SAVE AS

    Have a Corel Photo Paint 9 image saved as an OLE object in an Access Database table. (don't ask! I didn't do it! I just have to FIX it). Need to find a way to save the image to a folder outside of ACCESS. When the image is opened, the SAVE AS option is not grayed out, but does not do anything...
  19. jackiev

    Cannot Run Arcserve Manager for Netware on W2k PC

    Again, same problem here. Does anyone have any ideas where to look?
  20. jackiev

    user.000 profile created, defaults lost

    Yes..running Zenworks For Desktops vers 3.0 Sorry, don't know what DLU is .

Part and Inventory Search

Back
Top