Search results

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

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

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