Recent content by martinhough

Ok - Thanks for the tips. Still the same though. Here's the relationships now;-

Here's a capture of the relationships. The problem is definitely with the relationship of the two forms. If I take the Linkmaster field properties out, I get no errors (but obviously the records don't relate correctly).

Try putting a Requery in your event action that takes you back to the previous form. It will need to go before the actual action of close/open form etc.

Thanks OMD. Yes, I did consider this - your suggestion gave me the 'push' needed - I've now deleted the subform and re-created it. Same issue though, sadly -but that might throw more light on it? Anyone?

If I had any, I'd have pulled it out by now! I need some expert help please. I have a main form (unbound) and a main form (bound) and then a subform (or a main form;subform;subform). The main form has the following SQL;- SELECT Detail.*, Hazards.*, HowHarmed.*, Section.* FROM PSR RIGHT JOIN...

Actually, in Access 2007 you can change the colour of datasheets (forms or subforms - background) by right clicking on the datasheet in question. Select 'Datasheet' and you'll be presented with a dialogue box with cell colours/grid-lines and effects options.

Ah, you're a star! Yes, that worked. Thanks. Why did that not show in my 03 version then?

Hi I have a routine that appeared to work fine in ms Access 2003 but since being upgraded to 07 now prompts me for the value of a variable (testid). When I toggle the section concerned the variable seems to be holding the correct value, but is still prompting me for one. Extract of code in...

Just changed the names of anything called 'record' - still get the error with the newly named object. Is it something to do with the 'Tabbed Pages' element? I can normally run a subform without hitch on a form, this is the first time I've tried it this way.

Ah, that'll be it Galaxiom! thank you!

Thanks Galaxiom - I had tried using the link master and child fields but ended up getting an error message to the effect of "The object doesn't contain the automation object 'Record'". Not sure why or what this is. Okay, so if I set these fields (Master to the staff primary and child to...

I am trying to use a form which has a tab control on it. There will be 5 or 6 tabbed pages. On each page there will be a subform with 3 columns ('date from', 'date to' and a calculated field of 'days total') as well as other controls on the actual page. This db currently has three tables. One...

Many thanks Bob

I have a form which uses a 'Group By' query on a given field. This works fine by compiling seperate orders (all from the same company and at the same time by the same person) but does not allow a user to input (I have a drop down box to select whether the order has been placed or not, which in...

Thanks Dave - yes, like your thinking there and that may actually help me with another issue (getting this info in a report consistently!) but not sure how I get one record for these potentially numerous orders - the duplicate table idea would surely just give me another run of separate records...