Recent content by FrankD

I have some ASP code reading a few fields from a database, and for some reason, this error occurs. However, if I change the data type to something, i.e. I change it from text to varchar, it will execute with no problem. But I need the text data type. Can someone explain why this happens, and...

Does anybody know what controls are used to give a form the MS Outlook Express look and feel? By that, I mean the DB Grids in their resizable frames, and etc. <br> <br> Thanks!

Calahans,<br> Thanks for the above info. You were dead on assuming the tables were different. As for the above code, I have tried it, but the new table comes up with nothing in it. Here is what the generated SQL that VB executes successfully looks like:<br> <br> SQL = &quot;INSERT INTO...

Actually, I don't need to type anything in. The database already has stuff in it, I just need to (once I'm done using it) to move it over to a different table. Table 1 is &quot;Pending&quot; and table 2 is &quot;Processed&quot;. Processed just happens to have a few more fields. It's kind of...

I have a database with three tables. All three tables are not identical, however they all have the same fields that I'm trying to transfer. For example (short example), let <br> <br> Table 1: <br> FName<br> LName<br> MInit<br> <br> Table 2:<br> FName<br> LName<br> MInit<br> Address<br>...

Alt225 -<br> I'm assuming this is starting at 0? Like, if ElementsInArray = 2, it means that there are 3 entries? If so then it works great, and thanks for the help! :)<br> <br> Frank

Is there a simple way to find the size of an array? I am trying to write code to remove an item from it, and need to check my code to see if I am doing it right. Any help is appreciated, thanks.<br> <br> Frank

Please help. I am trying to connect to an access database, and list the table in the flexgrid. Actually that part works fine. <br> <br> The problem is, in the Access database, the column "Shipped" is supposed to be a checkbox, and when the flexgrid displays it, it only shows True/False. Is...