Search:
Type: Posts; User: A441OTA
Search:
Search took 0.02 seconds.
-
You can in fact record macros in PowerPoint - I will tell you that it is not as extensive and easy to update as macros in Word, but you can do it. I use Office 2003 and have been automating Office...
-
Good morning everyone, :wave:
I have done a little searching but am not familiar enough with the subject to find what I'm looking for (other than I suspect I need to learn something new!).
I...
-
Hi Cid,
The most efficient approach is to use the numeric picture format switch with your field code. I use these types of switches to ensure decimal presentation at specific places when the data...
-
It looks as if you are missing the parenthesis around the entire expression you need to convert. Try:
Expr1:...
-
A few words of caution in working with Word:
Be VERY careful using "direct formatting" (that's what you are doing when you apply bold and such).
I highly recommend you start with a pre-designed...
-
Hi Greg,
You will probably need to execute the query through Access first. Then use this query as your connection for the mail merge. Word requires a physical table or query to connect to for...
-
Ranges help you manipulate documents, but it is not an absolute necessity that you use them... this is dependent on what you are creating and doing and how much "planning" (i.e., building templates,...
-
Hi SmileyFace,
You can use the open or add method then do a saveas and end up with the same results. If you don't feel comfortable opening the template with the open method, use add (as follows):...
-
Hi Prototype,
I use ADO to connect to an Access 2002 database, here is the code I use
'String used to connect to the SRT database -- this allows for network use in the future
'Keep in module...
-
Good morning!
I have an issue with my program after installation.
Operating System -- Windows 2000
Development -- VB 6.0 SP6
Packaged with Windows Installer (as directed by the systems...
-
Hey SmileyFace, try the following:
objWordApp.Documents.Add DocumentType:=wdNewBlankDocument
objWordApp.ActiveDocument.SaveAs "c:\testdoc.doc"
This will create a new document based on...
-
For future reference...
To keep it "neat", check for the existence of the bookmark first and then delete it. You shouldn't need to use the range object when deleting bookmarks.
To delete a...
-
Hi Vince,
I've never worked with OLE objects, however, all of my data is sent to Word for various reasons. All of my reports are Word templates that I open new documents based on the specific...
-
God Bless you Bruce!!!!
Thanks so much that did the trick!!!! It also worked in the data entry screens as well when I pulled up the recordsets then!!!
Have a great holiday!
-
Good afternoon and TGIF!!
I have a database program that supports a survey process. I need to be able to sort questions by question number and subitem, for instance 1a, 1b, 1 c, etc.
I have...
-
Alan,
The easiest thing to do is open up your merge file, record yourself doing the merge (walk through the setups during recording), then review the code and use in your program. This is the...
-
Willy,
I agree with Bruce!
I tried a few things to keep the format dropdown menu down to use multiple times but to no avail!
If you select multiple controls by holding the shift key down...
-
Salvatore is your report setup static enough that you could create a template in Word that puts bookmarks in the appropriate cells to send the data to? So that all you have to do is open the...
-
Okay, this one is a bit more difficult than it sounds.
Using the word.count does not count as you think it would. As indicated, it does count things like commas and periods as words... don't...
-
Thank you again! That's wonderful advice on the end program code Martin -- I don't have it that way in my "actual" program I'm writing for my client, and I did not know that anyway, so that is great...
-
Thanks Martin. However, I created a test project and quickly tested it, and maybe this isn't exactly the right answer but this works by accomplishing the following:
1) getting Word if it is open...
-
You can also get a count of active documents first...
If Application.Documents.Count >= 1 then
*do whatever*
Else
MsgBox "No documents are open"
End If
-
Here are some things to try and/or consider...
.activedocument.activate
Not sure it will work because all of my Word automation is "controlled" so that my program opens specific files and I...
-
Thanks Vince... now let me clarify (my bad!)...
I need to write code that does this through my VB 6.0 frontend!!
I have not attempted yet to automate Access, maybe I'll play with it this...
-
Good morning,
What is the best approach for finding and replacing parts of strings in an Access database? For instance:
The database field could contain the following string:
Q4 = "Married"...
-
Thanks Vince!
I will keep everyone posted and will watch for other postings in the meantime!
I have a request to systems that I receive a copy of Office 2003 at least a month prior to the users...
-
Try this instead:
.Selection.InlineShapes.AddPicture FileName:="yourpath.yourgraphicfilename.ext", _
LinkToFile:=False, SaveWithDocument:=True
Insert file is for just that, files......
-
Good morning one and all!
I have been informed by our systems folks that they will be migrating all users to Office 2003 in the next couple of months. Yesterday I did some research and first off...
-
Thanks all!!
I guess my program is straight-forward enough the VSI worked perfectly with little learning curve!! Another posting pointed me to a very succinct overview and procedure for...
-
Good morning!
I have a database application that sends all of its data to Word. The templates are set up as mailmerges. I was not able to get Word to use a recordset for a mailmerge. What I do...
-
Shaman that's a really strange problem... I couldn't reproduce your problem.
Things to check are:
Check the format set in Access to store the time AND then check the format you have in your...
-
Here is the connection I'm using to an Access 2002 database. I haven't had any connection problems (well none that weren't my fault anyway!! LOL!). Jet 4.0 has been working for me for two years.
...
-
Hey Froggy,
I send my data from Access to Word templates in a mail merge format. The template can be set then you send the data where it needs to. How "robust" do you need your solution to be??
-
Hi Tazzzman,
You don't state which version of Access you are using... it could simply be that you need to be using the updated jet for Access 2000 and 2002 -- "Provider=Microsoft.Jet.OLEDB.4.0"...
-
Good morning!
My VB app (6.0) creates multiple mail merge documents, combines them, and then allows the user to convert this doc to PDF via Adobe PDFWriter (as a printer). The conversion works...
-
Here is what I use in a loop that creates over 100 mail merge documents from an Access database:
'check for existing instance before opening again
If objWord Is Nothing Then
...
-
Create a letter template that has everything except the body and simply insert a text form field where the body will go if they are typing it when the document gets opened. You can edit a text form...
-
Thanks Techgnome, sorry about putting that out there (my docs are still compiling... I should have waited!!!). Now I'll have to go investigate exactly what the mouseover event does!!!
-
I'm still kind of new too, however, isn't this done with a mouseover event? My VB is compiling a huge document right now so I can't go try it but I think that's what I remember...
Do a search on...
-
Is the text between the bookmarks a paragraph? multiple paragraphs? Is it consistent?
The reason I'm asking is that if it is the entire paragraph that will be replaced, simply place the bookmark...
|
Click Here to Expand Forum to Full Width
|