Search results

This is a re-post... but my first post was vague... For Example if I have a join table like... Company Plane City Delta 1 London Delta 1 Philly Delta 2 London and I wanted to find only Plane numbers that have been to London and London alone... so that...

I have a query that I am trying to build... Where I need to find a specific value that is not equal to any other value. For example; Column 1 is Counterparty, and Column 2 is City. There can be multiple Cities for each Counterparty... I need to create a query where I find only the...

Okay... I have 3 comboboxes... cmb1, cmb2, cmb3. cmb1 is a field list of tblInfo. cmb3 is the values of the cmb1 selection. So say lastname is chosen in cmb1, cmb 3 displays all the lastnames from the tblInfo. cmb2 is a value list with "=" and "<>". My question is, how do I put these...

Ok... I have two comboboxes, cmb1 and cmb2... I have cmb1 rowsourcetype = FieldNames and rowsource = tblInfo. What I would like it to do is populate cmb2 with the list of values based on the users selection of cmb1. From what I have found and read... This needs to be done in VBA based on the...

I know this is wrong... but I am trying to write a DELETE Query in SQL based on certain parameters... Thanks. DELETE tblEmployeeAccess.EmployeeID, tblEmployeeAccess.SystemID, tblEmployeeAccess.EntitlementID FROM tblEmployeeAccess WHERE (((tblEmployeeAccess.EmployeeID) =(SELECT...

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...

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...

So I have a combobox with a 7 different options... I would like to autofill 4 bound combos with a specific value. I am not sure the SQL statement to handle it. So far I have: If [ThirdPartyID] <> "N/A" Then cboJobBand.Rowsource = SELECT tblJobBands.JobBandID, tblJobBands.JobBandName...

I think I am being really dense, but I can't seem to get the listbox to populate based on the combo selection. The combo's rowsourcetype is FIELD LIST and the rowsource is a query: SELECT DISTINCTROW tblEmployees.[First Name], tblEmployees.[Last Name], tblEmployees.[Pulse ID]...

Ok... I have two listboxes. I want to be able to select information from the left listbox and be able to move it to the right listbox. I created a table with option boxes to be able to choose yes/no to make it easier. The rowsource for the left box is: SELECT tblSampleEnt.EntitlementID...

Okay... I have three tables... tblSystem Entitlements SE_ID SystemID EntitlmentID tblSystems SystemID System Name tblEntitlements EntitlementID EntitlementName I have a form with a combobox (cboSystems) which lists all the System Names which is pulling from tblSystems.. I have one...

hello... I have two comboboxes... cboChoiceName is based on a query... when you select an item it populates cboChoiceSys. When you make a selection it populates lboEntitlements. My problem is when I change a selection in cboChoiceName, cboChoiceSys goes back to (0) and I can make a selection...

Okay... so I am working on building out a database that stores information for employees and their entitlements to different systems. Each system has different entitlements. I have created an Employee Table, System Table, and have consolidated table that had every entitlement possible...