Search results

for instance: .pdf, .dwg, .dsd, and office files

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

I was sure I had already tried, but no: this works! Many thanks. Etxe.

Thank you: an error message pops-up:

And this string in a query gives me the results I need

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

Thanks a lot Isaac, Doc, Gizmo and Paul. I might have a go with Excel Powerquery as well, using this (in french): @Isaac, I am very interested in sharing about your "inspiration", we are on it as well, I keep you people updated with our progress. Have a lovely day all. Etxe.

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

ok, it works well, many thanks! Etxe.

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

Steve hello, Many thanks for thinking about my problem: we did create views, but we have a problem with some parameters ("cache" in french: https://mariadb.com/kb/en/server-system-variables/#table_definition_cache) that prevents us from reading datas in views: in other MariaDB bases we dont have...

Thanks for your detailled explanation. How do you get a back up af the existing Azure DB? Do I have to open a ticket and will be charged?

Hi Minty, Yes, I need to change some connections between tables, to modify some keys, remove a couple of tables, test it locally and migrate again to SqlAzure. Thanks a lot. Etxe.

Ok, I don't know, but I check right away. Maybe @Minty would know something about this?

Hello DB Guy, I am not sure to understand: is it a native MSAccess function?

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