Recent content by Saracen

Thanks Galaxiom, exactly what i was trying just before your reply. Thanks. Also I had originally tried to just populate contest table with single form using unbound "detail" combos (e.g county, city, club etc.) to filter 2x bound compeititor combos including, as you say, delisting competitor...

Okay,that's good, a join table. However how do i populate the contest table (with common data) and the competitor/contest join table from the same form. Also how to create the multiple records in the said join table from that single form for each contest? Thanks.

Hi, I've trawled the web and found lots of answers relating to sql dbs etc and a couple relating to access but none seem specific enough to answer my queries. I'm developing a simple sporting records db. I have a 'Competitor' table listing competitors as follows: CompetitorPK, Name, Division...

Hi, I'm trying to display an attachment image based on combo selection on a form. The attachment control works when its a bound control (e.g. data entry form) but i can't get it to work when I try to retrieve the record based on sub-query which sources combo control i.e. display company logo...

Hi ChrisO, I take your point and i have actually considered this. The colour picker would be used to select "team colours" for each group working on various tasks. Similarity between groups would not really be a big problem as (a) the number of groups is limited and (b) if i get this working i...

Hello, Has anyone any experience using a "colour picker" control on a form. I've used date picker controls in the past which worked very well but then again the "calender" control was readily available. The only info I've found on "MSAccess + colour picker" (Google search) related to calling...

Use the "After Update" event on the EVENTS tab of the property sheet for the AREA combo box. Click the " ... " and select create MACRO. This will open the MACRO create space where you need to select the REQUERY action to repopulate the OFFICE list (control to requery). This assumes the OFFICE...

Thanks for your assistance with this last week, i eventually tracked the problem to properties incorrectly set in the underlying table - just goes to show, very often problems are caused by the most benign of things and Ive learned (not for the first time) how important tables' design is...

ok will try, some shifting about to do - DB is on Win7 work system, posting now on personal (i.e. older!) vista system without access2010 installed, so may take a little while. Thanks again.

Thanks boblarson, ...yeah i set the column count to 3 so that i could see all the columns in the "Names" table when i click on the combo box just so that i could be sure (at this early stage) which record i was selecting; also the column widths are set e.g. 2cm and the only bound column is the...

...Apologies to all readers if this simple problem has been answered in this forum previously. It seems the questions that have previously been asked relate to the actual mechanism required to populate the text boxes, i'm familiar with this (i think) i'm just having trouble implementing...

Hello, I've seen this type of thread already in this forum but I can't find any replies that answer my question: Put very simply I have two tables e.g "Names" & "Teams". Names table: ID_field (primary key), Name_field, Extn_field Teams table: TeamID (primary key), Name1_ID, Name2_ID...