Recent content by FlyingMonkey

I have set up a split database and it seems to work perfectly. I have created a report on each users FE and this works fine. It inputs their own contact details on the report. This was done manually before sending the FE to the user just using ="text here" in the design of the form. What I want...

I feel like I nearly have this working how I want it to. I changed some options on the Property Sheet. I changed 'Limit to List' from 'Yes' to 'No'. To do this I had to have both columns to the same width. I also changed 'Show Only Row Source Values' from 'No' to 'Yes'. This now has the...

Hi I have a ComboBox which looks up the records in a query. The query contains the names of current employees. The table upon which the query is based lists Employees and their start date and finish date. The Query is based on finish date being Null (ie they're still working here). In the...

Thanks again. I've come up with another little problem. I have switched my combo lookup to a query so that only current staff will show in the drop down box. I used a Yes/No data type to distinguish this. However, when a staff member has left the section and I untick their box, their name...

Thanks for your help everyone. I now have the combo boxes on the form instead of the table. Makes much more sense. Only the detail shows on the form and only the key shows on the table. My colleagues would be frightened if they saw the table :-) I will be hiding the tables so everyone will...

Thanks again. I've just recently earned the MOS in Access through a Diploma course I'm doing, which included systems design. I'm still a bit of a novice though. Haven't implemented my Database yet. Want to make sure I have it right first. I've had a few trial runs and I'll set it up as you...

Thank you. The reason why I want to do it this way instead of using a code as Primary Key is that at the moment we're using Excel and it's what people are used to working on. They will want to see all the information on the form. If I used the PK in the main table would name (rather than the...

Hi First time here and I have a query about a Database I'm designing. I'm designing a Database for my section in work. I have Normalised it already. The Database is to hold information about the recruitment of hospital workers. This is not a recruitment system. We already have one in the...