Recent content by kimberlin

Thanks Minty, as soon as the boss gets back from leave next week I will mention it to him again. I did mention in an email to him before he went on leave that maybe we should be thinking in terms of investing in one. I forgot to mention that since I first split the database I have moved to a...

Thanks for your replies, I have already got auto numbering set on the tables which contain the worker and client details. It's only the form which inputs or edits data to the worker table which would have anything linked to it. I hadn't thought of using the ID numbers to give the CVs a unique...

Thanks for your reply Minty, I am on my own in the office tomorrow so will try the back up as soon as I get in. At the moment the CVs are kept on the machine of the person who has registered or edited the individual workers details in a structure which goes staff member name/supporting docs for...

I'm hoping someone can offer a bit of advice here. I admit I know nothing about coding but for some reason my boss decided 4 years ago that he wanted me to create an access database using records to keep all our client and worker records on, so that we could easily track who was available, what...

Hi I received some good help from this site back in the summer when i was landed with having to create a database for use at work. We have been using it with no trouble for a few months now but earlier today I noticed that when I used the filter by form option in the advanced part of the...

According to the properties tab for the placement history subform, its record source is tblWorkerClient and its the combo box for trade within that which is the one I'm trying to do as in your point 6 of post 7 in this thread!

So the worker ID from the workertrade table and the two fields in the trade table are the ones I need to get for the row source trade name in the placement history with the control source as workertrade ID? That's the one bit I have got left to sort out now (hopefully!)

ok now I'm even more confused as some of our workers have several trades that they are registered as doing (maybe I should have put some dummy data in to show that), so I thought that would need a many to many relationship between worker and trade?

Thank you very much for taking the time to look over this for me! I think I understand most of what you are saying, the only bit I'm a bit stumped on is the using two tables as a row source for trade name in the Placement History subform as the wizard didn't give me chance to select a second...

Ok, I've gone back into the tables and removed all the look up fields and tried to get them into the forms as combos instead. I've put in some dummy data and have also added an extra table into the query which now doesn't show any data at all! Even if I put the name of a county which I know is...

Thanks for those links. I will go and remove the lookups from the table now and feed some dummy data in. I had copied the one that I was using at work today with some data in to my memory stick and brought it home but for some reason it won't open on my home pc. Possibly because my machine at...

Hi, I didn't realise that I could get up more fields than the number of parameters passed from a form. The SQL for the current search query is: SELECT tblWorker.[Worker Name], tblWorker.[Town/City], tblWorker.County, tblWorker.Landline, tblWorker.[Mobile(s)], tblWorker.CSCS, tblWorker.CV...

Hi there I'm hoping that someone can help me with this one. It's the first time I've had to create a database and I know zilch about coding so tried to do everything using the wizards within Access 2007 and a book from the library (some of the code from which wouldn't work when I tried to use...

Hit a slight problem now as it seems to think that I have to answer questions about all those criteria before I can open the form which is supposed to control it all!

Thank you Taruz, that set of coding has saved fine without any error messages coming up. Hopefully I'll now be able to get the rest of this database finished before I go back to work tomorrow.