Search results

Hi Minty, I took your advice and mixed it with my code to get exactly what I needed :-) I used this part first: [HKField] & "-" & [AEField] in the query. Then I did run the below code: Public Sub btn_test_Click() Dim qry_profile_1_scr2_results As String Dim rs As...

geez, I forgot how can I combine all the above to get it into a variable that I can later use? now I will get results by results but not as full string. Greetings.

OK, I got closer: Public Sub btn_test_Click() Dim qry_profile_1_scr2_results As String Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("qry_profile_1_scr2_results") ' print column names 'Dim i As Integer 'For i = 0 To rs.Fields.Count - 2 ' Debug.Print rs(i).Name & vbTab; 'print col...

Hi Ranman256, I get now like this: HK, HK, HK, HK, HK, HK, HK, HK, to get it like this will be hard: HK-AE 18, HK-CN 1, HK-TR 1, HK-VC 1 Greetings.

Hi all, I found some code on the web that almost does the trick I need. I only got lost in how to get all the results from a query that now comes in a few lines into one line, separated by a coma. this is the results I get now (in the immediate window) HK AE 18 HK CN 1 HK TR 1 HK...

Hi Arnelgp, It works really nice :-) Ranman256, I will look into your solution too, seems also nice :-)

Hi all, I have a table where I have all the rewards people got. We have an initial budget for this for example like 100 dollars. 3 people got 10 dollars each. This means I should have 70 dollars left. Can I do this in a query and feed the initial value from a field in the main form? I have the...

Hi all, I managed to solve it by creating a temporally table where I first add the values from the search table. Then I use a query to insert the record on the correct table from the record_id value in the main form. Greetings.

Hi Plog, I have a form where I have a subform where I get results from a search. I want to use this data to insert into another subform that is also on the main form. The table is the one from the query above. I guess I confused the query and it lacks the SELECT INTO

Hi all, still the missing ;

Hi all, I have the below code to insert some data from a search form into the table according the record_id that is on the current open record from the from. CurrentDb.Execute "INSERT INTO tbl_recipients (forname, surname, employee_id, team_leader) Values ('" & strListResult & "', '" &...

Hi, it works really great, no clue it could be done this way :-) Greetings

Hi all, I'm looking into passing a month name from a combobox in a form to a query and get the results for that month. If I would use November, I should get all the records that fall in November. Is this possible? the field that I try to do this is called "pickup_date" Greetings.

Hi all, I was absent some time, so I will get back to this and give feedback. Greetings.

Hi all, I have a subform with a combobox. the combobox will need to get me a selection of a participant that has her/his name in one of the records. For example in record 3 I have 3 participants "John Potter, Amelia Blake, Peter Cetera" If the form is showing the data for record id 3, then...

It works :-) Thanks a lot :-) Greetings.

hi, it will be in a subform. The main form has the search text, and below there is the datasheet subform. Greetings.

Hi all, I have the below code to do searches for example the creator of some minutes. The results are shown in a listbox. Is it possible to show this in a datasheet instead? Private Const BASE_SQL As String = _ "SELECT record_id, subject, date_of_meeting, invitation_status, time_of_meeting...

Hi all, I came across a silly thing that I can't figure out. I have 3 almost same records, the only difference is that they have a different time (hour and minutes) in the field "created' as you can see from below: 15/09/2017 09:25 John Secada Started 05/09/2017 15/09/2017 11:59 John Secada...

Hi Rannman256, I can use Polish characters without problems directly when creating the folder name, but can't with vba. I actually mean like letters :-) ł ą ń (a few examples). Greetings.