Search results

Hello, In one sub-form, I want to sum-up all the values of a particular calculated field ("PrixTot"). Therefore I have created a text box, put it in the foot part of the sub-form, and populated it with the Sum function: =Sum[(PrixTot]). But it gives me an error value "#Error" I cant populate it...

Hello all, One client asks me if we could help them operate some Firebase databases: they are huge: I have tried tiding them up to Access or Powerpivot, but it chokes before ending. I guess the queries would be very slow, or even wouldn't ever return results. Some of you people have some...

Hello everyone, I have folders and subfolders that contains different files: pdf, autocads etc.. Before I move one folder, I need to make sure that all the files in the folders are closed, and to know who is the user that hasn't closed his files. Would you have any suggestion please? Many...

Hello everyone, In order to import datas form an excel file, I use an intermediate Access, and the code below: it works fine, except when the field names contain special characters. So i would like to change the field names while importing: what would be the best strategy? Creating a data set...

Hello everyone, I would like to filter a form with the following string: the parameter is at the right format (string), I ran a few tests with constants, and it works: May some help me please? Many thanks in advance! str_pub_dpt = "SELECT DISTINCT t_CrRdv.Departement" _ & " FROM...

Hello everyone, I would like to know if some of you have already used a Googlesheets back end? The context is: - 10 users all over the world+1 admin - no way to use a server or an SqlAzure device - users never change the datas in the tables, the admin person does. They use queries only, that...

Hello all, I had a general question: compared to a Access FE-SqlServer BE model, what are the mains challenges of using MsSql or MariaDB as a BE? For exemple, are there any functions that need to be adapted ? Many thanks in advance. Etxe.

Hello all, I would like to display the different columns of ListBoxes permanently, that is to say not only when lists are dropped. When the user checks the form, without dropping lists then, he only visualizes the value of the first column, and he needs to click on the list to check the values...

Hi All, I want to populate an existing query with some vba code, but the compliation shows me an error: I habe been looking for an answer in the forum, but still clueless, any suggestion please? May thanks! str_SQL_finale = " SELECT t_ListeContacts.ID_Contact...

Hello everyone, I created an Access FE/Sql Azure BE tool that works well. I would like to improve the data model, so my question is: how can I quickly and safely"import" both datas and data model form SqlAzure? I could transform each table in a local one, but my fears are: - the links would be...

Hi All, Hi @Steve R. , I have been tryig to use some MariaDB views, but it seems that ODBC doesn't allow to do so. However, tables are perfectly visualized. I tried to find some information in Internet, but nothing successful so far. Does someone have a clue, or could tell me where I could find...

Hello everyone, I use an ODBC connection between a Maria DB and and a local Access DB. Every user has got his own local Access, in order to visualize data. My client seems concerned about this: he wonders how risky is an ODBC connection, and what would be the best way to maximize the security...

Hello everyone, I need to create some directories off several ERP extractions. As far as I can remember, I can use the mail merging system of Word (using labels), but an Access report would be very easy to generate as well. What I am not sure about is wether I can insert some titles or subtitles...

Hello all, I was asked to analyse some data that are in a MariaDB database. I firstly used Powerpivot but as the data model is quite complicated, I wonder if I can use the Access query maker instead (I cant use queries from the MariaDB database). So I have just tried: I created linked-tables...

Hello everyone, With an Access FE-SqlAzure BE application, it happens quite often that an error message appears because the connection atempt lasts too long, or at tleast I guess this is the reason. Sometimes it works perfectly during hours. Is it possible to increase the lag time in the ODBC...

Hello everyone, I want to download datas from a MySql db into Powerpivot using ODBC, and more precisely the connexion string generator included in PowerPivot. ODBC drivers have been downloaded, but I do not succeed. I know that there is another way, starting from MySql, and creating a new...

Hello everyone, I would like to alterate a field, from short text to long text in a SqlAzure table, used via an Access FE. What would be the best way to do so, I don't know if I need to delete and rebuild the relations between the tables. Many thanks in advance. Exte.

Hello everyone, I developped a Access FE-Sql Azure BE tool, that I have already installed on a few machines. It works well, but all of these users had already Sql Management studio installed. Now, I need to distribute on machines that do not have SSMS: is it mandatory to install SSMS, or is...

Hi, I will migrate an Access back end into Sql Azure, but I do need to keep a couple of those at the local level, as I use them to select rows with yes/no fields before sending the data into to the proper table. What would be the best and safest way to do so please? Many thanks in advance. Etxe.

Hello everyone, I have a form called "sf_re_ResultatRecherche" based on a querydefs called "re_ResultatRecherche". This form is included in a form called "DSP_RDV_PREPA_f_CreationListeAppels": the name of the subform in the form is sff_re_ResultatRecherche. When the VBA code runs, the querydefs...