I am just testing a 2 field form to see how to update a field in Access from VB. I know this is basic but I am new at this. It is going to the right row and getting the right jobnumber from the access database. I did that so I could see if it was connecting to the database. But when I change the Text box to reflect the new number I want in its place in the database it doesn't complete the action. The end result is I want to capture the fields that I have on my form and get them into an access database.
Here is my code.
Private cn As ADODB.Connection
Private mrscust As ADODB.Recordset
Private Sub Form_Load()
Set cn = New ADODB.Connection
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…