Search results

Hello everyone, I have a table with data on household members and their relationship to the head of the household. Each record has a field ABHID which comprises of the AREA CODE [2], BUILDING NO[4] and HOUSEHOLD NO[2] eg. 02014401 where AREACODE="02" , BUILDING NO ="0144" and HOUSEHOLD NO...

Hi Everyone, I need some help with this problem. I have a form with which I enter patient info. Patient will normally visit once per year. When a patient visits, I would like to enter the patient's ID on the form and then search the DB for an existing record. If the patient already exists...

Hi everyone, I'm wondering whether this report can be done, if it can, I'll appreciate any help if getting it done. I have a table with approx 10,600 records of patients with cancer. The fields are - County, Village, Year, Site There are about nine (9) counties, each with up to 15 Villages...

Hi everyone, I'm trying to add a record to a table using the SQL INSERT statement, but somehow it's not working.. I have declared in a standard module some public variables, which are populated during data entry. After the data entry, I want to save a record using the public variables, but...

hi everyone, I have a table with persons age and location and I want to generate a report of all persons by location and age group. The age groups are 0-9, 10 - 19, 20 - 29..., 90-99. The location codes are 10,20,30,...90,99. Any suggestions? Many thanks Will.

Hi everyone, I need some help with this problem. I've got two date fields - DateSent and DateTstReslt I have a field on the form that stores the no of weeks between the two dates. If there is no entry for 'DateTstReslt' then today's date is used. What I would like to do is to ensure is that...

Hi everyone, I'm working on a form to accept patient's medical info. One of the question on the form is 'whether an examination was done (Yes/No), if no, then a reason has to be entered why the examination was not done. The field - ExamDoneYN is of data type YES/NO. I created an option group...

Hi everyone, I've got some check boxes on a form which includes one for 'Other'. Whenever the 'Other' check box is checked (selected) I want to display a text box in which the user can specify what 'Other' means. This works fine with the following code:- '**** Private Sub MHOther_Click()...

Hi everyone, I have four tables (all linked by a unique identifier) which I populate via data entry forms. I would like to give the user an option of making changes to the data by entering the unique identifier and displaying the specific record (from all four tables). Is there any way to...

Hi everyone, I have placed the following Code in the OnOpen event of a form to check if any records exists. If there are no records, then a message is displayed. Private Sub Form_Open(Cancel As Integer) DoCmd.SetWarnings False If Me.RecordsetClone.RecordCount = 0 Then MsgBox "Sorry!!! No...

Hi Everyone, Here's the situation:- I have a patient record with a specific consultant assigned to the patient. In some instances, the patient may request a different consultant. What I want to do is to allow the user to change the consultant and to save details about the change e.g. file no...

Hi everyone, I know that this is supposed to be a simple task, but my brain has fallen asleep on me. I've created a combo box on a data entry form based on a table with 2 column (code,desc) On the form, the desc is displayed but the code is stored in the underlying table. When displaying the...

Hi everyone, I'm working on developing a patient registration system which consists of 6 tables linked by a patient file number. The data entry form has a main form and 5 subforms. I got no problems moving from the main form to the first subform (frmpaddr), but I'm having some difficulty in...

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

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...

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...