Search results

Hello Doc, This is a very detailed and useful answer, many thanks! I think my data are correctly normalized, I use very few redundant fields, and almost only foreign keys, and then joins to display explicit information in forms. I actually solved the problem using an simple update query, and...

Hello Doc, I actually can add a field to my first table but I don't want to: here is why: - the first table (table 1) contains a list of people, those people can be assigned to one or several projects, so I need another table (table 3, same fields as in table1+one field with the name of the...

Hello isladogs, thanks a lot for your advice. However, I can not add a boolean value to the first table (it is a table that identify people that might be assigned to projects, primary key "ID_contact") , as the result of table2 (used as an intermediary table, I will empty it before populating it...

Good morning, Before presenting the problem, here is the context: I select a range of records from one table, "table1, (step1) using a form containing for criteria to filter the records. Then I would like to transfer those selected records to another, table2 (step2) containing an extra column...

It is CP yes, not CP,2

Hello plog, You are right, I used Access to create a query, it it is pretty easy. I have sorted it out. Thanks a lot. "SELECT t_ListeContacts.Nom_contact, t_ListeContacts.Prenon_contact, t_ListeContacts.Nom_structure, t_ListeContacts.Fonction, t_StatutJuridiqueSoignants.StatutJuridiqueSoignant...

Hello, I have been trying to get rid of all the calculated fields of my tables, in order to run "table creating"queries: Now I can't link one of my tables to the other ones (the calculated field extracted one part of the zip code that became the link) so no way to fully use the Access query...

Oh! I have just sorted it out : I give a different name every time I add one step: str_SQL, str_SQL1 etc... thanks a lot! Etxe.

Hello everyone, I have been struggling to build a dynamic SQL chain: the first step works just fine (str_SQL = str_SQL & " Where t_ListeContacts.Departement In (" & str_CritereDepartement & ")" used to feed a recordset) the second one returns an error: str_SQL = str_SQL & " AND...

Thanks a lot Pat, This is the way I am trying to work. Here is a short sample of code I use, does it fit with good practices? str_SQL = "SELECT t_ListeContacts.[Nom_contact], t_ListeContacts.[Prenon_contact]," & _ "t_ListeContacts.[Nom_structure], t_ListeContacts.[Fonction]...

Hello, this is an old thread, but I am facing the same problem: the reason is I want to migrate the tables into SQL Server, and I read it was better to use the ADO way, and that working with an already "access made" query was a bit risky. I am not sure it is worth the headache though. Could you...

Hi Minty and theDBguy, I have a few more questions: - To make my point clearer, I will put the BE tables in SQL server, because I have very little data and few users (5). I am rewriting my code to use ADO instead of DAO, and to load all the forms, sub-forms and controls from procedures using SQl...

Thanks a lot the DBguy. I am not very used to sharing on my work, could you be more specific about the information that will help you help me? I can send you a homemade "data model" I designed on Excel for instance? It shows with words how data are related. Thanks again. Etxe.

Hello everyone, I have developed an Access tool: 20 tables (all the primary keys are auto numbers), roughly 15 forms: the queries are included in the VBA code with SQL language. I use several macros with arguments (to select-deselect all items in listboxes for instance) and one VBA class module...

Nice to be here, great community!