Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ranshe

    Syntax error on ALTER TABLE query statement

    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...
  2. ranshe

    SQL statement to Change a .mdb Table Name?

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

    Display Table Row & Columns on a Form?

    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...
  4. ranshe

    Text conversion to numeric

    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...
  5. ranshe

    Text conversion to numeric

    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...
  6. ranshe

    Sting /text conversion

    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!
  7. ranshe

    DBCombo Box Trouble

    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...
  8. ranshe

    DBCombo Box Trouble

    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.)...
  9. ranshe

    List the table names in a database

    The database would be ACCESS.
  10. ranshe

    List the table names in a database

    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...
  11. ranshe

    SQL Query statement in VB

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

    SQL Query statement in VB

    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...
  13. ranshe

    a

    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...
  14. ranshe

    Query SELECT and INSERT using two ODBC .mdb's

    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...
  15. ranshe

    Reading and writing between two ODBC .mdb

    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...
  16. ranshe

    How to do nested quotes: " "Some string" " ?

    How do you use nested quotation marks in a string? I need to put double quotes in to a string and cannot find out how to do it. Ex: x = " "Some string" " I have tried several ways but cannot find how to do it and cannot find it in a book, etc. Help appreciated! Thanks!
  17. ranshe

    VB SQL INSERT Statement (Help!)

    I am trying to open two databases and read from a table in one and insert it's data into a table in the other. The database I am inserting into is in the current database (CurrentDB) and the databaase I am reading from (RemoteDB) is in another directory. If I have the table in RemoteDB linked in...
  18. ranshe

    WHY? Two Db's in same directory with same Table yet, one wont open

    The versions were incompatible. Apparently I have an early version for VB that only sees Access97 and I have Access2000. Thanks!
  19. ranshe

    WHY? Two Db's in same directory with same Table yet, one wont open

    This is the code that causes my problem: Public db As Database Public recset As Recordset Private Sub Form_Load() Set db = OpenDatabase("C:\Documents and Settings\res982\My Documents\Nwind.mdb") Set recset = db.OpenRecordset("Customers", dbOpenTable) If recset.EOF = False Then...
  20. ranshe

    Help with code on Stopping Window's Services

    I need help on getting the following code to run! I have been testing some code from the "MS 2000 Scripting Guide". Its link is: http://www.microsoft.com/resources/documentation/windows/2000/server/scriptguide/en-us/sas_ser_zhcb.mspx This code was referenced in thread707-930084; The reference...

Part and Inventory Search

Back
Top