Recent content by Jen_RT

Spent hours looking for this solution. Cheers :) but do you know how to get the form to automatically centre? I have tried autocentre = yes but it doesn't work. :confused:

Thanks. Thats what I thought. It worked a treat. :) I shall just add the other necessary fields in another query built on this one!

Just incase the maintenance records have not been entered as soon as the maintenance has been conducted, or if an record was forgotten about and added at a later time, is there a way to search for the most recent date for each equipment ID. I am trying to design the database so that it is...

The problem is I am going to use this query as the basis for other test criteria so ideally I would like a single list of Maintenance records, but with only the most recent date for each equipment ID. (Sorry I should have put that in my first post) If I make the sub query, can you still...

I have two tables that are relevant to the query I would like to perform. The important information in each is as follows: Equipment_TBL: with several fields but the only one of importance is the primary key - Equipment_ID Maintenance_Record_TBL: with fields Maintenance_Record_ID (Primary...

Worked perfectly. Thank you very much for all your help. :)

No. The queries are different. One is e vs e and the other s vs e. Sorry, my naming of them doesnt make that very obvious, but they do append to different tables.

Ok. I have created it on two separate on click command buttons. The first establishes station vs equipment, with the following code: Private Sub Command77_Click() MsgBox "You must only establish compatibility relationships once" If DMax("Equipment_ID", "Station_vz_Equip_Compatability_TBL")...

It worked an absolute treat. Here is the code I used if anyone is intereted: Private Sub Command77_Click() MsgBox "You must only establish compatibility relationships once" If DMax("Equipment_ID", "Station_vz_Equip_Compatability_TBL") >= DMax("Equipment_ID", "Equipment_TBL") Then MsgBox "The...

Thank you for your quick response. I just did a quick check and I have one duplicate record set in there. Sorry. I will fix this and carry on with what you suggested. Cheers :)

When I try to make the equipment ID and station ID primary keys it wont let me because this would create dupliates. My table essentailly looks like this at the moment: Stat_vs_Equip_Compatibility_ID, Equipment ID, Station ID, (other fields...) 1, 0001, A 2, 0001, B 3, 0001, C 4, 0001, D 5...

That makes more sense to me now. I will research vba and make the fields primary keys. Thanks for your help so far, I will let you know how I progress. :)

I already launch my macro from the on click event procedure of the form. It does the following: 1. displays a message box telling the user they should only perform this action once. 2. opens query that checks for the last equipment ID added. 3. opens query that appends the equipment ID...

Thanks. Do you know if there is there any way to do this other than using vba? I'm not familiar with coding at all and have been using macros and queries.

I have a table (Equipment_tbl) where I have several fields, with the primary key being (Equipment ID). I have designed a query to find the last equipment ID added (newly added equipment ID). I then want to append this newly added equipment ID to a compatibility matrix table which compares each...