Search results

Hi, Thanks for the above information. I will try to setup some things with them and see where we get. Greetings.

Hi all, I got asked to create a checkers matrix to have some selected checkers check the quality from some selected analyst. To be honest, I'm clueless how to handle this and was wondering what would be the best approach. Each checker well be able to check the quality of all the analyst, but...

OK, done :-)

oops, silly me :-( it works now :-) thanks a lot. this is the final version: Private Sub Combo188_Click() Me!frm_create_event_subform.Form.Filter = "Month([training_date_start]) = " & Me.Combo188 Me!frm_create_event_subform.Form.FilterOn = True End Sub and to clear the filters: Private Sub...

Hi, I tried it with: Private Sub Combo188_Click() Dim DatePartNr As String DatePartNr = Combo188.Value Me!frm_create_event_subform.Form.Filter = "DatePart('m', [training_date_start] = DatePartNr)" Me!frm_create_event_subform.Form.Filter = "DatePart('m', [training_date_start] = 5)"...

Hi June7, I made it work like this: Private Sub btn_future_events_Click() Me!frm_create_event_subform.Form.Filter = "[training_date_start] >= Date()" Me!frm_create_event_subform.Form.FilterOn = True End Sub Would it be possible to add also a combo box to the form and filter on months? as...

Hi all, I try to build a filter via vba to filter a subform in datasheet view to show all dates after today's date. The below is simply not working and after a lot of trying around still nothing. Any clue where I go wrong? Private Sub btn_future_events_Click() Dim Filter As String Dim...

Hi, the pr_nr could be in one of the 2 tables, that is why I need to check if with that criteria there is in one or more in the first table, if not, it goes to the second table, and if there still not, then it stops. I also will add there some more code to add a "yes" or "no" if there are no...

Hi Moke123, It works really great :-) I have only 2 more problems with this now. It will add it on a new line (record) was wondering how it could get to the same line in the table as there is the criteria for the query. Second problem is that if I have only on record "pro_nr" (the criteria) it...

Hi all, I'm running first a query on linked table that will create a recordset. I need to get this into a local table, but the recordset that is returned, has 2 values (from 2 different fields) but I got stuck with this. Where did I go wrong on the below code? the "values(rst1, rst2)" is...

hi all, It worked out :-) BIG THANKS to both. I was wondering if it can be used also in vba. I will give it a try :-) Greetings.

Hi, I don't get it to work, just get the error #Name? but then I actually saw it is stored in number format :-( my mistake. Greetings.

Hi all, I have 2 fields inside a form that are used to run a query. the only thing is that the first field will be filled in, and the second field needs to format the text into a date. Field 1 is called from_date_text and field 2 is called limit_date_text in the first field I have the date...

Hi Jdraw, Your code works nice :-) I will not try to pass it to the text box in the form. Greetings.

hi Galaxiom, The form is for quality check, and it is opened from the main form and linked to the record_id. There are 4 forms that will open based on criteria. There are a lot of question with each 5 comboboxes according to 1st check, 2nd check and so on. When a user does a check, he needs to...

Hi all, I have a form with about 150 comboboxes. I need to check if one has a value "fail" and then set a field in the main form to red background. I got the below code, but it fails to show the value of the combo box. Dim ctl As Control For Each ctl In Me.Controls If ctl.ControlType =...

Hi all, I want to create a duplicate record of existing record and change the value from a field to a different value. As example, if the country is Republic of Ireland, it should change it to Northern Ireland (in our database we have it as NI and ROI) It should check the record what the field...

Hi Minty, It is working like that very nice. I will now create an import button to make sure they get the data into the tables easy. Greetings.

Hi, I think I will give it a try like this tomorrow: Private Sub btn_search_Click() Dim sSQL As String On Error GoTo errr sSQL = "SELECT * FROM qry_search_accounts_2 " & BuildFilter & " ORDER BY qry_search_accounts_2.ccr_code"...

Hi Minty, The names come from excel sheet and they are called account_no1, account_no2, account_no3 and so on. I need to do the search on those fields. I simply don't get to choose what I want to work with. Sorry. Greetings.