Search results

  1. A

    Cannot Complete Action Whilst Processing

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

    Disable Output To

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

    Disable Output To

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

    Find And Replace

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

    Web Browser Control With VBA

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

    Dlete Folder & Subfolders (and files within)

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

    Concatinate Multiple Rows into One Field

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

    Concatinate Multiple Rows into One Field

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

    Export Report As PDF

    Nooooooooo!!! The shame :banghead: Thanks mate!!
  10. A

    Export Report As PDF

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

    In String Help

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

    Heat Map

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

    Instr From URL

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

    Get Data From Table

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

    Get Data From Table

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

    Losing Decimal Place In Mail Merge

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

    IE Automation - Radio Buttons

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

    IE Automation - Radio Buttons

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

    IE Automation - Radio Buttons

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

    IE Automation - Radio Buttons

    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"...
Back
Top Bottom