Search results

Do you always use the NZ function?

Ok, I just found the code: str_SQL_finale = "INSERT INTO DSP_RDV_t_ListeContactsJamaisVisites_Temp ( ID_Contact, " & _ "Nom_contact, Prenom_contact, Nom_structure, Fonction, Specialite, Profession, Departement, " & _ "Secteur, Case_du_plan, Adresse_1...

Hello arnelgep, Thank you very much. Very interesting how you create the strAllCriteria, will work this way from now on. It works fine for the insert into part, but I think I forgot one part: I would like to remove the rows in which the ID_contact value equals the...

Ok, here is the file

Hello, I am stuck with a bad result of a query sent form a VBA procedure: here is the file: https://we.tl/t-MmO8fV1Stq it is in the "DSP_RDV_f_ConsultGestion_HistorRdv" form : you need to select items in the 5 list boxes, then click in "Jamais visités" and send the procedure by clicking on...

Ok, I see a way clearer picture now: I will use Access native queries for single-value critera filterings, and Sql code in VBA procedures for other cases. Well, that was very useful. Thanks a lot again. Etxe.

A last question Paul, very similar: I use forms and subforms always following the same pattern: - Something like 10 listboxes in the form : the results are passed into a parameter in VBA. - Then I run a SQL query in a VBA procedure using ADO: the parameters feed the WHERE clauses. - The query...

Ok, thank you very much. Etxe.

Hi everyone, I will have to put the BE of an application in SqlAzure. What will become the "native queries" in the forms, that allow to quickly populate combo lists form the property (see below) window using values of other controls? Or is it necessary to use Sql queries in VBA procedures? Many...

Very interesting thread indeed, thank you for sharing. Basically I use staging tables to expose "explicit information" (names, surnames, descriptions etc..) out of normalized tables (almost only foreign keys in the permanent tables, not understandable by the user). Since I have to write join...

Hello everybody, In order to allow the user to check, modify and also to prevent bad consequences of an error, I often create an empty copy of the table I want to populate with a form. Then I create an INSERT TO query with VBA and sql code that inserts the data form the intermediate table into...

This information was written here (french forum). You don't share that point of view obviously, I am an occasional access user and you know what you are talking about, I trust you. What would you recommend then? What would become the VBA code using ADO recordset and connections? Thanks. Etxe.

I think that my explanation made things harder to understand, I hope that my problem is not that complicated! I will try another way: until I migrated the tables to sqlExpress, I used things like " Set objConnection = CurrentProject.AccessConnection", and it worked fine. Now the tables are in...

Hello DBguy, I need to stick to ADO indeed, as this back-end will move to Azur. This is one thing I have been told consistently, if I wanted to have good performances with a SqlServer BE and even more with a cloud shared BE (Azur), pick ADO rather than DAO.

Hi, I need to update the connections of my VBA code, in order to rebuild the link between Access FE and SqlServerBE. To do so I create public variables, and there values are assigned when Access opens (more precisely on the load event of the presentation form) (see section A at the bottom of the...

I will, thanks a lot, and see you around. If I find anything interesting during the process (technical issues, economic model etc...), I will feed this thread. Etxe.

Hello again, I just spoke with a Microsoft "specialist": we will have to migrate the SqlServer tabels and queries to SqlAzure, no way to use SqlServer tables "stored" in an "Azure cloud". As we have a limited amount of data, it is quite cheap to use SQL Azure: not even 10€ per month (back-up...

Hello, In the case I use Azur, between SqlServer BE stored in Azur or an Azur BE, which one is the most efficient? For a terminal service, where can I find some documentation please? Will be considered as a "user" every person that will use the Access Front End? (Since I have to consider all the...

Hi Isladogs, I carefully read the whole thread you sent before (citrix-team viewer etc..). There is no way to use terminal services or Teamviewer, as it will be necessary to work in the same time on the app. Azur looks very promising actually, and as the size of the data is very small, it...

Yes, each user will have to use the same BE. There is some money, but very little. What are you thinking about? I found a very interesting article here, combining front end Access, BE SQL server shared on Azur: https://www.fmsinc.com/microsoftaccess/cloud/link-to-azure-sql-database.html