Search results

Option Explicit Option Compare Database Dim iCtr As Variant Dim whrStr As String Private Sub Command158_Click() For Each iCtr In Me.MAIL_PROVIDER.ItemsSelected whrStr = whrStr & Me.MAIL_PROVIDER.ItemData(iCtr) & ", " Next whrStr = Left(whrStr, Len(whrStr) -...

So assuming this goes on command button, I've added DoCmd.OpenQuery after this code so I can view the results, however I'm stuck. Firstly, I'm not sure what to replace the "someNumberFieldName" with, and also when I click the button, the query doesn't open?

Hi all, I have a search form that uses several comboboxes, textboxes and checkboxes that are used as criteria in a query. You enter in the relevant information, hit search and a report opens based on the filtered query. What I would like to do is change one of these combo boxes to a listbox...

I'm getting there I think, I've been creating queries to show the information I want and then basing the forms on these queries. The only problem I can see so far is if I want to show multiple roles and locations without turning it into a multiselect lookup field, which defeats the object of...

Thank you for all the help so far, I've had a look through example and I can see where you've changed things and after reading that webpage I can see why as well. I'll have a little look through again and try designing these forms based on this information.

Ok, thank you

Here you are, thank you for this

Sorry, I was getting you confused with CJ London who made the suggestion earlier. I've tried following Plog's design and now I have the TeamMembers table, with TeamID, UserID and CurrentMember as Yes/No. I will change this to a date field eventually when I've worked around this. I've then...

I seem to be getting 2 people telling me 2 different ways to go about this. So how would you do it if I delete the Current and Previous tables and then move Roles and Locations to the Users and Teams tables? I've now changed my table ID's to these:

Here are the screenshots. I don't know what else I can say, my form is linked to a query which shows the Name, Genre, CurrentMembers and PreviousMembers. Current and PreviousMembers are multiple listboxes, and I just want it to filter out the unchecked values, i.e if John Doe is checked for a...

So far, my table relationships and query designs are like this; However, when I uncheck for example UserA in the CurrentTeams table for TeamA, when I go onto the CurrentUsers table, it still shows UserA having TeamA checked in the CurrentTeam list, which is what I was trying to get around in...

Hi all, I have a list box on my form with different users selected. I want to be able to double click on one of the values in the list box and open a form to a specific record. I can do the DoCmd.OpenForm part, but I'm not sure how I would put this on each value in the listbox. Also, ideally...

Ok, that's fair. It's not about whether this team is current though, it's about what User is in that Team currently, so a list of users that are.

These are my table relationships.

They're not calculated, there's no calculation involved here at all. Also, Current and PreviousMembers aren't yes/no fields, they're fields with the names of Users in that show who was and currently is in the team.

The project won't be entered into the table I think, it's just to divide up users and teams to give an overview of each. Now I have the following tables; Team, User, CurrentTeam, PreviousTeam, each with the structure as outlined above, where do I go from here?

Hi all, I have 2 tables, one called Users and one called Teams. Users has these fields; ID FullName Role CurrentTeam PreviousTeams Teams has these fields; ID TeamName Location CurrentMembers PreviousMembers Role and Location are both lookups from other tables, named respectively...

Sorry, I read that line as optional on baldyweb. Thanks, brain is feeling very slow today!

I can't for the life of me seem to get this to work. My code is this; Private Sub Name1_DblClick(Cancel As Integer) Dim rs As Object Dim lngBookmark As Long lngBookmark = Me.OriginalID DoCmd.OpenForm "frmMyForm" Set rs = Forms!MyForm.RecordsetClone rs.FindFirst "NewID =" &...

I changed from a listbox to seperate textboxes, it's easier for now. I've been using the WHERE condition of the OpenForm method, however it filters the records to that one record and when I turn the filter off, it goes straight back to the first record, how can I turn the filter off and stay...