Search results

Only one person could use the Access database before, and we want to make it available for new members.

The SQL Server Express is in my computer: I used Firstly, thanks for all this information. I am a total beginner, so every answer brings me other doubts and questions. - the other users will be all over the country: which network do you refer whan ou say "the SQL Server connection needs to be...

Hello, I have migrated the tables of my Access app to SQL Server Express. If other people want to use these tables, I know I have to install Access or Runtime Acces on every computer. The question is: how will they connect to the SQL Server tables? Where are exactly those tables nested: in my...

The second folder posted by arnelgp is great too, easier for me, thanks!

Vlad, This is exactly what I was looking for: the [ ] means that it works directly in the subform doesn't it? Thanks a lot. Etxe.

This is very interesting, thanks. I will try to use it, not so easy though.

Hello everyone, In order to update one table (t_AffectationProjetA_Contacts), I populate a temporary table (t_ConsultationContactProjet_temp_modiftableprincipale) with a VBA SQL query in the form f_ConsultationGestionContacts _Projets: I select different criteria in 5 list zones-> populate the...

Yes, I have seen it. I will use this method. Here is how I did this time: 'Code in the form: str_SQL_finale = "SELECT DISTINCT t_AffectationProjetA_Contacts_expend.ID_contact, t_AffectationProjetA_Contacts_expend.Nom, t_AffectationProjetA_Contacts_expend.Prenom...

Very useful information thanks a lot!

Your approach is very interesting indeed, thanks. Etxe.

I have a very poor expertise in SQL server too, thanks for your help anyway. I hope that other people will give me advice.

Hi Gasman, Thanks for your answer. I am a bit reluctant to use querydefs, as it may slow down the process when the tables are on SQL server (I am not sure about it though). I try another way: I the string SQL expression that feeds the form recordset can be a public variable, and I use it to feed...

Hello everyone, I would like to ask for advice here: I use many "forms-tabular sub forms", mainly to generate lists of people that match with queries: the queries are directly written in VBA, using ADO and SQl code. Then I need to generate reports that correspond to the subforms: I use the same...

I found out how to simplify, I wrote the request in a single chain of characters. Thanks again

Thanks, done!

Hello, The main form can be updated A last question: what do mean by "unnecessarily complicated way" please? That would help me a lot to improve the way I create my lines of code. Thanks. Etxe.

Spot on, it works fine, thank you.

spot on Thanks a lot for your time!

And the subform is definitely bounded to the table

Hello all, A huge headache here: I have a form, with a subform linked to a table that contains a yes/ no check box field. There is no edition or modification restriction whatsoever for the form, the subform or the fields of this subform. When I filter the subform with a query, the returned...