Search results

Thanks so much!! Curtis, Thanks for the info. on the table relationships, I will implement these changes shortly. However, the original problem is still there i.e. the tab form is not allowing me to enter data, can you check it for me please? Once again, thanks.. Will

Here's the form Hi Curtis and Others Tabbed form attached. Can you advise on :- 1. How to get control to move from the last field in one page to the first field in the next page? 2. The relationship between the tables. Is it ok or do I need to change it? Many thanks Will

Problems with the Tabbed Form Hi Folks, I tried following the instructions posted but I've hit a snag, what have I done wrong?? Here's the situation: I've got 5 tables linked by a patient Id. I created a query to select all the fields from the 5 tables. I then created the form with 5 pages...

Thanks so Much!! Thank you so much for your responses. I will give it a try and let you all know how it works out.. Once again, many thanks.. Will

KeithG, Thanks for responding.. Do you have a sample that I can work with? Will

Hi folks, I've got a questionnaire which has about 80 fields in 5 sections. all sections are linked to a person Id - which is the unique identifier. I'm thinking that a tab form is the way to go in putting this form in Access in order to facilitate data entry. Is this the best way or is there...

Hello everyone, I'm converting a paper medical screening form to electronic format to facilitate data entry of screening records. The form consists of approx. 76 fields, all linked to the patient ID number. So far there is the main form with four subforms. The main form contains the patient's...

Hello everyone, I'm converting a paper medical screening form to electronic format to facilitate data entry of screening records. The form consists of approx. 76 fields, all linked to the patient ID number. So far there is the main form with four subforms. The main form contains the patient's...

Hello everyone, I'm working on a data-entry form and would like to restrict the data that I enter on certain fields to alphabetic characters only i.e. a -z, A - Z and Spaces. Is there any way I can acomplish this?? Many thanks in advance. Will

Thank You Hi mhartman, Your code worked wonderfully.. Thanks so much Appreciated. Will

Hi everyone, I have a form with a field named TREATMENT with the following options :- 1 Cryotherapy 2 Radiotherapy 3 Chemotherapy 4 None 5 Other (specify) If the 5th option (Other) is selected, the user is required to specify what 'Other' represents. I have created a combo box with the...

Hi everyone, I have a form with a field named TREATMENT with the following options :- 1 Cryotherapy 2 Radiotherapy 3 Chemotherapy 4 None 5 Other (specify) If the 5th option (Other) is selected, the user is required to specify what 'Other' represents. I have created a combo box with the...

Thanks Lisa, I'll try it and see how it works Appreciated, Will.

Hi everyone, I'm building a database that will allow me to enter medical information about patients. On the present form (paper) one of the question asks about the medical history of the patient with 7 available options( Diabetes, Cardiac, HIV etc). The 7th option is 'OTHER' and the patient is...

Hi everyone, I'm building a database that will allow me to enter medical information about patients. On the present form (paper) one of the question asks about the medical history of the patient with 7 available options( Diabetes, Cardiac, HIV etc). The 7th option is 'OTHER' and the patient is...

Thanks so much guys, It's working now. Much appreciated Will

Many thanks RG I just can't seem to figure out why it's not working.. Dunno if its a marco prob. though.. Take care, will

Here the Db Hi RG, I've stripped down the DB to only the table and the form. Hope you're able to help. Thanks Will

Hi RG & GHudson, Thanks for responding to my question. The record source for the form is a single table and 'Allow Additions' is set to 'Yes' Any other suggestions ? Thanks again. Will

Hello everyone, Can anyone help? I have a data entry form via which I want to add records to a table. However, when I've entered data in the last field, the cursor remains there and the system just beeps. I added a command button on the form to go to a new record but when I click on the button...