Recent content by Hackney

I did something in the start up options with this database. Now when I open it I can't get Access to function as normal. There is no right click, no tool barr or menu. Any ideas?

So I have nearly finished my database and I want to give it to people so they can start entering data into it via the form. Is there a way to make it so when someone double clicks on the file in Win Explorer it only opens the form for data entry - no access to the tables etc. Can this be done...

Thanks, will check it out later. ;)

Ignore this one please.

They won't have an end date as they are current people. Maybe I could just have a start date and calculate it from current date to start date. But some clients maybe be seen by the team for a few months then 'closed' and then re-opened so they would have two start dates. I just want the user...

Do you think there is any need to have seperate table when the relation ship is 1:1?

I have three tables. EAch has a field called ID that is an Autonumber that is the primary key. When I enter data via a form each record has a different ID across the three tables. Does this mean they are not linking up correctly? I have attached my databaset if that helps. Thanks.

I have a field that is: Current length of continuous allocation of Care Co-ordinator. ( years and months ) Ideally I would like to have two drop down menus - one with years and one with months. Would I have to have two fields in my table - one for years and one for months or can I have one...

I am having more trouble with the old database I am trying to make. Can someone have a look if I attach it? I don't think the ID fields in each of the three tables are working togehter. Shouldnt they be the same ID number of each record for that person across the three tables? Thanks.

I'd rather have check boxes or even radio buttons to be honest. Is this not possible?

But doesnt a combo box only let you make one selection?

My First Database Hi all. I need to make a database for work. I used Access many years ago but have forgotten most of what I knew. I want to make a form for entering data into the table. For one of my fields I would like the user to only be able to make a selection from a pre-defined list...