Search results

I love this idea! The reason I haven't tried it is that I don't know how. I will look at your links. The parameters I've set up basically are for queries tied to a report, for example. I have a "sign in sheet" report that runs on a committee list query. User is prompted for parameters for...

Let me make sure I follow...would I then be creating a separate table for each yes/no question, or a separate table containing each of the committees (I already have this table) and then a table containing two records, yes and no, for each option in the committee table? How would that allow for...

Thank you for your help and suggestions! I am not married to the MVFs. If I can accomplish the same via another method, I am happy to take suggestions. I originally had each option as a separate yes/no field. In fact, it is still there as I decide whether or not to keep the MVFs. But I wanted...

Thank you. I am able to weed out the "ghost" queries. I'm using 24 instead of 12 as I have some longer query names and the "ghost" queries seem to be over 30 characters. Do you suppose these fake queries will encumber the database at all? I only recently switched to the multi select. I had...

I did have a Left Name, 6 "Email_" criteria in the List box, but even upon removing it, the offending queries display. Here is the way it stands now: SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=5) AND ((Left([Name],1))<>"~")) ORDER BY MSysObjects.Name; I prefer it to...

OK this is the weirdest thing I've ever seen. I'm creating queries that have a criteria column that is a multi-select lookup. When I use this in my query, there are two queries saved: the one by my title and one that doesn't exist. I'm going to post screenshots because I know that does not make...

I got it! Basically with a combination of everyone's suggestions MajP, your placement of the emailTo line was the kicker. Thank you so much for your help. I have now created two buttons. One that will put the string of ";" delimited emails in the To box and another that will put the same in the...

syntax error on the SendEmailOutlook(emailTo,"Test","Test")

I want to also add that I do have a module saved for the QueryFieldAsSeparatedString Public Function QueryFieldAsSeparatedString(ByVal fieldName As String, _ ByVal tableOrQueryName As String, _ Optional...

No. I don't know what that means. Thank you,

Thank you for your reply! I'm getting syntax error on the SendEmailOutlook(emailTo,"Test","Test") What should I be placing in those "Test" fields? (It doesn't open up the arguments to give me any direction) (Also, yes, all the outlook reference libraries have been added)

Well gee thank you. This is only the umpteenth incarnation of this coding and approximately 14 months I've struggled with this one. I get that that is not effort enough. But thanks.

Thank you. How do I code that?

Thank you for your reply. No; that is not the intention. As I mentioned, I don't really know vb coding, so this had been pieced together from other codes I found hoping to achieve this end. I appreciate any suggestions you can offer.

Good morning, Let me preface this with I do not really know vb coding. I basically find bits and pieces here and there to try and make it work for me. I am stumped on a send email code. I have built a contacts database. This will house name, org, and contact information such as email and phone...

Trying to reply... Apparently I can't quote without getting this message "Your content can not be submitted. This is likely because your content is spam-like or contains inappropriate elements. Please change your content or try again later. If you still have problems, please contact an...

I see this is an old thread, but I am having the same problem as well. When I use this macro, the first name, last name, title, and email transfers over, but the phone numbers do not. I have renamed my fields to make sure that they match the ones in the database template, and they still do not...