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!

  • Congratulations TouchToneTommy 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: *

  • Users: heprox
  • Content: Threads
  • Order by date
  1. heprox

    Toolbar Button Problem

    I have a toolbar on an application that I use to refresh a flexgrid with different recordsets. Whenever I choose a different button on the toolbar its suppossed to change the columns and records in the flexgrid, however it always just stays the same, what am I missing? Private Sub...
  2. heprox

    Recordset Syntax Error

    I have this application that uses ODBC to retrieve a recordset from an Oracle database. Whenever I fire the Enter command I get an error with: txtSOH.Text = rsmain_4("sum(avail_qty)") ...if I'm using a sum statement via SQL, what is the correct syntax for referencing that part of the...
  3. heprox

    Message box caption

    Stupid question, but I'm drawing a blank, how do you change a message box's caption? If txtDSN.Text = "" Then MsgBox "DSN name cannot be Empty", vbInformation txtDSN.SetFocus Exit Sub End If
  4. heprox

    Progress Bar During Recordset Query

    I have a simple application that queries an Oracle datasource using ODBC and ADODB. The table that I'm hitting is immense and can at times take 10-15 minutes to respond to simple queries. I would like to have a simple graphical progress bar in my code to show the status of the query as it...
  5. heprox

    How have a form inside a form

    I have what is probably a simple question, I have an application that I would like to use as part of a larger application, kind of like a modular piece. I realize that I'll have to re-tool the current application some, but what I really want is to build a larger form that will allow me to...
  6. heprox

    Condition to handle a NULL value in a recordset

    I have this simple application that checks a pair of tables in a Sybase database for price, SKU, and UPC. There are occassions when an SKU has a price and SKU record in one table (plu) but there is no corresponding UPC record (in plu_cross_ref). I have the application still returning the...
  7. heprox

    Syntax on an outer join

    I'm new to Sybase syntax and I need to have a simple statement query a recordset for me. I have two tables: Table1: plunum price Table2: plunum upc ...normally in Oracle I would do somthing like: SELECT table1.plunum, table2.xrefnum, table1.price FROM tabel1, table2 WHERE...
  8. heprox

    Changing the color of a rowc in a FlexGrid, based on a recordset

    I have an application that users enter in some data and query a data source. The recordsets returned are populated into a FlexGrid and later written to a file. At times there are recordsets that return NULL values for some of the fields. Whenever a recordset has a field with a NULL value I...
  9. heprox

    Error in populating a FlexGrid

    I have a simple application that is retrieving a recordset from a database and populating a flexgrid with the record set accordingly. The idea is that the user will enter an field "txtItemCode" and hit ENTER, then the record will appear at the bottom of the form in the FlexGrid. Then the focus...
  10. heprox

    Defaulting to Taday's Date in a Mask Edit Box

    I have a form in a simple application that uses a mask edit box to allow the user to enter a date. Whenever the user first loads the form I want the mask edit box to default to the current date so something like: Private Sub Form_Load() mskEffectiveDate.Text = "sysdate" Call PopulateStore End...
  11. heprox

    FTP Core Dump

    We are running AIX 5.2L Maintenance level 5 on an IBM p650. We are getting a lot of core dumps that all relate to the FTPD daemon. Has anyone seen this error before? Description SOFTWARE PROGRAM ABNORMALLY TERMINATED Probable Causes SOFTWARE PROGRAM User Causes USER GENERATED SIGNAL...
  12. heprox

    Combo Box Validation

    I have an application that connects to a DSN and generates a report based on a combobox for "Item Number" and a set of list controls for date range. The combobox is populated by a recordset: Private Sub PopulateItemNumbers() On Error GoTo errhandler Set rs = New ADODB.Recordset rs.Open...
  13. heprox

    Converting ASP to an HTA

    I have two pages (both pages written in ASP/javascript). There is a search page (search.asp) and a results page (results.asp). These two pages are loaded in a frameset (frame.htm). Whenever I rename "frame.htm" to "frame.hta" everything fails to work correctly. Do ASP pages work inside of an...
  14. heprox

    Server Specifications

    We are about to start migrating our production e-mail services in-house. We are currently spec'ing the new server. I really want to use something like an IBM x346 for this. The company has roughly 500 accounts but the server will eventually have twice that. In addition we are going to be...
  15. heprox

    Server S[ecifications

    My company is about to finally migrate to a Cisco based VOIP solution. Our Cisco partner informed us that they can provide the Cisco servers or that we can use our own. We are primarily an IBM/3Com shop, so we are replacing some of our switched for Catalyst PoE switched, but I want to use IBM...
  16. heprox

    Question from a new Exchange Admin

    My company is currently looking at bringing "in house" our corporate e-mail services. We have outgrown the ability to have some manage the service for us. We are presently looking at Windows 2003 Exchange server for our needs. With 500 e-mail accounts, and growing, what are your opinions of...
  17. heprox

    Cannot access SMIT from terminal

    We have a m80 server with the basic non-graphics terminal hooked up to it (ASCII only). One of my admins set the root user to not be able to log in remotely. Unfortunately, there are no other users on that server (its for testing) so now we have to go and login at the server. The problem is...
  18. heprox

    Remote users

    We use SMS to manage software/hardware inventory in our organization. Are there any extensions or modules that allow SMS to inventory remote users via the web? We have several dozen clients that work out of their homes and do not have SMS site servers on their network, these users connect...
  19. heprox

    Question regarding .NET abilities

    I'm in the process of designing the requirements for some business intelligence software that my organization wants to begin developing in-house. Part of the design process is obviously the technology behind the appllication. My programming experience lies more in VB and Perl so I'm new to...
  20. heprox

    Question About ActiveX Controls

    I'm in the process of designing the requirements for some business intelligence software that my organization wants to begin developing in-house. Part of the design process is obviously the technology behind the appllication. My programming experience lies more in VB and Perl so I'm new to...

Part and Inventory Search

Back
Top