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!

  • Congratulations strongm 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. JimCowan

    Building Code at Run-Time

    Is it possible to generate a line of code during run-time. I want to delete files depending upon a prior calculation. Can it be done?
  2. JimCowan

    Delete a line of Code

    Within an event procedure, how do I delete a line of code which would be executed once only, then deleted? Can it be done? I am using Office 2000. Thanks for any help
  3. JimCowan

    Variables Input to Table

    Using Access/VBA 2000, I want to push the value of a variable (varPayGrade)into a table (Salary_History), field (HPayGrade). I have an open recordset, looks like this... varPayGrade=10 Set rst = New ADODB.Recordset rst.Open "Salary_History", CurrentProject.Connection...
  4. JimCowan

    ComboBx/3Field Values to Variables/One Click?

    I want to put 3 field values from a ComboBx into 3 variables by one click on the combo list by changing the BoundColumn property. Here is my code: Combo138.BoundColumn = 2 Var2 = Combo138.Value Debug.Print "Var2=" & Var2 Combo138.BoundColumn = 3 Var3 = Combo138.Value Debug.Print...
  5. JimCowan

    Dim db As Database

    I see many code examples in tek books like the following Private Sub PayFactor_BeforeUpdate(Cancel As Integer) Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("Table1") When I attempt to run this, it gives me error code "User-defined type...
  6. JimCowan

    "As Database"

    Using ACCESS and VBA in Office 2000, I get an error message which says "As Database" does not exist as a type. Yet most of the sample code uses it in '97 and '95; ie. "Dim dbs As Database". Is there something new in '00, or am I missing something in the Module or elsewhere?
  7. JimCowan

    Getting a record value from a Second Table

    I need code to access a particular field record in a different Table. ACCESS wants to look only at the current Table, being the one underlying my ComboBox on a form. How do I point access to the new table, and what code is correct to place the field record into a variable?
  8. JimCowan

    Combo Box - Input to second Access Database

    I have 3 combo boxes on a form, all showing the same 3 fields from database #1. On click, one of the fields is input to Database #2 When each box is clicked, it inputs one field to Database #2. I want to input once, using each field of data from Database #1 to Database #2 without the redundacy...
  9. JimCowan

    Peek and Poke

    Of the replies received, perhaps the most helpful is the one sent by ARISTARCO. It happens that I am trying to build a gizmo to include an electric motor drive. (Programimg is easy enough), but getting a controlable pin or pins is a little beyond me. ARISTARCO, I could use some non-engineering...
  10. JimCowan

    Peek and Poke

    Basica has peak and poke functions. What, if any are the corresponding VB commands?<br>On a related matter, I want to control specific output to pins 18 and 19 on the UART output. How can this be done in Visual Basic or ACCESS?

Part and Inventory Search

Back
Top