Search results

OldSoftBoss I didnt see your reply before my last post. Okay. I see now that I cannot rectify this situation. Thank you both for your help. Julie

Thanks for answering, llkhoutx. As my Form stands, the PatientId numbers and navigation button numbers do match all the way through to where the navigation button shows 487 but the PatientID number is 488 (the record for PatientID 487 no longer exists - I have checked this in TAbles). From...

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

Sorry guys, I've just solved the problem. Julie

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

ANGSHU - Many thanks. What a simply wonderful solution you provided me with. My db is set up just the way you suggested in your second post. I ran the wizard to find the duplicates in the Patient ID field of the Operations Table and once this was up I simply added the Patient Details table and...

Pat, Thank you for your reply. When trying: Select PtID, Count(*) From TPtDetails Where Count(*) > 1 Group By PtID; I get a message saying "Can't have aggregate function in WHERE clause [Count(*) > 1]. I'm a newbie and am not sure what this message means. Julie

Sorry, I meant to mention re my question above, that when I run a query to show me the patients who have had multiple operations, Access gives me names and the total number of operations they had and, if I had the Procedure field to the query, the FIRSTLISTED type of operation. What I want is...

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

Thanks so much for replying Seth. I apologise but I made a wrong assumption about a particular query outcome. On re-doing the query all is well. Thanks again - Julie

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

No problems, Shay. Thanks for your reply and I hope you dry out soon! Julie

In case it helps anyone who is not familiar with SQL I got this done using the grid. I dragged firstly the name field to the grid, then the Patient Id field. I clicked on the Total button in the toolbar which inserted 'Group By' in the Total cells. I left this stand under the Name field but in...

Thank you for replying Shay. This is what I did firstly: I changed your code to read exactly as my table/field names read. I then copied and pasted the code into the Criteria area of the grid in the column including the Field of PtID and the Table of TPtDetails. I got a message:The synax of...

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

Probably the easiest would be to use Excel and Word combo. Create a table in Excel that contains the text you want on the ticket. Then copy that info down as many rows as you need to print. Add a column and use autofill to fill it with a sequential number. Save the Excel sheet. Use Word's...

Thank you both Fizzio and Pat. I used your method Fizzio with perfect results. Didn't know you could do that. Thanks so much. Julie

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

Thank you both Fizzio and Rich. Rich - your description sounds like just what I need but I'm not sure how to go about this. Would you be able to spell it out in a little more detail for me please? It sounds like you are talking about two separate boxes here? Thanks - Julie

Thanks for your reply, Pat. What you have suggested is actually how I have my tables set up. I have an autonumber primary key called PatientID in the PatientsDetail table and have used this as my foreign key in the OperationDetail table. Problem is that Access97 doesn't recognise when I am...