Search results

My wife has been after me to get a new bridge for our Koi pond/stream and today I ordered one from Wayfair. About an hour later she told me that she found a bridge that would fit nicely and I should order it. It appeared as an unsolicited ad on her Face Book feed. It was the same exact bridge...

No, mine slightly different. I tried this but as I am using late binding many lines of the above code say that I have not defined. These are: config.fields(cdoSendUsingMethod).Value = cdoSendUsingPort config.fields(cdoSMTPServer).Value = "smtp.gmail.com"...

OK, I will look at the App password thing again, but it looked too complicated for me.

Thank you for your response. I looked at the Google's API and use OAuth suggestion and I have to admit this is way beyond my area of expertise and knowledge of coding, Google and etc. So I will either have to use the Outlook mail which is a bad alternative for me for security reasons or Yahoo...

Thank you both for your suggestions on this. I set the Gmail setting as was suggested but still get the same error message. Also got about a dozen message from Gmail telling me that I had committed a grave error in setting to less secured app. I don't want to bet this old horse to death...

Forgot to mention that I am using late binding if that makes any difference.

I have the following code that worked fine until I tried it today. I have not used it in a while, so I don't know how long this has been not working properly. msConfigURL = "http://schemas.microsoft.com/cdo/configuration" With fields 'Enable SSL Authentication .Item(msConfigURL &...

Thanks. I was preoccupied with a related item and your answer was right on. Just needed to use query defs. Learned a lot too! other thread: https://www.access-programmers.co.uk/forums/threads/sql-statement.313956/#post-1721728

She is involved with local politics - on the city council as vice mayor - so I definitely keep my distance.

Thank you arnelgp. I see what you are saying now. You can only modify an existing select query this way. by the way, you have solved two problems for me today. Guess I can now go and make dinner for my wife.

My current code: Dim sSQL As String sSQL = "SELECT TOP 25 tblMain.ClientID, tblMain.FirstName, tblMain.Organization, tblMain.Email, tblMain.OnSendList" & _ " FROM tblMain" & _ " WHERE ((Not (tblMain.Email) Is Null));" DoCmd.RunSQL sSQL[Code]

And I should say that I use late binding.

Yes. I want to modify the query (Sql statement) with VBA using a parameter from a form. The use depends on whether or not I can run the SQL statement with VBA.

So, what do I use for the run statement?

What am I doing wrong? This is my sql statement from the query: SELECT TOP 25 tblMain.ClientID, tblMain.FirstName, tblMain.Organization, tblMain.Email, tblMain.OnSendList FROM tblMain WHERE ((Not (tblMain.Email) Is Null)); And this is my SQL statement in my vba code: Dim sSql As String sSql =...

I've looked and looked but cannot seem to figure out what anyone is saying regarding QueryDef object. So perhaps if I explain what I am trying to do there may be a simpler solution. I have a list of perhaps 1000 names. I want to select the first 100 or so and send them an email which I will...

I am trying that but can't make it work. so far I have tried Dim sSql As String Dim sDrip As Long sDrip = Forms!frmCampaignsToSend!QuantityToSend sSql = "SELECT TOP sDrip tblMain.ClientID, tblMain.FirstName, tblMain.Organization," etc. DoCmd.RunSQL sSql Still get the can't use a parameter...

I want to select the top X in a query. I know how to do it using return X from the design tab or Select top X in the SQL statement, but is there any work around for setting a parameter in a form to do this. All the info I found so far says no, but perhaps someone has found some way to do this.