Search results

Hi, I am trying to figure this one out I need to requery a list box after the rowsource has been set to its original SQL but everytime I run my code, nothing is hapenning, this is the code I currently use If Not Me.cboMois.Value = "" Then 'restore to default data in table...

the control is set to select from the list only, no modif or typing of any kind, I am safe on that Regards

Many Thanks, should have tought about it, the after_update is not an option since this cbo is used only as a way to filter information only not updating any value at all, so everytime the use select a month, the list is to be refreshed based on the new selection only. I wil ltest it up...

Private Sub cboFiltreMois_Change() 'filter data based on MOIS only, to disregard all other options Dim strVal As String strVal = "SELECT LISTE_CONFORMITE_HISTO_DETAIL.* From LISTE_CONFORMITE_HISTO_DETAIL WHERE LISTE_CONFORMITE_HISTO_DETAIL.Autres_Mois = " & Me.cboFiltreMois...

Hi, I just tried some variable of your code and when I run it I stil lget the enter parameter value box with the name of the cbo selection, am I missing something here ? THis is the real code line: Me.Form.RecordSource = "SELECT LISTE_CONFORMITE_HISTO_DETAIL.* From...

Thanks, I just went the older way meaning keep all the data fields locked and just change the form to edit only, that does the job too

THis is somelse db I just pickup and trust me on this one, I was completly stunt with what I saw in it, var not declare at all, function not been called properly and most of all, all tables, forms, reports, queries are all caps with no prefix to ID them properly, really sad

please see the worddoc attached for a printscreen

tried it and I still get the pop up asking to enter a parameter this is the new syntax I am using : SELECT LISTE_CONFORMITE_HISTO_DETAIL.*, LISTE_CONFORMITE_HISTO_DETAIL.AUTRES_MOIS FROM LISTE_CONFORMITE_HISTO_DETAIL WHERE...

Hi, I have the following Q: SELECT LISTE_CONFORMITE_HISTO_DETAIL.*, LISTE_CONFORMITE_HISTO_DETAIL.AUTRES_MOIS FROM LISTE_CONFORMITE_HISTO_DETAIL WHERE (((LISTE_CONFORMITE_HISTO_DETAIL_MOIS.AUTRES_MOIS)=[Forms]![CONFORMITE_HISTO_LISTE].[cboFiltreMois]![Value])); When thew query is being execute...

Hi, it has been too long for me with MSAccess and I have a problem I have taken over some old db from another developer. I want to know if this is possible, there is a form in READ mode only for some security reason (this form is used as a browser). One request is to add a cbo to be able to...