Search results

You nailed it - thank you very much for your help!

Hi, I'm hoping someone can help please? I'm trying to get a Dlookup working and I'm not sure if it's the syntax or the source table (in this case a select query). [Script_Lookup] = DLookup("Script", "Slc_Campaign_Scripts", "ID='" & lead_id & "'") I'm trying to get the dlookup about to pull...

Thanks TJPoorman - you nailed it

Hi Paul, Yes I suppose I am, but I need this to run from the form rather than a query. I know this is probably something really basic :eek:

Hi, I'm pretty familiar with getting values from a table via Dlookup. What I want to do is almost the reverse if possible? I'm declaring a variable as follows: Dim Ref as string Ref = [lead_id] This is from a form. What I'd like to be able to do is go to the table [list], reference the...

Hello experts - I'm hoping someone can lend me some experience please? I currently deploy my apps through terminal services - works great but it's getting expensive. I have a large deployment coming up and I want to find a cheaper way to deploy my apps. From my research it looks like runtime...

Hi, I'm hoping someone could kindly help me please? I'm trying to add a value from access into a combo box on a web page. I can get the combo box to refresh, but not add in a value The HTML for the combo box is <tr><td align="right">Campaign: </td><td align="left"><span...

James - thanks for both comments - I've got the combo box to refresh just by placing focus on it as your link showed ie.Document.all.Item("VD_campaign").focus I'm going to open a seperate thread regarding putting the info into the combo box. Thanks again!!

What a living legend!!! Thanks so much for that help. Could I ask for a little more help please? Now I have a dropdown box (on the web page) which I'd like to populate with a value. From the looks of things, the combo box only allows / shows it's input values when it get's focus. Am I able to...

Hi, I'm trying to put a value into two fields in a web form. The code I'm using is: Dim ie As Object Set ie = CreateObject("internetexplorer.application") ie.Visible = True ie.navigate "URL HERE" While ie.Busy DoEvents Wend While ie.Document.ReadyState <> "Complete" DoEvents Wend...

Hi, I have a field in my report [Idle] This has a time in a HH:MM:SS format (so 01:38:23) What I need to be able to do is sum this greater than 24 hours and keep the format of HH:MM:SS - ideally I need to do this in the form field that I'll be using to sum it. Any hel is greatly...

Hello experts - I'm hoping someone can help me please? I have a terminal server with Access 2010 on it. I have been asked to connect to a remote MySQL server. This is in no way on my server, so it needs to be some sort of web access? I can see that ODBC is the way to go, however can someone...

Hi, I'm struggling a little with this one if anyone can help please? I'm trying to put multiple IF statements into one proceedure like the below: Dim Answer As Integer Answer = MsgBox("Have You Selected The Correct Outcome?", vbCritical + vbYesNo, "Continue Request?") If Answer = vbYes Then...

Hi, I have an access application which is currently serving as a click and dial dialler. It's is doing this via some SOAP API's (very basic but works well). What I'm looking to do is upscale this so that it works through ViciDial which is a predicitive dialler. I alreadly have a company that...

Mate - you've sorted my issue and saved my job again! Thanks so much!!!!

Paul - looks like you are here to save me again - thanks for the link - I'm saving that one as there is some really useful stuff there! I've downloaded the plugin and added the reference. However I now get a new error: Argument Not Optional at oSMTP.AddRecipient "tester"...

Thanks Clon - I tried the: Private Sub TestEmailAddress() Dim oSMTP As New EASendMailObjLib.Mail oSmtp.LicenseCode = "TryIt" oSmtp.FromAddr = "sender@mydomain.com" 'validate the following email address oSmtp.AddRecipient "tester", "tester@mydomain.com" If...

Hi, I'm hoping someone can help please as this is a new one on me. I've been researching for an answer but am drawing a blank. One of my clients has asked me to look at building a way to check if the email addresses they are capturing in my CRM are valid. He want's to go beyond checking for no...

Hi experts, I'm using VBA and XML to send emails from my db to a legitimate mail server (Mandrill). The mail server will accept any number of receipients in one go. I'm using an SQL string to build up my recipients into one large string (phil@test.com; fred@test.com etc). This works well as...

David - be useful or dont comment at all.