Search results

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

Latest updates, combo boxes are to be allowed where necessary, for the reasons stated on here. We just need to work on getting the Team Name field populated by keying the data into it. That is the key field that will make each page in the DB unique. I have been given a "newer" DB program to...

If combo boxes have to be used (something my seniors are extremely reluctant with), then hopefully, there is a code to write somewhere, so that as the user types the info into the field, the drop down box would automatically reduce in length until there are few enough choices for him/her to be...

My superiors have now decided they don't want combo boxes anywhere at all. Instead, ALL data is to be keyed into text boxes (or other defined data types where applicable) as new info, from the first teams and Bases onwards. We have about 120-130 bases currently registered on our own DB as...

I think my Wizard's gone on strike:mad:, it's nor firing up when I add my combo boxes to my form. Not sure whether that's a system fault or Wizard's been turned off on my system (shouldn't be as it works on other elements of Access).

Quick query - I have the two fields you name set as Text boxes only. To convert to combos, should I be making them lookup fields in the Table Design? Or should I be deleting them and replacing them with Combo boxes? Sorry for the basic stupid questions, I honestly have no idea what I'm...

I never really thought of tables - should really have posted this thread on the Forms pages, wasn't checking where I was reading :o I'm only questioning your suggestion because we will be having the situation where no matter what year or what city, our Waves will ALWAYS be numbered 1-4...

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

Here it is: - I realise some of the fields SHOULD be in seperate tables, but I've only just discovered a video about joining 3 or more tables in a single sql join and haven't got round to sorting my tables out again yet.

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

Thanks Paul I though I had already got rid of that join, but my system had kept a record of it somewhere, somehow, and THAT was what was stopping me from proceeding. I just got rid of the entire file and started again, which thanks to numerous previous attempts, only took a couple of minutes...

Just re-reading my own quote from a week or so ago, where it says PK, should read FK (I think) and vice versa. Is that correct? I want to be able to build some expressions so that we can start testing our data entries, but I don't yet know where or how to make the necessary corrections to be...

Next question - I have created another table, which we intend to use as the basis for a hidden subform which will display, on request only, basic details of individual team members ie name and nationality. I have linked this table to the t_Teams table using TeamID as the PK and FK where...

"Even though you might think there is a set number of events the users will be asking for more to be added almost as soon as you get going. They always do and that is the general philosophy you should use anyway even if you are sure nothing will be added." Without going into too much detail...

Thanks. I had an idea that Events would require new tables. We're actually recording a set number of defined activites over a set amount of weeks and the total number of times each event happens each week, whether the action actually happens or not (if not, the value in the corresponding field...

Thanks for your reply, VR, much help. My next question would be:- I'm going to be needing to expand the DB shortly to include records of the various dates of each team's state of application, from initial enquiry through to Thankyou Letter being sent post-participation. This would be indicated...

Thanks for your reply, but now I'm really lost:confused: Not sure where to access the source query so that the join can be viewed, and when I can, how to rectify the situation. I initially thought you were referring to relationships. As far as I'm aware, I have the correct setup for the...

Here it is. I tried to save it as a "2003 or earlier" version as I know some people can't access the later programs as I'm using, (I'm in Accdb 2010) however, my system would only let me save it as 2010 as it states I'm using files etc only found in that version.

Would I be right in thinking you mean a field that is autonumber in its own table (where it's the PK) should be a number in the tables where it's an FK? If so, that is what I have. I'm wondering if I should be populating particular boxes in the property sheets for each table to get things to...