Recent content by ranshe

I am working in VB6 with and Access.mdb database. I get a syntax error on the Alter Table query statement below. I have tried to change it but I cannot seem to beat the problem. Using the .Open statement I have done selects/insert/drops/deletes and updates so that does not seem to be the...

I need to change an MSAccess table name using a query statment in VB6. I cannot find the command to do it. Any ideas?

How would one display the contents of a table on a form? After the user provides the search criteria and a name for table about to be created, he will click the command key and the table will be created with all the data that matched the given criteria. Then I want to show the user the data...

Well, Don't ask me how, I guess i was up programming to late last night, but the Text1 had an Index set on it and was seeing it as Text1(2) and not as Text1. I should of noticed that but suffered from brain drain. When i tried "gmmastros" sugestion and put MsgBox TypeName(Text1) in the Load Form...

I have a text field on a form. It is for entry of a number which I use in a calculation. When I use it in an expression like Some_integer - Text1 it gives the message "Argument not optional and highlights Text1. When I try the command data_numeric=Val(text1.text) it gives me an error saying...

At the risk of sounding dumb: I need to know how to paint a numeric field on a form or convert a text field that receives a numeric value into a number so I can us it in a math calculation. Thanks!

I have tried the above and it works well for a DataList and the DataCombo but not for the DBCombo . With the DBCombo I get the message when I try to fill out the RowSource: "No compatible data source found for this control. Please add an intrinsic Data Control or a Remote Data Control to the...

I am trying to use a DBCombo box. It reads a Access.mdb table with only one field. It works fine when I bind it to a Data ocx object on the form. It works fine, that is, as long as I set the Properties of the Data ocx object to: DatabaseName = Access.mdb full path (Ex. C:\etc.)...

The database would be ACCESS.

How can you, in VB, find the Table names that are located in a given database? For example, say database TEST_DB contains the following tables: TableA, TableB, and TableC. What command would return "TableA TableB TableC"? I would like to try and implement this through VB to check if a table...

Thanks! Super help! Worked perfectly....GREAT!!!!! Thanks again!

I have and ODBC mdb with two tables and each table has matching data in key fields: 1. CustomerMaster, its key: CMOurAcctID 2. CustomerProductCrossRef, its key: AccountID Table 1 has only one record for each key value while table 2 may have as many as 40+ records for the same value (many to...

To the best of my knowledge, my co-worker and I have our PC's and VB environments set up the same. The following Sub runs fine on my PC but when I send it to my co-worker and he loads it onto his PC in VB it will not run but gets the error message: " Syntax error in the FROM clause" and the...

NOTE: The code below works just fine! Private Sub cmdCreate_Click() Dim DBo As New ADODB.Connection Dim DBi As New ADODB.Connection Dim rsRead As New ADODB.Recordset Dim rsWrite As New ADODB.Recordset Dim InsertFields As String Dim SelectCriteria As String...

I have two Access databases (mdb1 & mdb2) that are accessed via ODBC. Both mdb's are in different directories and nether one is in the VB default directory. I need to know the most efficient way to code for opening each database and reading every row from a table in the first database...