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

Part and Inventory Search

Back
Top