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
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...
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...
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...
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?
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?
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...
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.