Search results

  1. C

    Storing Credit Card details

    Thank you all for your responses. That has been very helpful. I will look to move the backend to SQL Server and investigate the options for utilising a 3rd party service.
  2. C

    Storing Credit Card details

    I need to be able to capture credit card details over the phone and store securely in an Access database. The requirement is to then create an extract file containing credit card details, amount and to be sent to a bank. If the same customer calls again weeks later, there is a need to be able...
  3. C

    Word VBA from Access

    Yes, that's how I'm trying to quit Word. I've also tried quitting with objApp.Quit SaveChanges:=wdDoNotSaveChanges, but that appears to relate to saving dirty document changes, rather than template changes.
  4. C

    Word VBA from Access

    Thank you for responses. Well, "does stuff" refers to the building of documents which are saved. All documents are saved OK (using SAVEAS), then all I want to do is 'quit' the session. No attempts to save any templates.
  5. C

    Word VBA from Access

    I've developed VBA code in Access 2007 which starts a 'hidden' Word session, does stuff, and then quits the Word session. All works fine except under 2 scenarios - (A) If there is another 'normal' Word session running prior to the code running and (B) If a 'normal' Word session starts whilst...
  6. C

    Dedicated Clipboard in VBA?

    Isskint, thanks for the tip. I tried it by using the following code: myPathBase = myPath & strDocBase strFullPathFileName(0) = myPath & strDoc1 strFullPathFileName(1) = myPath & strDoc2 strFullPathFileName(2) = myPath & strDoc3 Set objApp =...
  7. C

    Dedicated Clipboard in VBA?

    Thanks to Bilbo_Baggins_Esq and Isskint for their responses. Yes, the small documents contain images, tables and many many styles which I need to bring across. I also need to apply logic in determining which documents to use. So, it is going to be too complicated to apply the formatting after...
  8. C

    Dedicated Clipboard in VBA?

    I've developed VBA code in Access 2007 to copy many small Word documents into a larger Word document. It works fine, but can take 10 to 20 minutes to complete, running in the background. That's OK too! HOWEVER, because I use ".Selection.Copy" & "Selection.PasteAndFormat" as the basis for the...
  9. C

    Using Word Objects from MS-Access 2007 VBA

    Apologies again for the delay. I did a "Quick Reply", but that didn't seem to be associated with the thread! Won't do that again. Anyway, I tried your suggestion and prefixed the code with the "objApp". It initially fell over saying that "wholestory" property was not known, but now it's...
  10. C

    Using Word Objects from MS-Access 2007 VBA

    Thanks again. Adding that code leads to error 438 ("Object doesn't support this property or method") in reference to the syntax "wholestory". If that's not valid syntax for 2007, what is the recommended way of selecting all text? Do you know any URL pointing me to the 2007 reference guide (ie...
  11. C

    Using Word Objects from MS-Access 2007 VBA

    Errr... stupid here forgot to paste the code!! Sub MergeDocuments() Dim originalDoc As Document, tempDoc As Document, newDoc As Document Dim myPath As String, myPath1 As String, myPath2 As String, myPath3 As String myPath = "C:\Users\xxxxxxxxx\" 'ThisDocument.Path...
  12. C

    Using Word Objects from MS-Access 2007 VBA

    Apologies for the delay. Thanks for responding. In the following code (which I've largely plagiarised from other peoples samples), I get a run-time error 424 (Object required) on the statement "Selection.wholestory". I'm guessing "wholestory" is a later syntax, which is not known to Access...
  13. C

    Using Word Objects from MS-Access 2007 VBA

    First ever thread.... I'm using MS-Access 2007 for a client and need to manipulate Word documents. I'm finding it difficult to find the definitive list of objects, methods and properties to use in this version of VBA. The specific need is akin to a 'merge'. I need to (i) open a blank Word...
  14. C

    Hello

    This is my brief introduction. It's my first forum, although I have been around the Sun 58 times already. Formerly a PL1 programmer in the "olden days", I've managed to keep my hand in with VBA for the past 15-20 years or so. I occasionally need help, but would like to think I might be able...
Top Bottom