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 strongm 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: tms05
  • Order by date
  1. tms05

    AIX UNIX VS IBM xSeries Linux System Servers

    We are considering moving from AIX UNIX to XSeries Linux. Does anyone have any insight as to the pros and cons. Will this allow for VBA coding and FTP automation? We were told that the xseries will run faster and speed up our processing times. We use transoft as the driver to bridge into...
  2. tms05

    Run SQL Statement in AIX

    cspilman-- How would I process the lines you provided above? When I go into AIX I CD to the folder then type in usqli. I then get prompted for Database then user then password. It then is expecting my statement. SOrry, I am not at all familiar with using usqli.
  3. tms05

    Run SQL Statement in AIX

    Yes we are using transoft. Thanks Chuck, but I can get my result but unsure how to save or create a file from the result.
  4. tms05

    Run SQL Statement in AIX

    Sorry sbix. I really have no idea. I know we are using AIX and our FTP client is Reflections. We also have Usql utilities. How would I find out what kind of database we have and are using. Our driver is transoft. I was assuming we dont have a database and that the transoft driver is just...
  5. tms05

    Run SQL Statement in AIX

    I was wondering if someone could help me. I am farely new to Unix and AIX. I was wondering how I can run a SQL statement in AIX. I have no clue on the syntax to connect, run the statement, and save as text. I do have and can use USQL on my desktop but I need it to run on AIX and send the...
  6. tms05

    XCEL formual for addition

    Thanks for all your help, I appreciate it. Have a good weekend.
  7. tms05

    XCEL formual for addition

    Thanks, appreciate it. I tried that, but formula was already unchecked. Still couldn't get it to work, so guess what? The field was checked as locked. Unlocked and it worked. Thanks. Can you also tell me what the little green spec in the left top corner of each cell means? Thanks.
  8. tms05

    XCEL formual for addition

    That is what I did, but in the field it doesn't put the total, it puts the formula. Do you know why. I even went to format and put General, text, number, custom, and it still puts the formula instead of the total. Thanks for answering me.
  9. tms05

    XCEL formual for addition

    In Xcel, I am trying to add up numbers in 10 rows in column A and then the numbers in two rows in column B but I can't get a formula for it. DO you know of a formula? Thanks. A B 20 4 5 115 41 10 6 7 4 8 92 311
  10. tms05

    Password

    No, I will try it. Thanks. My problem is it is the whole program. Then minute I click on Access it comes up and asks for my password. This is before I ever get to the database.
  11. tms05

    Password

    I don't know what I did, but have used Access for years no problem; I had never set any security on it. THe other day I wanted to check on security to see what it was used for. Now, I can't even go into Access. The first screen says Owner. Then asks for a password. I've really screwed things...
  12. tms05

    Delete Multiple Objects

    How would you do reports or forms?
  13. tms05

    SQL Select Statement Form button On Click

    Sorry, but I have never created a combo box on a form before. How would i go about setting that up??
  14. tms05

    SQL Select Statement Form button On Click

    I have a button on the form that I would like to run a simple sql select statement and I can't seem to get mine to work. I need to run one query with different criterias so I thought I would use SQL opposed to have 10 different variances of the same query. The query I have as the base query is...
  15. tms05

    Previous REcord

    I have tried searching through the forum but can't seem to find any solutions for the following. I am sure one exists but didnt have any more spare time sifting through. How can I pull the previous record depending on date effective. For example. I have a rate history table. I need to pull...
  16. tms05

    Explorer error

    Should be able to access this way Dending on the computer. If you have the system recover disks, insert it in the drive. When the window pops up hit cancel to cancel the recovery process. This will throw you into the Dos Window. I myself am thinking of trashing ME.
  17. tms05

    Count IDS But include All Data

    It can't sum department because it is a text field. It still is only putting a 1 across each line instead of doing a running sum.
  18. tms05

    Count IDS But include All Data

    I have a query that lists each person then each persons department. Some can be in two or three departments. I need it to do a running count in the query. So for example, Name Date Deparment Department Cnt John Smith 01/01/03 #65 1 Susan Howl 01/15/99 #36...
  19. tms05

    Spell Check Form Field

    I have a Microsoft form that allows a user to enter in data in the form fields. After entry I then unprotect the document and run spell check. The spell check is not checking the data within the form fields. Is it possible to spell check form fields in Microsoft Word. I am using Word 97 but...
  20. tms05

    Delete Multiple Objects

    That was perfect. It allows me to use the Like expression, therefore I was able to do what I needed. I have looked for hours (probably over 50 hrs) for a solution to this problem. THANKS!!!!

Part and Inventory Search

Back
Top