Search results for query: *

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?

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

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

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

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

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

No, that is in there.

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

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]))")

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

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

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.