Search results

Glad to see the lockout is over and the proper Zebras can get to work. I have to think the debacle that was the end of the Seahawks v Packers game was the straw that broke the camel's back. Something HAD to be done to avoid further farces.

I have a series of subforms to record the number of occurrences of specific actions over a set number of weeks, one subform equals one week. My issue is that when I put a number into any of the fields in the first subform, that number is automatically repeated in all 11 subforms for that...

I have a form with a series of 6 checkboxes which show various stages of an application for teams to join outreaches in our focus cities. These stages are Enquiry, Application, Acceptance, In City, Left City & Thankyou Letter. Ideally, the user wants to simply tick each stage as it is...

My form has been set up to enter and display info. However, the table it goes into is not populating until the user has finished his/her session and closes the form down. We need this info to update earlier, preferably on entry, as we require certain elements to be able to populate other...

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

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

I need to create a query that, when a button is clicked, will display data in pop up form (subform) regarding the individual members of various teams we are sending to our Focus cities. Whilst we need to pull in data from numerous tables to ascertain which team the individual is a member of (to...

A new season is almost upon us (already started if you include the Carling (League) Cup 1st Round played last Saturday & Tuesday) this weekend. The Scottish Leagues began a few weeks ago with some interesting alterations namely Rangers having to play in the Scottish 3rd Division following...

Trying to add a number of subforms to a mainform so that I end up with a type of grid for storing stats for specific activities performed over a specific number of weeks. One subform represents each week, 11 subforms in total (when completed). The fields on each subform are meant to line up...

I am trying to place a number of subforms onto a mainform and line them so that the fields on the SF line up with particular labels on the MF. However, every time I try to alter the size of my SF to ensure all fields are displayed, I find the header and footer, the latter especially, increase...

I have a form which I intend to input data from a total of 6 tables (School_Ministry, Bases, Nations, TeamMembers, Focus City & Regions), numerous fields from the School_Ministry table and 1 field from each of the remaining ones. I am slowly building the form to add in the main fields from the...

The European Championships are almost on us now, beginning this Friday (early hours of Saturday morning where I am though). For once, England's expectations are lower than previous tournaments, which is probably no bad thing. The new England Manager is getting slated for picking untried...

I have a form that records the stats of teams working in one particular city in the world. The form displays the Base where the team comes from and the nation where that base is located. It also displays the region of the city where they will be concentrating. I want to create a macro (or...

My form has a combobox recording the nation a team comes from when going to our Focus City, selected from a predetermined list. When I try to key in the first letter of the nation in question, the filter selects only the first nation in our list beginning with that letter, instead of all...

I'm looking through some of our older DBs and am trying to access the codes behind some of the queries, so that I can view what they say and try to work out, from those examples, the codes I need for my requirements. However, I only seem able to run a New Query option, rather than view the...

I have a large table of info regarding the individuals who make up the teams we are sending to our Focus City. It currently has 26 columns, stripped down from about 60 and contains the records of about 4000 individuals. It was originally set up in 2002 to deal with my own Base only and about...

I'm working on a DB recording the stats of various teams from around the world, all working in the same city at various stages throughout one calender year. The year is split into 4 quarters which we are actually terming as "Waves", numbered 1-4. I am trying to set up a calculation whereby the...

After countless efforts, I have finally managed to get a form that displays my Teams as from the correct Bases and Nations, and for those allocated regions, I have been able to input the correct info afterwards. Hallelujah!:D My next query is to be able to use the form to add new teams not...

I keep getting this legend in the bottom left of my form when I try to key in data into some of my fields. The main relationships between all relevant tables is fine ie PKs and FKs correctly set up, but I am unable to see where any other joins are necessary. The form is being designed to only...

I'm working on a DB that will primarily be used as a Data Entry form for recording the actions and their results, of various teams in various regions of the same city. Without going into too much detail - it's already mentioned in other threads on this forum - I currently have a small number...