Search results

Good morning, everyone. I have a form which I use to store some selected files (any type) in a table. In the form there is a button which allow me to open "Explorer" and select the file, the code i use in the "Click" event is the following: Me.LinkName.SetFocus RunCommand acCmdInsertHyperlink...

Good morning, everyone. I'm little on trouble and i need your kindly suggestion wherever is possible. This is the scenario: I have a database which has some tables linked to some csv files located in my C drive (specifically C:\Local). Up to now all good. The original csv files are daily...

Good afternoon, everyone. Reading in the messages, I understand that to bypass the issue refer to the Excel importing procedure in Access (who checks the first 20 rows to decide the field type in the target table) is to use a CSV file. Actually, I'm not in the condition to ask to the user to...

Hello everyone, i have the following problematic and i would like to know if someone can propose a solution either with a query or even with vba. I have the following table: and what i need as output is the following? In few words i should have a new table (query) which return for each Key...

Good afternoon everyone. I have the following question please, if you can support me. I have to create a query which return the differences in one field between 2 tables. I give the example hoping i'm clear: I have Table-1 as follow: EquiMan EquiModel number Object type Class Characteristic...

Good morning everyone, I have the following case: This is my Original Table: TASK_LIST_GRP TASK_LIST_COUNTER W1 W2 W3 W8 M1 M2 M3 M4 Y1 OMBIRD 01 X OMBIRD 01 OMBIRD 02 X OMBIRSQ0 01 X OMBPCRQ1 01 X X...

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