Search results

And sadly, that's the limit of where too many people look these days. Drop out of the Top 10 and might as well have disappeared off the face of the planet. I'm only interested again because I have a Fantasy team in a competition run by The Telegraph, one of UK's leading broadsheets, after an...

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

Control source is set to the correct table. The idea is for the user to key the info into the field and the combo box will select the correct name if it's already in the table or if not, add it to the table, automatically allocating a new PK etc. At the moment, it's not accepting any new...

Managed to get a newer form set up, but I still have the problem of not being able to get new data entered in. The form will accept data keyed in the first form but won't save it when I try to move onto the next form. Our intention is that the user should be able to key in all info as though it...

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

Managed to get my various subforms onto the mainform and everything lined up correctly (yes, it was a pain), however, I notice in my form view there is a solid blue line down the left side of each subform. Is there any way of getting rid of this? I've found that overlapping gets rid of the...

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

Some of us at Prenton Park are hoping we never meet Arsenal again, so maintaining that record, although many wouldn't mind a trip to the Emirates one day. Arsenal and ManUre are actually the only two Prem teams never to have played at PP in a 1st Team competitive fixture, although the latter...

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

You could say I'm a big follower of football, originating as I do from the Merseyside area. I also like the Australian, American and, to a lesser extent, Gaelic versions too, having been to live versions of the former two at least. In fact there is a thriving American Football scene in the UK...

BUMP !!!! Sorry for the lengthy wait to reply but I've been away for the last two months or so. I had 3 weeks holiday due and on my return, I spent the next 6 weeks on a TESOL Course, learning how to be an English teacher. But now I'm back, asking annoying questions again :D. One thing I...

Trying to design subforms as suggested. However, my subforms only have one field each (the only fields we intend displaying) which displays no control label but has a MASSIVE form label, which I can't reduce in size to zero. I basically want to display labels only for the fields shown rather...

Younger blood is the way forward, in theory at least. However, we now live in a world that demands INSTANT success. Clubs that run successful youth academies would reap the successes in the 1st team in 5-10 years time. Except that those players are often recruited to bigger clubs as soon as...

The form is currently blank. I can enter stuff in the Bases and Nations combo boxes but not the School_Ministry field. We want the form and relevant subforms to be able to input ALL details.

After having to redo the form, to try and solve a number of seperate issues, I find I now cannot get this query to work. I've tried deleting and rewriting it, but to no avail. Do I need a seperate code to re-query the issue?

In this hierachal set up, can the Teams (schools) be set up as the Main form with Bases as subform and Nations subform on subform? - a reversal of your first scenario. I ask this because the teams are the central object of this particular DB, their tasks the subject.

I see the Anti-Racism group Kick It Out have jumped on the Rio exclusion bandwaggon this week. If Roy says it was for Footballing reasons, then you don't have to be an expert to know that Rio HAS suffered with both form and injury over the past 18 months or so. Terry has only really had the...

Correct me if I'm wrong (probably am:D) but from the example above, I'm deducing that my MainForm should only be showing data from as few relationships as possible, preferably as little as 2 tables with one relationship, and all extra data required should be in the form of Subforms displayed on...

Thanks Pat. On closer inspection, one of my tables [Bases] is related, in a one-to-many relationship, with 2 others [School_Ministry] and [TeamMember]. I got rid of the latter relationship as I can link through the [School_Ministry] table instead. However, no luck yet. I'm wanting...

Have found some possible theories to the above, on gooooogle, and am investigating each one :). I'll be back to stretch your grey cells should I have no luck.