Search results

Good morning everyone. I'm actually use a simple function to export some data trough a selection query to a CSV File. The problem is that when i export the data from my table (trough query) in the CSV output file i have some values (long numbers) who change. See please below : This is part of...

Good afternoon everyone. Having a FrontEnd MS Access DB (shared with users) with one linked ODBC Table (located in another separate database) I'm looking to a function who can reconnect that ODBC Table when the end user doesn't have any DSN. This because I would like to avoid to create a DSN on...

Good morning everyone. Actually I have a need to send an automatic e-mail to users whenever a field of a specific table is change. The table is part of an external application and is linked to my access database trough ODBC connection and users may change that field trough that application. I...

Good morning everyone. Time to time I face with the Error 3061 Too Few Parameters Expected 1. I tried to check around some solution but it seems i'm not able to solve. Below is my code. Mainly I have a table with a list of queries name (previous build based) and for each query i need: 1. Create...

Hello everyone, I'm Leonardo, working in an Oil and Gas Company in Oman. My role is to deal with the Computerized Maintenance Management System (SAP) and mainly in the data verification, QAQC, etc. To do this, very often, using my MSACCESS (and VBA) knowledge, i develop small tool which allow...