Search results

  1. G

    String Maxing out!

    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!
  2. G

    Silly question...

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

    Password in SQL

    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!
  4. G

    SQL Help!

    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?
  5. G

    list box index values

    My list box is populated by a query, and sometimes there can be more than 200 values! I get an error message saying that the value list is too long. Also, I need to be able to multi-select as some point.
  6. G

    query source database

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

    Probably a dumb question

    I'm using already using SQL to extract the data to the recordset, but once it's there, I want to put it into a template table that I've already created- the problem is that my connection to the recordset is to db2, and I want to put the data in a table in db1.
  8. G

    Probably a dumb question

    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?
  9. G

    list box index values

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

    List Box max?

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