Search results

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

Thanks KK. I take the point in your post script and have decided finally to go that route. It does indeed seem an easier way to travel. Thanks for taking the time to give your thoughts to my question. Julie

Hey KK - thanks for your reply. I understand a union query can only involve fields from two tables. My union query was successful in pulling down two fields both named BodyArea from two separate tables. What I now want is also to introduce a third table to the query which has a field for...

The Union Query worked but now I am faced with how to include the name fields from the main table in this query. I understand a Union Query can only be used to combine fields of the same name and data type in different tables so I assume I cannot add more code to this Union Query in order to...

Thanks Pat. I'm going to try a Union Query on this one. Lot of fast learning curves in Access!

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

Jack - your suggestion was the perfect solution. Many thanks :-) Julie

Jack, Thank you for your prompt reply and for being willing to help a novice. After I created the 3 new lookup tables I changed the Row Source for the combo boxes to the new tables (there are 3 separate combo boxes referring to the 3 new lookup tables). That seems correct. Yes, I used the...

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

Thank you Rich. Appreciate your reply.

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

Thanks Rich. I'm totally new to Access but what you said makes sense. In deleting the original 3 column lookup table and making 3 separate lookup tables instead, I have created a problem in Form view. I changed the RowSource ppty of each combo box to each of the relevant new lookup tables and...

Thanks Jack. I have bookmarked the site you kindly referred me to to take a look in depth when time allows. I actually copied the database structure across to a new blank database to see if gaps were still created in the lookup table . Yes, I am using command buttons to open a form to input new...

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