Search results

Thanks... but it keeps saying can't find form frmSysEnt. I'm stumped.

Bob it works great... Last question... if I were to add an Entitlement to the actual underlying table... how would I update the listbox? I tested it and it didn't update.

Again, thanks for taking the time.

Yeah... the 2nd combo selection... the 2nd value on the right listbox... Image Access. It shows up in the left listbox. Multiple times. I know many systems have that same entitlement. It seems like it showing all the entitlements in tblSystemEntitlements not tblEntitlements.

Bob, Thank you very much... I think I am almost there... it looks like its doubling up some Entitlements on the left. Again, I am no advanced person in VBA or SQL... but it looks like its saying to populate the LEFT table with all Entitlements not in the combo selection. That is true that I...

Or if you have an easier way of doing this... I would be all ears.

Thanks Bob... I amended the SQL and changed the bound column. Still nothing populates the listbox.

Duh... I might want to attach it.

I am having trouble with a listbox populating. I have attached a copy of the form that is giving me issues. It has some code in the AfterUpdate of the combobox. The form in question is frmSysEnt. Any help would be appreciated. Also, I am rather new at programming in VBA and SQL so please...

Thanks Hbrems... here is what I amended the code to: Private Sub cboSysEnt_AfterUpdate() 'declare variable Dim SQLLeft As String Dim SQLRight As String 'Create sql statement SQLLeft = "SELECT e.EntitlementsID, e.[EntitlementName]" & _ "FROM Entitlements e " & _ "WHERE Not EXISTS " & _...

Thanks for the suggestion.

Im a moron... thanks... I got it.

Here is the save button code: Private Sub cmdSaveUSER_Click() On Error GoTo Err_cmdSaveUSER_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Exit_cmdSaveUSER_Click: Exit Sub Err_cmdSaveUSER_Click: MsgBox Err.Description Resume Exit_cmdSaveUSER_Click...

frmEmployees... frmEmployees is the main form. I have a button to add a new user... it pops up another form (frmNewEmployees) which is where the user adds a new employee. that is where the save button is located. I can't see the new employee in the frmEmployees... only if I close it and re...

Bob, I put it right at the bottom of the saverecord cmd button in the click event. It still won't update the form. Only if I close and reopen the form. it saves to the table fine.

Great thanks... I really appreciate.

hbrems... this is what I have... no errors (thank goodness) but nothing is populating into the listboxes... Private Sub cboSysEnt_AfterUpdate() 'declare variable Dim SQLLeft As String Dim SQLRight As String 'Create sql statement SQLLeft = "SELECT tblEntitlements.EntitlementsID...

This is fantastic... question though... when you say SQL for the right and Left Listbox... are you referring to including that into the rowsource? Or are you saying that has to go into the afterupdate of the combo? Thanks again...

Okay... I have attached a copy of a test DB... The form frmSysEnt is setup like I would like. However, as of now the buttons don't work. Basically what I would like to see done is the ability to move the ENT between the listboxes... my problem is that I can't figure out the code to remove...

Ok... I have two forms... employeeinfo and newemployee. On the employeeinfo form there is a command button that takes you to the new user form where users and can add a new employee. I have a save button on the new employee form. The save button works and updates the appropriate employeeinfo...