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!

Recent content by rtvillan

  1. rtvillan

    Access and VB

    Thanks. It worked!
  2. rtvillan

    VB and SQL Help

    Need help in calculating! First of all, I have a database called db1.mdf that has " table1" and has a column for "fuelqty" , "cost"and "Mileage" (number of of mileage). I need to implement the specified data analysis capabilities (cost per mile, and miles...
  3. rtvillan

    Access and VB

    I have written a code that a customer clicks an "open" button and chooses a database. Upon choosing, it opens up a form where a customer can input the text box with the date, cost, odometer, etc... and press a button to update or add. How can I get the program to prompt the user to...
  4. rtvillan

    user defined types

    I have a question regarding the DIM statement. I copied a code from another form that dynamically creates an Access DB. ex: Private Sub mnuNew_Click() Dim newdata Dim tb As TableDef Dim fld As Field Dim indx As Index Dim DBNaam$ Dim dbNew As Database 'get name of the new...
  5. rtvillan

    Open a database file on Runtime

    Hello, I can't seem to figure out how you can open a database file(example: db2.mdb) when a customer clicks on -->file-->open from a menu. But db2.mdb is automatically associated with ADO once it's selected. How is the connection string automatically reading that DB? Does anyone have a sample...
  6. rtvillan

    open MS Access in VB from a user prompt on the menu

    Hello, How can a user open up and choose an MS Database from a user menu in a form ie -> File -> open .... then choose a DB. It has to be in ADO. Example: 1. the File name is db1.mdf 2. when it's chosen, the fields are tied to the text boxes thru a connection string automatically...
  7. rtvillan

    Urgent! Due tomorrow! Connection string

    I have a command button that creates a new Access database with the following : Dim newdata Dim tb As TableDef Dim fld As Field Dim indx As Index Dim DBNaam$ Dim dbNew As Database 'get name of the new database newdata = InputBox("What's the name of the...
  8. rtvillan

    Dynamic loading of access db and automatically setting the Connection

    I need help or a code on how to dynamically load a new Access database (db2.mdf) to a program. It loads db1.mdf by default. Also, how do I automatically set the connection string the same as the db1.mdf (connection string name is 'robert'. The customer at this point clicks on a command that...
  9. rtvillan

    Multiple database

    Can anyone help me with a code. I am using VB6 and need a code to automatically or dynamically load a new Access DB after a user creates it from a menu prompt I've coded: Private Sub Command3_Click() Dim newdata ' Dim lokatie$ Dim tb As TableDef Dim fld As Field Dim indx As...
See more

Part and Inventory Search

Back
Top