Search results

I thought that strings could contain tons of characters, but I keep getting an error when it goes past 255 characters. Does anybody know how to fix this problem? Thanks!

Hi everyone, You know how when you type an object name and then the dot, the methods for that object will list? Well, it's not working for me anymore, and I don't know how to turn it back on. I guess I never thought about it, and now that it's gone, I miss it very much! Any help would be...

I would like to update a table with data in another database; the other database has a password protection. Can I put the password in my SQL statement so I can get the data? Here's my statement right now: INSERT INTO tblData SELECT * FROM tblData IN '" & strFileName & "'" Thanks!

Hi Everyone, I would like to write a SQL statement that does the following: In tblData, if there is an empty or null value in the Sample column, change it to "Empty". I'm afraid I am not very good with SQL statements, so any help would be greatly appreciated! Maybe an UPDATE statement?

is there any way to set the query source database with code? I have a query that I would like to use depending on the database I select.

I have to databases, db1 and db2. I am using db1 to create a connection and recordset to db2. So, all the data I want is in a recordset. How do I insert that data into a table that I have created in db1?

Is there any way to set my own index values for a particular list box?

Does anyone know how to change the maximum rows for a list box? I keep getting an error that says the setting for this property is too long.