Recent content by koketsomaseko

I am still an amature on vba can u please explain an append query?

Save Item in listbox (Row source type : Value list) to a table in a database .

It say the Password has been change but nothing happens and no the form is not bound

I have this code to change user password Private Sub Command3_Click() If IsNull(Me.cboEmployee) Or Me.cboEmployee = "" Then MsgBox "You must enter a User Name.", vbOKOnly, "Required Data" Me.cboEmployee.SetFocus Exit Sub End If If IsNull(Me.txtPassword) Or Me.txtPassword = "" Then MsgBox "You...

[Private Sub cmdLogin_Click() 'Check to see if data is entered into the password box If Me.cboUserName.ListIndex = -1 Then MsgBox "You must select a User.", vbOKOnly, "Required Data" Me.cboUserName.SetFocus Exit Sub End If 'Check to see if data is...

I need to separate Users and admin on login so that the admin can go to admin form and users to specific form using vba access here is my login code Private Sub cmdLogin_Click() 'Check to see if data is entered into the password box If IsNull(Me.cboUserName) Or Me.cboUserName = "" Then...

Please help me with the code to save data in listbox to a table in vba access

Well when i press the Export button , it exports the whole entire table rather than exporting the Listbox search pleas find the attached photos

I have a Listbox named List5 and a search textbox named txtProperty and a table name sms , after i search in textbox the results in listbox . i would link to inport the results in listbox to excel but the code i have export the whole table to excel , please help: here is my code...

Im getting errors Run time error '424' Object required

I have a form in Access VBA and five textboxes , but when i add the data in textboxes to Listbox it only add to single coulmn not all 5 please help? here is my code Listbox.addItem txtmajor.value Listbox.addItem txttime.value Listbox.addItem txtne.value Listbox.addItem Comboesc.value...