Search results

I have Access97 and have a form and subform set up to record surgical operations for patients. I have an autonumber primary key for PatientID. I noticed when entering data on the Form recently that the record number on the navigation button of the form was one number less than that showing for...

I'm using Access97 and have a subform within a form. The main form has navigation buttons in the Form footer which I can clearly see once I switch to Design View. However, I am unable to see the form footer for the subform as in Design view it just shows as a white rectangle with the name of...

I have an Access97 database listing surgical operations for patients. Most patients will have only one operation but a few will have multiple operations. I want to know how to set up a query to ferret out those patients who have had more than one operation. There are two tables, one for patient...

Hi. I'm a novice but I managed to construct a MS Access97 db which is working well as far as inputting data. However, I have a problem with querying. The db is a record of patients and their surgical operations. The construct is a subform (continuous) within a form. Querying works fine if the...

I have a database of surgical operations. I wish to discover which patients over 2002 had the most surgical procedures done on them - say the top 10 patients. I think this query will have to be worked on the autonumber Patient ID number as it is the only column that shows repeats. eg. Patient...

I have a text box named Side in my subform. I have a validation rule "L" or "R" or "Null" attached to this field. My aim is to force users to only enter L or R, but I also want the option of closing the subform without having to make an entry in the Side field. On this account I tried adding...

I am new to Access 97 and have created a database for patient operations. I am now entering data on a test basis. When I add a new record for the same patient (many patients have more than one operation), the same patient is given a new ID number each time. I know I can always get a patient’s...

I have a query showing 3 tables. The first table has an autonumber primary key and the other two tables are separately but both related to the first table on this key. I have the same field in the 2nd and 3rd tables and when I query this field from both these tables I get no results but if I...

Hi - Because of a problem I was having it became necessary to split 1 lookup table into 3 lookup tables. I deleted the original lookup table and created the 3 new tables. Now when I try to replace the command buttons in my Form to open input forms based on the new lookup tables so I can enter...

Kind people - I'd like to ask how to get Access97 to recognise that I am entering a name in a new record that has already been entered previously. My DB is for surgical operations and most patients will have just one operation but some will have multiple operations. Joe Bloggs might have been...

I have 3 command buttons on a form, each relating to a combo box, which opens a lookup table consisting of 3 columns. Whenever I enter a new value for a combo box via any of the command buttons it all goes well in the Form but on checking back to the lookup table itself, there are blank cells...