Recent content by azstyx

COOL!!!! Thanks to both of you!!!!! :) Styx

Hello Folks! I am using 2 separate SQL queries to accomplish a task and I was wondering I can combine these 2 queries into one more efficient query? My database table may have more than one entry if queried by Telephone number. I only want to extract the record information only if there is ONE...

Hello Perl Mongers! Environment: libwww-perl: 5.805 Crypt::SSLeay -- 0.51 OS: Solaris 8 Perl: 5.8.4 Issue Summary: Issue with SSL POST operation. I have a script that randomly fails against devices using HTTPS example: I run the script 3 times aganst the same device and all works ok. Then the...

Actually my default value is: =Right(Year(Now()),2) & IIf(Month(Now())<10,"0" & Month(Now()),Month(Now())) & "-" I just simplified it for purposes of demostrating the main issue of the default value clearing on me. I'll play around using two text boxes. thx, styx

hmm, tried that but got no value in the ordnum field on a new rec. What I need is: click on new rec button Ordnum field should display [0603- ] then the user will enter a 3 digit seq number (such as 123) after the "-" giving the result: [0603-123]...that is the key value that should be stored...

Hello, MS Access 2000 sp3 When adding a new record to an order file, I have a default value on the ordnum field. It also has a format = "9999\-999". The default value is "0603-". When the user clicks on the new rec nav button, the form has the correct default in the ordnum field "0603-"...

Word 2000 - SP3 W2K O/S My doc was 733KB and contains some inserts of small gif photos. All of a sudden I opened the doc to make some text changes and I start getting the message "There is not enough memory or disk space to display or print the picture". I made a small text change and saved the...

PIX Console Port: To access the PIX console port with a dumb terminal, you need a DB9 null modem cable, CISCO part# LDW0398-72-0876-01. DB-9/F to RJ45 works too as long as its Null Modem pinned. Configure the dumb terminal for 9600/8/N/1 (flow control to hardware). Use can also use the serial...

can you post your config? #sh conf #sh run

cool, let me check some other knowledge bases on this issue and see whta i can find for you. K

You will not be able to see any Novell or IPX resources. Here are my engineering notes: Q: Can I map drives to Novell File Servers? A: No. The VPN system is based upon the TCP/IP protocol and not the IPX/SPX protocol used by Novell. Therefore, the VPN system cannot interact with Novell systems...

Hi Bob, The inventory-totals created a multi-record result. I have decided to re-write all the original queries and build a table with one record, then I will have the summary queries update the corresponding summary field in the table with one record. K

Resolved: PIX was globally Nating to old pix outside address. config chnges: global (outside) 1 interface nat (inside) 1 0.0.0.0 0.0.0.0

Yes, the GROUP BY Products.obsolete HAVING (((Products.obsolete)=False)); produces one record with the two summary totals. It just so happens in this database , since it is a new startup company they have no PO records yet, just inventory records so the form query failed. What i tried to do was...

Hi scriverb, Unfortunately, I dont have a common field between the two qeries, otherwise I would create an outer join. In reality here are the 3 queries....i didnt post them before because I was trying to sikmply the problem and use an example from a &quot;ply&quot; database and duplicate the...