Search results

Hi WayneRyan, Thanks! That did it.

Hi, I've made a small example of my actual db. I hope this makes it easier to explain. You'll see 2 buttons, on the default unit parameters tab. One with the code metioned above and one with code that I've tried to modify to make it work. I just can get the Loop function to work with the for...

Hi Wayne, Thanks for the response. You are right, I forgot the "next" in the code. We do work on repairing all kinds of units. In the beginning we can only live with assumptions. We say a system has 5 different cards and each of this card is present 5 times in the system. My report needs to...

Pls allow me to ask this, probably for you, basic question. I've searched for the solution and came up with some but I don't seem to be able to add it to the code below. I'm trying to create a db that will generate an default xls report. This report will be used for postprocessing in xls...

I Changed the query name in: Set rsEMail = CurrentDb.OpenRecordset("Qry_Contacts / Doc type Subform") to the SQL query string Set rsEMail = CurrentDb.OpenRecordset("SELECT [Tbl_Available Contacts].Name, [Tbl_Available Contacts].EMail, Tbl_Contacts.[ID Document Type] FROM [Tbl_Available...

Wrong query OK, Problems seems to be related to the query. It did not return any values... But when I run it seperatly, it gives me the data I need?!

Hi all, I'm sure this is any easy question for a lot of you... I want to send out an E-Mail to multiple receipents. This E-mail does currently only have one attach. I have been looking for some code and came up with the following: Private Sub Command44_Click() Dim MailApp As...