I have captured the fileSave as Menu so I can run a naming macro. The problem I have is that If I have two Documents Open and I save, The First File is saved with the new file name. for instance if I have Doc1 and doc2 and do a save as on doc2 with the name set as doc3. Doc1 is saved under the...
I have created a global template that modifies the file menu and adds a couple of user forms. the glbal template will reside in a users template folder on the network and is tied to the users Normal.dot. If I change the code in my global template is there a way that I can distribute the changes...
I am trying to do a macro that will bring up a dialog box with a list of forms. when the user selects a document type (ie Letter, Fax or Memo) a unique identifier is created consisting of a prefix and a sequence number so the data wouold look like
Column 1 Column2 Column3
Letter ltr...
Need to find out how to add pictures to the image list control and then assign them to nodes (branches/leaves?) in a Treeview Control. This is for a user form in word. All of the documentation that I can find says to add an image to an image list through the image tab. When using the vb editor...
I am running a word report from access, I am using a template and a document created from that template when I set the application visible property to false I do not see the document but I do see the template, How do I turn to application to not visible?
I am trying to delete the text that has been inserted into a bookmark programatically.
I tried
With wordapp
.ActiveDocument.Bookmarks("FundContact").Select
.Selection.Text = " "
.ActiveDocument.Bookmarks("Official_Name").Select...
I am trying to add a table to a word document from access and keep getting the dreaded "Object Required" at wordapp.ActiveDocument.Tables.Add Range:=Selection.Range, NumRows:=1, NumColumns:=5
OK so I may be the only one that dreads it.
Dim dbs As Database
Dim wordapp As Object
Dim...
What I am trying to accomplish is to open a word document from access and publish the results of a query into a table in word. I have 2 problems
When I try to instantiate word with
Private Sub cmdOutputCorel_Click()
Dim wordapp As Application
Dim rst As ADODB.Recordset
Set wordapp =...
I need to incorporate a search engine into my database, Users should be able to select any field from any table and search that field (or Fields). Can someone maybe let me know of a reference or site that will help me get started.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.