Search results

Hi all, I have the below code that I use in a form to do a search on more than one field. I need to find one account nr that could be in various fields (up to 10 fields) How can the below be adjust to look in account_no1 up to account_no10 ? Private Sub btn_search_Click() Dim sSQL As...

Hi all, I got further with it :-) Now I only need to format the text with colour and font and I'm ready with it. Please see below working code so others can make use of it: Private Sub btn_send_invitation_Click() Dim objItem As Object Dim db As...

hi all, I managed to make the add recipients work. What does not work now is the body of the email as it does not accept html text format in appointment or invitation. I wanted to add some line breaks and other things, but I can't get it to go to create line break. Any idea how to do this...

Hi all, I wanted to create a automation to send invitation out for users on a list for the training. It seems hard to implement. I could get only 2 users on a list to the email and the body of the email was empty. after many attempts, it is still giving me nothing that works. The idea is that...

I tested a and it worked nice :-) Greetings

Hi Sneuberg, This is a very nice idea and it works. Maybe I wanted to do it the hard and not logical way, BIG THANKS. Greetings.

Hi, I want to loop trough a table (tbl_manual_enrol_temp) where I have only one column called "eid" It should start with the first record, then insert it to the table tbl_enrolment. then move to the next record and insert it to the table tbl_enrolment. till there are no more records in it. If I...

Hi all, I have a form where the user would enrol people for a training. in the form there is a subform in the datasheet view with one field called "eid" The user would put several eid nr (employee id) and then when she/he clicks on the button, it should go one by one record and add them to the...

hi Ranman, the field name comes from an excel file that is produced by a system, not much I can do about it :-( This is the code that worked: strEmailEnrol = DLookup("[E-Mail Address]", "Active", "[Employee ID(1,679)] = '" & Participant & "'")Thanks a lot for :-) Greetings. (I ended up using...

Hi all, I wanted to use a query to get the results with DLookup like in the below. All I get is an error 3464 Data type mismatch. Any clue where go wrong with the below? strEmailEnrol = DLookup("[E-Mail Address]", "qry_email_address_enrol", "[Employee ID(1,679)] = " & Participant & "")...

hi Ranman256, thanks a lot, it is working :-) Greetings.

Hi Snueberg, I ended up using a combobox with a choice of Yes and No. This way no one will mess it up. Greetings.

Hi Static, Your code works great, it just does what it needs in the correct way. Misinlinq, I also will try your code to see how it works and learn from it. Greetings.

Hi all, I created a form where I want capture the complexity of a case. There are 11 questions to fill in with yes or no. I want to open the form with the form connected to the review_id that is part of the form and is in the main form too. if there was already a record created, then it would...

Hi, It is working nice now :-) BIG THANKS for this. Greetings.

Hi, I was looking at it and it works with the check boxes. I was wondering if it could be done with a text box where the value could be yes, or no. I will also need to count how many "no" in the form. Greetings.

Hi all, I have a list in excel where all the employees are listed. I need to get the email address from the team leader based on the employee id from one of the team members. How could I get this like in below example: John Doo, 123456789, Peter Cetera, 289276254, peter.cetera@hisEmail.com...

Hi, I managed to solve it :-) I had a better look at the loop and then the parts of it, I took one of the loops out and it worked just fin, then played with the code till it was just right. I also found where the checkbox came from and getting the real value from it. As you can see from the...

hi, I copied most of the code from internet, no clue if it was fine or not, it simply works Greetings.

Hi, Yes, the fields are being truncated :-( Greetings.