Search results

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...

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...

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, 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...

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...

Hi all, I have a db, front end back end split, shared etc etc. It keeps getting locked up "this system had been placed in a state of user admin" In the past I've associated this with my being in the FE an design view, however that's not the case with this system. What is different with this...

Hi, I have the following SQL code running via VBA. I keep getting a datatype mismatch error, howevr the field I am referencing, and using as the qualifyer to update the record is Number. Any help greatly appreciated!!!! Dim Ref As String Ref =...

Hi, I'm using: DoCmd.OutputTo acOutputForm, "Frm_EL_PL_Bulk_Send", acFormatPDF, outputFileName1 To save a form as a PDF. The issue is, it saves all the records in that set in continuous form, and I'm trying to get it to only save the record its on. Can anyone help please? thanks in...

Hi, I'm trying to setup a process of opening a form, saving to a location, emailing it as a PDF, killing the PDF, move onto the next form - rinse wash repeat until done. The below works fine on a single click, however if I try to set it as an event timer of loop, I get an error saying: This...

Hi, I'm using the following command to output a form as a PDF DoCmd.OutputTo acOutputForm, "Frm_RTA", acPDF, outputFileName outputFileName is a variable I've created for file path / name etc When I run this command, I get a popup box asking what format I'd like to export / save the form as...

Hi, I'm hoping someone could help me please? I'm really stuck with this one... I have a table called: "tb_special_characters" with a field name [character]. In this table are values that I would like to remove from fields in another table ("tb_data", field name [Title] The values in the...

Hi, I'm used to using VBA in access to IE automation by declaring an instance of IE as a new object. For a current project, I need to use the browser inside a Web Browser Control Form. What's I'm trying to do is insert values intol controls within the webform. Usually I'd do this like...

Hi, I've been using Kill ("C:\users\Green003\appdata\local\antiphishing-internethelper\data\*.*") To good effect to get rid of some unwanted files in a specific folder. My new issue is that I need to delete temporary files in the below folder. This challenge here is that the files are stored...

Hi, I know this has been asked on here before but I'm struggling to understand the methods. Any help really apprecaited please: I have a table: "tb_skybox_Types", with the fields, [Policy_URN], [Box_Type] Sample: Policy_URN Box_Type 001 Standard 001 Sky...

Hi, I'm trying to export a report as PDF giving it a name at the same time. I'll then email this out. The email bit I'm fine with, but I'm struggling to get the report to save as a PDF Dim outputFileName As String outputFileName = CurrentProject.Path & "\Mail_Merges\Templates\Bulk\Email Quote...

Hi, I'm struggling with what is no doubt something simple - any help really appreciated!! I have a field: [comment] in which the follow value is as text: 3 from orders_10_11_13_2.csv for order 95D5KJQ8 Adref:Q3035 What I'd like back is just "95D5KJQ8" - so something to split this between...