Recent content by thekey

Hello Users I was wondering if someone could help me solve an issue I have with Access 2007. I have created a database with approx 10 tables. I have also created a form with Tabbed pages and after days of work thought I had finally finished. I was wrong! The tables are all linked with a...

Hi Mailman I have managed to do this with your help, thanks. The only problem I am having is that my subfrom is in a tabular layout and when I go down to the next line and select another option the dependent fields disappear even though the line previous matches the visibility criteria. Is...

Hi Mailman Thank you for your message. I'm not quite sure how to go about doing that, I can add text boxes to forms but not sure how to make them selectively visible. Also where will the data from these text boxes be stored?

Best way to create a dependent field?!? Hello Users I was wondering what the best way to create a dependent field in a form was. By way of background I have a subform in which users select one of approx 15 options from a list. If the user selects one option what is the best way to make...

:confused::confused: Hello users I am in need of some help with an issue. I am using MS Access 2007 to create a database. I have tried to respect good practices and separated data into a number of tables. My main table has a primary key specified as person_ID which I want to use to link in...

Hi James Thank you very much for your reply. I have found your advice very useful. I just wanted to clarify something. In my database so far I have a table with the fields recordID, firstname, surname etc. I also have a second table with the procedures listed which is what I was using as a...

Hello users I need desperate help with a project design issue. I am creating a database to log data from a survey. In this survey for one of the fields there are 15 possible procedures which can take place. There can be more than one selected. What I need to achieve is to be able to design a...