Recent content by Greycom4

Thanks CJ for the detailed explanation, I was using dates without the time in my testing to simplify things and completely missed the crucial time part of the process. So I understand the limiting the data in the query results and I will get to testing this evening. Since I have a number of...

CJ, your response time is phenomenal....but how can this work If I have more than one import in a single day meaning multiple holder details with the same date stamp ending up in the junction table, what am I missing here ?

CJ, I have implemented the timestamp process in my junction table to trigger a snapshot in time of when the data was imported. During my initial testing I have used the criteria of >=Date() -1 in place of which works. However It is possible that I can receive multiple holders Imports in one...

Thanks CJ for your advice and guidence. I would like to try both suggestions, however I do have around 6 junction tables that would then require setting up multiple forms and Session Tables. So in the interim I will go with the Are you suggesting I would require to change the manually at each...

CJ, I was wondering if you would consider looking at my problem once more, I know your busy as I see lots of post from you on this forum. I am really keen to get some help here as I have many junction tables that I need to import in to for this database. If i can just get this one working it...

Thanks for your support and quick responses, also I acknowledge the 'school boy error' around the field name spaces :o.I have completed the changes and run the query which removes all the non matching records in the junction Table which is great. Unfortunately this also deletes any other records...

Thanks CJ London for reading my post and then replying. I think I understand your query which is brilliant, but it's giving me a syntax error. You are absolutely correct when you say my unique ID is effectively a combination of the HolderPK and the SystemPK. Have I understood your query...

I have a regular import from an Excel sheet range using the TransferSpreadsheet method which populates a ‘Holding Table’ and then this information is used to update and append to a Final Junction table. During each import there is only ever one Holder (PK). Sample Data in Final Junction...

Thanks Pat understood. I was having real performance issues with the site over Thursday and Friday and did mean to delete one topic over the weekend. Cheers

Re: Access 2007 - Multiple Many 2 Many Relationships Thanks Catalin.Petrut for your response. I am going to use your suggested table setup to work through some examples. I have read elsewhere to avoid many 2 many table relationships, but this seems standard design in most relational databases...

Thanks Nigelh77 for your reply. I have will take on board your comments and investigate the Many 2 Many table position. I have already spend some time around the 1NF, 2NF and 3NF and that was the original reason for posting as I thought the design was not properly normalised. Seems like I have...

Access 2007 - Multiple Many 2 Many Relationships Database to manage resource at a number of buildings. Resource is very similar in each building, for example Computer Model (A) Computer Model (B) Phone Model 1 Phone Model 2 Desk Printer The challenge is I would like to track up to 200 desks...

Database to manage resource at a number of buildings. Resource is very similar in each building, for example Computer Model (A) Computer Model (B) Phone Model 1 Phone Model 2 Desk Printer The challenge is I would like to track up to 200 desks in 10 separate buildings. These buildings will...

Thanks for that. I eventually managed to get it working.

I have struggled with this for so long now I hope someone can help. I have a form called frm_Collections which is run from the query (qry_Collections). When I type into the Reg field in the Form I would like the user to know if the Reg details have already been used in a previous record. The...