Search results

Any progress Minty?

OK, not sure how you wanted it Minty, but here they are in .jpg format. By the way, I changed the Result Type in the Notification_email_dept field (where all email address are combined with semi-colons) from "Text" to "Memo" in my tblReportNotification table to capture unlimited email address...

OK, so I ran this: Dim strSQL As String strSQL = "SELECT EmailType_ID" & _ " FROM qryEmailTo" & _ " WHERE MyField = 0;" ...and got this as a result:

That is exactly what is happening, but I don't get the error code. The odd thing is, if I select less than 11, then I get this error code.

Here is where I select the recipients: TO: If I select more than 11, it works, but I don't get the last part of the email in the address box... CC:

Yes, they are semi-colons.

OK, so I got it to work, but I have another problem I ran into. When I click on the button to email the report, I get the following error message. I can get it to actually open the email with email address as long as I have all 15 people selected to be emailed... Any ideas? Dim...

Great advice, I'll give that a rip. Thanks. I'll report back.

As to the DLookup issue. I realize that and tried different methods of trying to be specific to indicate the record. I am looking for suggestions. I have attached my Notification table so you see the layout.

Yea, in my Query, I have to records. One is EmailNotification, which are contacts with emails that will be placed into the "To" box in the email and the CCNotification are those emails that will be added to the "CC" box in the email. So I am thinking that I have to pull each record for each...

I am having troubles adding email addresses to my CC box in my email. I am able to get the emails to populate into the "To:" space. Now I know I have the DLookup accessing the same record, but how can I make it so the CC_List puts the emails into the CC of the email? Thanks Dim...

I have a report embedded into a form. When I print, not only do I get the typical print dialog window, but I also get the print preview window. How can I disable that so only the print dialog window appears?

I would actually prefer one record with all measurements (1 up to 5) from that one lot to be associated with the drawing location and spec. Set it up so that I have one record per shipment received containing all the measurements of that one measurement indicated from the drawing. To me, that...

I apologize for not being as detailed as I should have been. I forget that most people aren’t in the QC field and do not understand what takes place during the incoming inspection process. I’ll outline the process in which how it works and what I am trying to accomplish. Hope this helps. OK...

The reason why I have it set up like that is that the inspector can take multiple sample readings from the same lot of received goods. Each row that I illustrated indicates a unique measurement of the part. With this being set up like the way I have it will allow me to average out the...

This is what I am trying to accomplish after Appending as I understand it should do. Notice the blank fields for data input. "Drawing Location" and "Spec" fields are what I am trying to append. Note, this is a photoshopped version.

Thanks for your reply Plog. I caught the looping path and corrected that. WHat I am trying to accomplish is that yes, I am inspecting products from vendors. What I was hoping to achieve was once the specs are added to each product, I would be able to select the product from the vendor where...

OK. First off, this is the first time I’ve Appended and I've searched the forum and other sites, but canot seem to find any help:confused. :confused: I am developing a database for incoming inspection. I have set up two tables, one with spec callouts per product and the other table contains...

Thank you Beetle and you're right, never thought of that. Good idea. I'll make sure to change that in the event I build upon what I already have. Thanks again, Steve

WOW, thanks jd. I exported the data into Excel and it came up clean for duplicates. Or so I thought... Thanks, all cleared up now. Now I feel dumb. lol Have a great day.