Recent content by jackiev

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

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

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

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

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

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.

Those hints both helped. Thanks.

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

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

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

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.

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

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

That was exactly what I needed. Thanks!!

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