Recent content by bachgen

Clarify Can you clarify what you mean by use unbound forms ? Thanks.

Hello, I have designed my db with an address table as a large amount of the members will be living together. The problem I have is when entering new members how best to design/code the form. I was thinking of getting the postcode, a search returns a list of addresses with that postcode. You...

search Pat, Thanks for your reply, i had done some searches before putting together the post, done of which seemed to return a post regarding the list view that would show the icon and text. I will keep searching.

I have seen someone design an interface that used a list box configured it to show large icons with text as the navigation. It appears that this can not be done with a list box does anyone know the control that would allow this in Access. Cheers.

Banana, Thanks for your reply. They want to ensure the data behind the person is deleted when they leave. I am doing this for a local charity and they want to make sure we are not keep data when volunteers have left. Even after a volunteer who was a mentor has left I want to be able to say...

Working ? Hello, I have run the db and created a new entry, there was no evidence of any previous records data in any of the text boxes I could see. Can you provide the tab and text box names that you are having the issue with, as I can not see an issue here. Bachgen

Rabbie, thanks for your reply. I have been thinking and this method would cause an issue if that person was deleted from the system ?!? maybe it would be better if it was just text then. Does anyone know how is this handled in other db's ? Bachgen.

Hello, I have a table which holds information about people (name, address, dob, joined, mentor). The problem I am having is that the mentor fields will be another person in the people table, I am not sure how to achieve this. Can you help. Example James, Mary, Luke are all in the people...

Address table ? I have been looking around and I have seen that some designs use a separate table for the address. Why would this be done is this something I should incorporate. Thanks.

Address table ? I have been looking around and I have seen that some designs use a separate table for the address. Why would this be done is this something I should incorporate. Thanks.

Anyone with any thoughts on this ?

To help achieve this I have added a period column in the roles table: role id PK, auto name * period description I have set this as a optional as some roles do not have a limited period. What are your thoughts has anyone got a better method of achieving this. Regards

Replies Thank you all for your input, can I take it that the role status and links tables are all ok. Some of the roles have a default time period (4yrs) then the roles can be re-assigned or a new volunteer undertakes this role. I am not sure if this should be contained within the database or...

Hello, I am looking at creating a database for a charity, to help them maintain there volunteer information. The database will need to hold information about the charity, volunteers and there roles, language and status. This is the db design so far. Branch id PK - charity number name * house...