Recent content by abbaddon223

Hi, Thank you in advance for any kind assistance with the below. I've enclosed just my question below, and also an expanded explanation of what this fits into for context if needed. Question I'm looking for a VBA solution which I can store in an Access form. The code will launch a popup...

Hi Experts.... I'm using the below code to generate an instance of IE to make a call via a VoIP system - works fine. The issue I am having comes with firing multiple instance of the code in quick sucsession. So, execute the proceedure, then loop. Again I can do the loop bit fine. Where I'm...

Hi, woudl this work in a query or is it VBA? Thank you!

Hi, thanks for the reply - what I'm struggling with is the syntax rather than the function.

Hello experts, can you help please@ I have a field [Email] with a value in, test.test@hotmail.com What I'd like to do is get the values before the @ an after the @ into two different fields so I have: [Before] [Email] [After] test.test...

Yep - did the trick. That's excellent and thank you for your help

Hi, Thanks for responding. There is no source code as it's an informatted page. If you follow the link below http://check.maxomail.com/?test@somedomain.com You'll see what I mean. Thanks for taking the time to help

Hi Experts - I'm hoping someone can kindly help me please? I have form with two fields: Email Result I use the following code to open a web page and check if the domain is valid: Dim ie As Object Set ie = CreateObject("internetexplorer.Application") ie.Visible = True Dim URLSTART As String...

Hello all, I'm hoping someone can help me please? I'm using Access to create some web page templates. To Do this I have a memo field called "Description" into which I'm entering text. Example: This is an obvious description example What I need to be able to do is put a "<p>" before each...

Hello all, I'm hoping someone can help me with what I thought was going to be a simple idea (sigh) I'm using the below to merge an access form into a word template (it's a starter for 10). That works fine. What I need to do is save the word template as HTML so I can then upload it to my...

Hi, Thanks for the response - not responsible for building the db mercifually!! Thanks I'll try that....

Hi, I have a db with a text field in it. In this a time is stored in a pretty poor format, example: 01:23 Meaning 1 minute and 23 seconds. I would have expected this to be: 00:01:23 But alas this is not the case. I'm really struggling to get the first format into the second. Could anyone...

Hello all, I'm using the below to merge from acces to word and create a new doc. All is well. However I need to save the output file type as PDF. When I try to change the docx to PDF, it corrupts? Can anyone help please? Thank you in advance for any kind support. Phil. Dim wordApp1 As...

That nailed it! Thank you very much again!

Hi, I'm using the below SQL statement in access but getting the following error: "Undefined Expression If in expression" which I presume is a missing reference? But I'm not sure which to add..... Can anyone very kindly help please? SELECT IF (t1.status = 'INCALL' AND t2.callerid IS NULL...