Recent content by Spellman

Go to project menu and components. Then select Microsoft Windows Common Controls and there is a Tab control in there. Mark The key to immortality is to make a big impression in this life!!

hey StlMacMan , couple of problems with this. First off you declare both your TxtCtrtStartDate and TxtCtrtEndDate as date types. I assume on the form you created you have text boxes of the same name. This in itself will throw up an error. Remove the Dim of these two variables at the start...

You should use two seperate connections one using Microsoft.Jet.OLEDB.4.0 for 2000 and one using Microsoft.Jet.OLEDB.3.5 for '97. Mark The key to immortality is to make a big impression in this life!!

Have a look at the XML dom object. It provides methods and functions for accessing XML documents and element nodes. Mark The key to immortality is to make a big impression in this life!!

If you mean can you run multiple SQL statements off of the one Connection then the answer is yes. No problems. Mark The key to immortality is to make a big impression in this life!!

What are the intervals for each Timer like. it sounds as if these Timers are always being executed and thus nothing else is getting the opportunity to get executed until all the timers are disabled. Mark The key to immortality is to make a big impression in this life!!

I might be inclined to use a grid and then mess around with the properties until it looks like 12 lines of a page. It would also reduce completely on having to parse the string in a textbox as each row would represent one line on the invoice details screen. Mark The key to immortality is to...

I'm a liyttle hazy on exactly what your after but you could try making a second ADODB recordset and use the .clone method of the original ADODB recordset. e.g. Set rs2 = rs1.clone Then you could manipulate rs2 as you see fit. Mark The key to immortality is to make a big impression in this...

Try using ad opendynamic instead of ad open static. If that doesn't work then what you can do is build the sql update statement and use Dbcn.execute sqlstatement to update it. Sorry I'm not at my machine at the moment so I can't be of more help. Mark The key to immortality is to make a big...

after your rs.open statement try putting in the line rs.edit. Hopefully this will sort it for you. Mark The key to immortality is to make a big impression in this life!!

Have a look at using the "tag" property to store the value and then use it to write to the Excel worksheet. Mark The key to immortality is to make a big impression in this life!!

If Data1 is your data bound control then try: "SELECT * from Information where Age >= " & textsearch.text I'm assuming age is a numeric field??? Mark The key to immortality is to make a big impression in this life!!

try at the start of the function declaring i as long and see if that helps any. Mark The key to immortality is to make a big impression in this life!!

try something like this: Dim startchar as long for i = 0 to 9 for j = 0 to 25 startchar = ASCII('A') debug.print text1 + str(i) + chr(startchar) startchar = startchar + 1 Next j Next i Mark The key to immortality is to make a big...

char x = mid(stringname, startposition, length) so to get the character at position eleven use mid(stringname, 11, 1) Mark The key to immortality is to make a big impression in this life!!