Search results

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

Yeah I was missing the Format bit - well spotted and thank you!!! :banghead:

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 Pbaldy - yes that looks like it'll do the job. I keep getting an undefined function error - do you know which reference needs to be on for this please? Thanks for your help. Phil.

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

Nooooooooo!!! The shame :banghead: Thanks mate!!

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

Hi all, Does anyone have a link to a plugin or solution where I can link an 2010 db to a UK heat map please? Any help appreciated!! Phil.

Hi, I'm trying to get a token ID from a URL to help me navigate round a website. The URL is below https://THEDOMAIN?route=common/home&token=de2430e6afb8c35629af67c4363f15b2 What I need to do is get the token ID after the = sign, then use add this to another URL to navigate to. I'm Okay with...

Hi, I'm not familiar with how that would work. Are you able to very kindly supply an example? Thanks, Phil

Hi, I've been banging my head with this one for about 3 days and hoping someone can help me please? I'm using IE automation to put data from an access db into a webform, submit some values then want to get some results back. The submittin part is fine, but I can't get the values out because...

Hi, I'm hoping someone can help with a frustrating problem please? My DB is merge in a currency field set to 2 decimal places into word. It's doing this by declaring the fields as variable, calling an instance of work then dropping the values into the bookmarks. All works fine.... When a...

Hi, yes it makes total sense and thank you for the advice! Off to speak to the web developer now!! Chers, Phil.

Hi, So will I need to get the web host to change the HTML to get this working as you suggested? Thank you for the help again! Phil.

Hi again Pr2-eugin - thanks for the help once more!! Your last gave me an Object Required error - but I note your point above...

Hello experts, I'm trying to tick "Yes" to a radio button which are side by side on a web page (Yes and No). The HTML is below and the VBA I'm trying to use is: ie.Document.all.Item("newsletter").Checked = "0" I've also tried ie.Document.all.Item("newsletter").Checked = "True"...