Search results

Just having a couple of afterthoughts on this one. Not sure whether to continue on this thread, given much of what's been mentioned already is very closely related, or start a new one, but here goes:- A small but significant number of the individuals in our TeamMember table will end up being...

Nations is already in the RecordSource of the mainForm itself, but if I select that, then the other combobox won't work. I'm just wondering why Nations is not in my options in the ControlSource tab yet Nation Label is there. All other fields accompanied by labels are there, just not Nations...

Thinking that the combo might be corrupted, I tried deleting it and setting up a new one. However, I still get an unbound box without the option to bind it to my Nations table. HEEEEEEEEELLLLLLLLLLPPPPPPPPPP!!!!!!!!!!!!

Just checked - it's currently unbound so I would need to select the Nations table as the control source for this box, correct ?? When I scroll down the various options in Control Source, Nations isn't there, but Nations_label is, referring to the label for the combo. My NationID is FK in the...

My form has two comboboxes, the first one naming the Base where a particular school or team is from and the 2nd one the nation where that base is located. With the latter, every time I try entering a nation different from any entered into previous records, the box is automatically altering the...

Thanks, works perfectly now. Just need to clean it up to something a bit more pleasing to the eye. Then it's as good as ready to go live.

Still struggling to get my query to not display people NOT in the school or team I'm reviewing. This is the code I'm trying to use:- SELECT TeamMember.FirstName, TeamMember.LastName, TeamMember.[Nation of Citizenship], TeamMember.SchoolID FROM TeamMember; GROUP BY SchoolID; When I try to...

I have managed to sort the Team Members button out. It wasn't showing in Form View because I had accidently hidden it and then couldn't stabilise the visibility when I tried to reverse the selection. I set up a new button and designed a macro to run the query from it. It is this query that I...

Latest update :- I have managed to get the Team Member Query to open and display all the individuals by name and nationality on the db when the Team Members button is clicked. (I'm also displaying the School ID in the query, although this is the column I want hidden from view on the pop up)...

Sorry for the delay in getting back, a weekend got in the way:D. Thanks for your efforts so far but this isn't what I'm after. What I require is for the form to pop up when I click on the Team button which will appear just below the Nations field on the mainform once I've trained our system...

Most probably my fault :banghead: I should have reiterated that I require the SchoolID to be the criteria. That would filter all students into their respective teams so that only those members of the team referred to in the main form would be displayed in the popup. I don't need the school...

Seems to work ok when I open the query manually, although it only currently shows one record. However I now need to link it to the Team button so that it opens when that is clicked. Would I be right in thinking I have to create a new button and link it to the query in question, or can I link...

Managed to get a zipped version - it wouldn't zip when in browsing mode - so I've attached a copy here. I do now have a bit of a timeframe to get the project finished as I leave in a couple of weeks time to fly home to the UK. I would like something to present to my Ministry before I go. Any...

From my Team Member table, I have FirstName LastName and Citizenship, and from my School or Ministry Table, I have SchoolID. It is this last criteria that filters my team members and the one I don't want being displayed on the popup form.

That seems to be the issue here. I've also tried rebuilding the query just incase it was corrupted, but no change. I would upload a copy of my db onto here but I'm having a bit of difficulty trying to compress it to size. My system says it can't compress as the zip file is already in use...

Can't find the Visible property in the Property sheet - probably not looking in the right place, knowing me :D Have tried running the query but when I click on the Team button, I get the legend "Microsoft Access cannot find the object 'Team Members'", then the query opens the entire Team...

I'm wanting to run a query where all team members of any one particular team are identified, with names & nationalities being displayed in a pop-up form. Obviously I will need to use the field "SchoolID" as the filter to identify those people to be displayed, but I don't want that field itself...

Arsenal eh? Are you UK based or one of their many followers-from-afar? If the former, do you visit the Emirates often? How easy is it to get tickets for a game? I'm asking because I'm looking to attend a game (any game) there when I return to the UK next month, and definately before I...

Trying to set up a query to calculate age in my subform, the wizard tells me I can use fields from more than one query or table (I actually want to display 5 fields from 3 tables, 3 of the fields in an existing query). However, when I select my fields required, the wizard then tells me I've...

Query above still stands, if you can spot it in my rambling (I'm struggling and I only wrote it yesterday:confused:). However, a new issue has been thrown into the equation. I have been asked to add in an Age field in my subform, which will not be that relevant to the majority of teams and...