Search results

Hello everyone, I need to delete from "PROJETS_t_AffectationProjetA_Contacts_temp" (7 rows) the records for which two fields match with the fields of "PROJETS_t_AffectationProjetA_Contacts" (2 rows). When there is no matching at all, it works fine (7 records appear) The problem occurs when there...

Well, thank you very much for your advice, I do appreciate. Have a good day. Etxe.

Hello, I found the error: it is not possible to use "execute" with a SELECT query: here is the code that works: str_SQL_finale = "" str_SQL_finale = "INSERT INTO PROJETS_t_AffectationProjetA_Contacts_temp(FK_ID_contact,FK_ID_projet)" & _ " SELECT...

Hello again, I changed the way I handle the query: I use a simple unmatched query on the following fields: FK_ID_contact and FK_ID_projet I created a query-object, called "PROJETS_r_Selection" (the only query of the file) and it works.. But when I put this code into VBA, it still doesn't take...

Hello, I split the query in two, you will find it in the sub "Sub LancerRequetePourTrouverContactsAquiAffecterProjet". This part works just fine: str_SQL_finale = "" str_SQL_finale = "INSERT INTO PROJETS_t_AffectationProjetA_Contacts_temp(FK_ID_contact)" & _ "SELECT...

I will split the sql string in two queries, and will repost, it will be easier to understand

I see, something like DoCmd.TransferDatabase acExport, "ODBC Database", "ODBC;Driver=ODBC Driver 13 for SQL server;Server=*******;Database=****;Uid=***;Pwd=***;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;", acTable, "MyAccessTestTable", "ServerTestTable", , False When this is...

Hello, I need to populate the table "PROJETS_t_AffectationProjetA_Contacts_temp" from the table "Contacts_t_ListeContacts" , in two steps: - firstly, I use the values of listboxes from the form "PROJETS_f_AffectationContacts _Projets" to select only the rows that respect those criteria - then I...

There will be 40 tables at the most in the last version

After uninstalling Office 365, I tried to install RunAccess2016: it works. When I re install Office 365, whatever the way I install it (Click to Run or with the installer), there is no way to choose "Link tables" in the SSMA, or the message "you need to install a newer version of SNAC" appears...

Hello, I have been trying to migrate tables form Access to SqlAzure: I always crash on "SNAC" versions error messages, even though I have the latest one. We have been trying to sort it out with the microsoft guys (SqlAzure and Access people) for three days. I have Office 365x64, the connection...

Hello everyone, I would like to find the best way to modify a table, out of two methods: I usually create a table builinding a string with SELECT INTO and the content of form controls as variables in the WHERE clause, then using this a sourrce for anADO recordset.. Then I use and UPDATE query...

ok, thanks. We will distribute FE copies using sharepoint. Etxe.

We don't have a wan or a lan, we will have only local copies of the FE in every computer. The option compact and repair is activated. Should me put every day a copy of the FE in a shared file and download it?

Ok. Yes, the FE bloating is one of my main concerns. Thank you theDBguy. Etxe.

So this means that we don't have to worry about this matter doesnt it?

Hi, We are several people working on our own FE, and I will migrate the BE into SqlAzure soon. I guess SqlAzure takes in charge the compacting of the BE, but I am not sure about this. Thanks i nadvance. Etxe.

Ok, DMAX works, but as pisorsisacc pointed out, there are some reliability issues. It also works with DAO and "SELECT @@IDENTITY as NewID", need to test it with ADO. Thanks a lot! Etxe.

Hello everyone, In a form, I populate the source table DSP_RDV_CRRDV_t_CompteRendusListesThematiques" with some data, and I will send selected items of the list boxes to anoteher one: "DSP_RDV_CRRDV_t_CompteRendusListesThematiques", using a loop. To populate a field of this last table, I need to...

Perfect. A question about methodology: when you have to create a multiple step query, like insert into+no-match one, do you always split the code like you did in my example, or do you try a one step sql code? I guess it depends on the complexity, but I would be interested to know about your...