Recent content by bernmc

Top man Bob - sorted in an instant. Reputation added to :)

Ta - will try that.

Rats... is it really that difficult then? Thought it might just be a simple bit of code. Note to self: Learn VB! :D

Right, here it is, with some random data. Form is 'Default Staffing' (Be gentle - there's a lot that doesn't work atm, and my coding ability = copy and paste!!!!)

I'll post the whole thing (not big) - problem is it's @ work, so it'll be on Tuesday.

No ideas then.... :(

Thanks for the advice BL. Bit confusing the way access handles the subform - I didn't see the options to disable adding/edditing because I simply clicked on the edge of the subform to select it, rather than clicking the little block top-left that you would normally use to select a form. So...

Howdie y'all I need a few pointers wrt the relationship between a form and its subform. I have the following form: Top part of the form is for adding/editing etc. The subform is based on a query. The two are linked on the 'week' value. Now, this is what I want to do: The user must not be...

Thank you both for your advice - starts to make a bit more sense! I'll be back...:o

Hello all. Still getting my head around this database stuff, and need some help on defining primary keys and links: Basically, an operating theatre staffing database: It has a four week rolling rota. Lets say for eg there are 10 theatres. Week1 Monday Theatre1(am) will have Surgeon: Joe...

Thank you both - very helpful. (I had to look up 'normalised data'!!!)

Hello All. I've had a pop at a few databases before, and always regretted not getting the basic structure correct right at the beginning, so I was hoping for some pointers here! Basically, I'm responsible for generating an Operating Theatre staffing rota for a small NHS Hospital. There are 10...

Thanks Pat & Doc... I'll give it a go - I'm sure I'll be back for more :rolleyes:

Hello all Firstly, please note I'm an access virgin ;) . I did play with visual dBase a long time ago.... I'm setting up a database for my wife's amateur dramatics company, and am struggling to decide how to arrange the tables and their relationships. This is how the company works. It has...