Search results for query: *

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

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.

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

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

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

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

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

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

Win2000 machine on Novell network. Normally the users can log on just fine, but once in a while... Windows does not recognize the user name and creates a new profile. Example: Joe logs on 1st time. Sets his preferences. Logs on & off at this workstation daily for weeks & his preferences...

Have a Dell Poweredge 4200 server on a Novell Network. The server is 5 years old & Dell will no longer offer any maintenance. Is there any other option out there?

Have a Dell Poweredge 4200 server on a Novell Network. The server is 5 years old & Dell will no longer offer any maintenance. Is there any other option out there?

Recently I have found that every time I copy a file to a floppy (3 1/2), a hidden file "EA DATA. SF" also appears on the floppy. What is this? Why is it happening? Should I be concerned?

Have a VB6 program that sums the values in the columns of an Access table. The values are double fixed numbers, the final sum needs to be converted to a string, ignoring the decimal point, so 37.95 becomes 3795 and 14.00 becomes 1400. Table contains: Week# Mon Tue Wed Thu Fri 1...

We have a VB5 program that has been running for a couple of years. Recently we have encountered an issue that I know how to fix, but i don't know the cause. The program pulls a recordset from an Access Database Table (Select * from Table where Print_Date is Null), then prints a form from each...

I know the LONG answer to this question... Is there a short answer that I am overlooking? Pulling a recordset from an Access database & displaying the fields to an array of textboxes using simple code: while not rs.eof textbox1(index) = rs.fields("fieldname1").value...

I'm looking for a control that will display SQL query results (from an Access database)in a grid-type format, & allow individual properties on cells. Example-grid displays: BooleanCheck FNAME LNAME M/F YEAR FEE Hired |_| Joe Smith M senior paid...

Help Please!! Can you see what is WRONG with this code?? dim arrSchedules() as string dim intx,inty as integer (also have databases & recordsets declared) 'fill Schedules array Set rsDailyLabor = dbPayroll.OpenRecordset("Select * from Schedules", dbOpenDynaset)...