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?
Now I keep getting the dreaded "Object Required" error at this line
.ActiveDocument.Bookmarks.Add Range:=Selection.Range, Name:="FundContact"
Here is my insertion code
With wordapp
.Visible = True
.Documents.Open (strDocPath)
.ActiveDocument.Bookmarks("FundContact").Select
.Selection.Text = rst![Client Contact]
.ActiveDocument.Bookmarks("Official_Name").Select...
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...
Because of the differences between vb and vb6 there is no simple way to get vba code to vb (any version). There is a commercial tool available at
http://www.gfminc.com/accessto.htm
I have not used the tool myself but have seen some good reports on it, you will have to do a little code cleanup...
Here is a litle piece of code that will give you the Printer, Driver and Port for each printer on your system.
Dim prtLoop As Printer
For Each prtLoop In Application.Printers
With prtLoop
MsgBox "Device name: " & .DeviceName & vbCr _
& "Driver name...
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.