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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. cruzer330

    Lotus 123

    Is there a way that I can write a VBA module in Excel to access a Lotus123 worksheet. How should I access the lotus123 object?
  2. cruzer330

    Renumbering db

    What I do is delete the primary field, and then add the primary field again as Autonumber. This should reset the numbers.
  3. cruzer330

    C++ with Visual Basic

    I want to write iterative mathematical calculations for a Visual Basic program. I have done this in VB but the calculations take a long time. I was wondering if C++ would provide a quick solution. I have extensive knowledge of VB but very little with C++. I just downloaded the Borland free...
  4. cruzer330

    Iteration through array

    I wonder if anyone has a faster solution to this. I have an array about 100 items. I want to do a calculation to each item and then I want to sum the items starting at the bottom. Is there a faster way to do this? redim q (1 to 100) redim x (1 to 100) redim y (1 to 101) a=1 b=100 for i =...
  5. cruzer330

    FTP and POP

    I just learned some FTP commands and used them in DOS. Is there a way I can automate these commands in Visual Basic. For example, transfering a file and checking to make sure that it doesn't exist already on the local computer, or other things such as that. If anybody has example code or...
  6. cruzer330

    FTP

    I just learned some FTP commands and used them in DOS. Is there a way I can automate these commands in Visual Basic. For example, transfering a file and checking to make sure that it doesn't exist already on the local computer, or other things such as that. If anybody has example code or...
  7. cruzer330

    Error 3218

    No, that is in there.
  8. cruzer330

    Error 3218

    I have a table with about 2500 records in it. In VBA, I am reading in a recordset, performing calclations and add more information to each record. Following is the code. The problem is that about half way through, I get an error Run-time error '3218': Couldn't update set db = currentdb set...
  9. cruzer330

    Date Conversion

    See the problem is that I want to have null values. The following code gives me an error. db.Execute ("UPDATE tblAll SET tblAll.dob1 = nz(CDate([dob1m] & " / 1 / " & [dob1y]))")
  10. cruzer330

    Date Conversion

    I want to take two integer fields (month and year) in a table and make them into a date field int the table. If I can use SQL that would be great, my problem is that I can't assign NULL values to a field UPDATE tblAll SET tblAll.dob = IIf(IsNull([mm]),"",CDate([mm] & "/1/&quot...
  11. cruzer330

    TN3270, EHLLAPI Data Download

    I wonder if there is anyone that can help me with this one. I want to find a way to download data from a mainframe using a TN3270 connection. I would like to do this through my own interface instead of through the Walldata's RUMBA way. Is there a way in Visual Basic to do this? I there a way...
  12. cruzer330

    RUMBA TSO

    I am trying to access my mainframe from VB so that I can print data files in TSO without having to download them onto my personal computer. I am using VB6 and RUMBA 95/NT. Please give me some tips.

Part and Inventory Search

Back
Top