Recent content by clobug1

So simple and yet so effective! It works, thans v. much for your help.

When adding a new candidate and their personal details to my database I use a form for data entry. It is necessary to store the workplace at which they are based so I have a relationship between the tables, workplace:candidate, 1:many as obviously many people may work at one workplace...

Thanks v. much - I may go book shopping tomorrow. Will this also give me some good explanations of how to decide on relationships as I'm having real problems at the mo. All my tables are in place buy none of them are linked as it's starting to get complicated. I had a thread going on this...

I have found a fairly simple way round this, I think! Firstly I used MS Excel to sort out who's on and who's off. I created a list of all dates for this year 1st Jan to 31st Dec. Then you just need to find out which day your A shift started on and type in A beside the first 7 dates, and B for...

We currently have 2 databases, each being data input by 1 person and 1 person only. The PCs are running on a network. When creating a new database to merge both of these old ones it would be really useful if we could have multi users so that both the previous administrators can continue to do...

Thanks v. much, What I've done is attached the dbase in which I've been practising the links we've been discussing. It's v. small and doesn't contain all the other data in the tables such as address, DOB etc. which at this stage aren't important - I just want to get the tables linking...

Thanks for that - any chance of an opinion on my thread in the Tables section? Thread is 'Linking Tables' (someone is currently helping me but i feel he may be getting bored with my stupidity?!)

Is it worth me posting a screenshot of the relationships? and if so how do I do this? Have tried the bit about changing the joins but I get an error pop up - "The SQL statement could not be executed because it contains ambiguous outer joins"

I am currently building a database at work which is larger and more complicated than those I have built before. I feel that this time I may need to use Modules and/or VBA as things are getting tricky (See tables forum - linking tables). Can anyone suggest a good book which I could read to get...

I've tried the bit about linking back from Units to candidate and excellent, it works without the direct link! But I've tried to do a query to show all the candidates who are on a current programme and what they are registered for - as soon as I add the UnitComp table to the query I lose the...

I don't know whether this is of any use, but when you have created your query and consequently your form there is quite an easy way of bringing up data for a specific record - eg you want to bring up the record of employee Ref 2018 so that you can change their address. If you create a header...

That's great, however if I need to relate these units back to the candidate in some way can I also put a relationship in directly between the units and the candidate ie using the unique id from CDetails in Units so that I can later pull off a report of all the units signed off for that...

Having some real problems creating a new database to hold information on candidates studying at our 'college'. So far I have created all the tables but am having real problems linking them and am not sure how viable it is to have several links flying around from each table. Tables are...