I am trying to write a simple database program. My problem is when one of the forms loads I get a run time error 91. Here is a copy of the code from this form. Debug highlights my error at UserInfo.Recordset.AddNew. I tried removing that line of code and get the same error code, only then it points to UserInfo.Recordset.Fields("username") = txtName.Text. I have a connection to the DB "UserInfo" and the field names are correct. Any help would be greatly appreciated.
Private Sub cmdClear_Click()
txtName.Text = ""
txtPassword.Text = ""
Private Sub cmdConfirm_Click()
UserInfo.Recordset.Fields("username") = txtName.Text
UserInfo.Recordset.Fields("password") = txtPassword.Text
Private Sub Form_Load()
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
What I'm presenting in this article is the result of 2 conditions in my work area:
We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
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 utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…