Our invoicing system is built in Microsoft Access and organised as a classic relational database (customers ↔ invoices ↔ payments). I now need a compact piece of code that talks to the Ifthenpay API so that, whenever we create an invoice, the application automatically requests a Multibanco entity/reference pair and writes it straight into the appropriate table. Essential flow • The routine receives InvoiceID and Amount from Access. • It sends the request to Ifthenpay, handles any required authentication, and retrieves entity, reference and validity data. • The response is stored in our Payments table and linked back to the originating invoice record for future use. I only need the “generate reference” step; tracking or auto-updating settlements will be added later, so please keep your code modular enough to extend. Deliverables 1. A well-commented VBA (or compatible) module ready to import into our ACCDB. 2. Any helper libraries, connection strings or JSON helpers required. 3. A short setup guide showing where to paste credentials and how to test with both sandbox and live endpoints. 4. Proof of concept: a sample call that creates a reference and shows the new record inside the database. Acceptance criteria – Successful API call returns valid Multibanco reference for at least three test invoices. – Data persists correctly and survives application restarts. – All external dependencies documented. If you have already integrated Access with REST APIs (especially payment gateways), this will be quick work. Let me know your approach and timeframe—once I can run your demo inside a copy of our database, we’re good to go.