Recent content by Motorhead

  1. M

    Selection of a word document

    Hello! I'm working on a code that reads MS-Word documents. I want to select text with outlinelevel = bodytext until the text in the document is not outlineleve = bodytext. How can I do this Greetz,
  2. M

    End of file in document

    Hello! I'm making a function in VBA wich search for some words in a document. I want to do the search operation until the whole document is searched. something like: While not wholedocument is searched searchoperation Could someone help me with this?
  3. M

    Relinking tables

    Hello Chris! Well I've found the linked table manager, and that is exactly what I wanted, only I want to do this in VBA and automaticly. Maybe you or someone else can help me Thanx
  4. M

    Relinking tables

    Hello! I've got a database wich uses tables of some sub database. How can I relink the tables with code in VBA. When I change the path of the database he can't find the data of the linked tables and that's not what I wanted. Hope someone can help me Greetz, Martijn
  5. M

    Mail Merge One Record

    Hello! Does anybody knows how to mail merge just one record of a table? (only the first for example). Thanx!
  6. M

    Mail Merge Problem

    Hello! I got the following code: Function MergeIt() Dim objWord As Word.Document Set objWord = GetObject("selectet path", "Word.Document") ' Make Word Visible. objWord.Application.Visible = True ' Set the Mail Merge data Source. objWord.MailMerge.OpenDataSource Name:="current db"...
  7. M

    Check query?

    Hello! I've got a testtable with tests, a combination table with combinations of tests and a oneliner table. When I delete a test I want to check in the Combinations table if the test has no more relations with a oneliner. How can I check this in VBA? Thanx and Greetz, Martijn
  8. M

    Generate MS-Word documents

    Thanx, I think it will work perfectly for generating a document of a query. But I also have to generate a document of a form wich is a little bit more complex, It has to have a special lay-out. But I've got some example code for this, so. Greetz, Martijn
  9. M

    Generate MS-Word documents

    Hello! Anyone knows where I can find some information and example code for generating an MS-Word document with VBA? The MS-Word document must be based on a query or an table. Thanx, Martijn
  10. M

    Query in VBA

    thanx, it worked!
  11. M

    Query in VBA

    Hello! This is a part of a select query but on the where statement it goes wrong. I've got this code from an other database and there it works perfect. "WHERE [" & table2 & "].Testset = Combo_TestSet.Value AND [" & table2 & "].TestID = Combo_SelectTest.Value " When I run the code he asks me...
Top Bottom