Search results

Hello, I use the following code to populate a combo in a form called f_GestionPF. I have been trying to do the same thing to populate a combo called "combo_ProduitSemiFini" in the subform called "sf_CompositionProduitsFinis" of this form, I know the problem sets in this code line ...

Hello, I just found out where the error came from. The problem was that a linked table pointed to a dead link. Many thanks for your interest in my question anyway. Etxe.

Hi Gasman and Moke123, Sorry Gasman, but Moke just gave the answer. It is a company network actually.

Hello everyone, I need to split one Access db. There are 10 queries that are linked either to another query or to one table. I have just ran a splitting process, but I received a 3044 error message I read that one solution would be to kill those links, then to split the db and then to build the...

Hi, Thank you DB Guy and Pat. I just found out: the problem was linked to the names of the fields in the Year and Month formulas: it must be a string. Here is the correct code: Sub TrisConditionnelsFormulaire() Dim str_Sql As String Dim int_CritereAnnee As Integer Dim int_CritereMois As...

Hello everyone, I need to filter a table from a form: depending on the choice of option buttons, the table will be fildterd on two different date fields: - field named" DateReceptionAchat" if the option button 1 is picked, "eDateReellereception " is the corresponding name in my enumaration (...

I have tried with this one, and it works fine:

Hello Arnelgp, I have tried this way, but the selector wouldnt appear and point to the record.

Hello everybody, I have a classic Form sub form view: in the following picture, the first red framework is the mainform, polulated from table1, the green framework is the subform populated from table2. The Father-son fields are Id_Code in table1, and Fk_Code in table2. Now, I would like to add...

Perfect: it works, thank you very much Isaac. Etxe.

Thanks, Isaac's solution works fine, so I haven't tried with shell.

Hello everyone, I open an Access file from an Excel workbook, then I close the Excel, but the access file closes too: it is maybe more an Excel problem than an Access one, but I am not sure: here is the code, do you have any recomandation please? Many thanks in advance. Etxe Public Sub...

Spot on: great solution, so simple and quick, many thanks. Etxe

I have been trying for the first time the enum, and I need to use it to fully understand how it works. Thanks for your explanation. Etxe

Hi DBguy, the row source is this code: SELECT t_ListeSemiFinis.Id_SemiFini, t_ListeSemiFinis.Semi_fini, t_ListeTypesSemiFinis.Type_semi_fini FROM t_ListeTypesSemiFinis INNER JOIN t_ListeSemiFinis ON t_ListeTypesSemiFinis.Id_type_semi_fini = t_ListeSemiFinis.FK_TypeSemiFini;

Me.txt_Type_SF = Me.combo_Fk_SemiFini.Column(2) It doesn't work eather

Hello everyone, In a tabular form, a combobox contains 3 rows, and I want to copy the value of the third one in a text box right next to the combo: to do so, I use an enumeration list: Option Compare Database Option Explicit Public Enum eListeChoixTypeSf Id_semi_fini Semi_fini...

This is champagne (good champagne) clear Gasman, thanks a lot. Etxe.

Hello everyone, I have been facing the same problem: and I am a bit ashamed to say that I am not sure about the solution you all try to make us understand. => Let say the DB we use (queries, records etc..) is named Main_DB. It is in Folder_Main_DB - The CSV file is called File_CSV. It is...

I just found a solution: str_SQL_finale2 = "DELETE DISTINCTROW PROJETS_t_AffectationProjetA_Contacts_temp.*" _ & " FROM PROJETS_t_AffectationProjetA_Contacts_temp" _ & " INNER JOIN PROJETS_t_AffectationProjetA_Contacts" _...