Recent content by ianclegg

  1. I

    Field Contents doubledup

    Thanks again for the help, I changed the field type to Text and deleted the second half. Now it works OK. Regards
  2. I

    Field Contents doubledup

    I would appreciate any help with my problem I am using a subform within a form to select data from a field, the records field is defined as a hyperlink which contains the location of a pdf file. When I use me.datadisplaysubform("report") to retrieve the data, I find that the field contents get...
  3. I

    Sql Syntax

    Thanks for your help, I have fixed my mistake, a different approach always helps the cause. Once again Thanks Regards Ian Clegg
  4. I

    Sql Syntax

    Hi I am trying to extract records from a table using variables gained from another table, unfortunately I cannot create the correct syntax. I have 3 variables,i have shown my sql below Sql = "select seqno,surname,forename,diedon,warcemetery from ByCemetery where surname = CWGC_surname" If I...
  5. I

    Merge 6 Word Documents, Output to pdf

    Is it possible to merge 6 Word documents and the output the complete document as a pdf using access 2007 VBA? Has anyone and code example that I can use. Thanks in anticipation Regards Ian Clegg
  6. I

    Merge PDFs using VBA

    I have a need to merge 6 pdfs using vba, I have checked all the bullzip pdf writer references but can find no info onto how to configure them. Can anyone help me or suggest an alternative method. Thanking you in anticipation Regards Ian Clegg
  7. I

    Merging Pdf docs using access 2007 vba

    Thanks Galaxiom I followed you suggestion, my final code is posted below. Set objShell = CreateObject("WScript.Shell") strcommand = "PDFTK c:\doc1.pdf c:\doc2.pdf c:\doc3.pdf cat output OutputF1.pdf" objShell.Run strcommand Thanks to all who viewed, maybe this will help you. Regards
  8. I

    Merging Pdf docs using access 2007 vba

    Hi Has anyone any simple code that merges multiple pdf documents that they are willing to share. I don't seem to be able to find anything that works so far. Thanks in anticipation. Regards Ian Clegg
  9. I

    Adding a bitmap photo to table/report

    Thanks for the help and advice, II really only want to add the photograph to my report. My tests with adding a bitmap to a database file have all failed. I would really appreciate an example. I will checkout all the links as suggested. Ian
  10. I

    Adding a bitmap photo to table/report

    Hi Has any done the above, I have read many help forums but cannot figure it out. I am wanting to store a bitmap photo in an access table and then want to include it in a report. Thanks in anticipation Ian Clegg
  11. I

    Web Query using VBA

    Thanks for the helpful reply, I will contact them Ian Clegg
  12. I

    Web Query using VBA

    Hoping that someone can help I am trying to update a table in an access database storing war grave locations from memorial data. I want to query the cwgc.org website automatically using vba to retrieve the location of the cemetery or memorial that the person is located in or on, I know the...
  13. I

    Reading Web page source code

    Thanks for the reply
  14. I

    Reading Web page source code

    Hi Can anybody suggest a method of reading web page source code data. I am trying to create an event similar to a web query in Excel. The table in question is not a html table but an asp.net table I think. Thanks in anticipation, I hope someone can help Regards Ian Clegg
  15. I

    comparing 2 variables

    Cracked it, Thanks very much for your help Regards
See more
Top Bottom