Search results

Unfortunately the one @arnelgp sent didn't work the way I needed. There are 11 spaces that have had multiple people assigned over time. His Query 3 added five of these (the ones where the first assignment was current but the second was vacant) giving a total of 25 records in the result. The...

Thank you. That does exactly what I want. I hadn't thought of the need to do multiple queries to get to the solution to my problem. You have opened my eyes to a new way of thinking about queries. Again, thank you.

Thank you for the tip on creating relationships and enforcing referential integrity. I had to add a record to tblSpaces before Access would allow me to do the relationship and enforce referential integrity between tblMMPeople_Spaces and tblSpaces. The query you gave worked in that it pulled...

I have a database with the following tables: tblPeople, tblSpaces, and tblMMPeople_Spaces, which is attached. The tblMMPeople_Spaces table is to record assignment of people to authorized space and records the start and end dates of the assignment, if known. If not known, the start or end date...

I tried “Me.Filter = "EndDate BETWEEN Date() AND Date() + " & Me.textBoxDays Me.FilterOn = True” in the After Update event for the text box (textBoxDays) and it worked perfectly. I will check out the other options when I get on my computer. Thank you both.

I am trying to filter a form that displays data from an employees table. Each employee record has a scheduled departure date: [EndDate]. I want a user to be able enter the number of days into the future that they want to see upcoming departures: textBoxDays. For example, if the user wants to...

Just involved with government contracting.

I think I figured it out what the lostfocus code is for. Using "SELECT tblContacts.ContactID, tblContacts.ContactName FROM tblContacts;" as the row source for the ContractingOfficerName ComboBox displays the name of the contact regardless of what is showing in the dropdown list, enabling...

Thank you. Using "SELECT tblContacts.ContactID, tblContacts.ContactName FROM tblContacts;" as the row source for the ContractingOfficerName ComboBox displays the name of the contact regardless of what is showing in the dropdown list, enabling display of legacy data that is not a current...

I have a combobox with the following characteristics: Data Control Source: ContractingOfficerName Row Source: qryContacts_KOs Row Source Type: Table/Query Bound Column: 1 (ContactID, autonumber) Limit to List: Yes Allow Value List Edits: Yes List Items Edit Form: Inherit Value List: Yes...