Search:

Type: Posts; User: A441OTA

Page 1 of 2 1 2

Search: Search took 0.08 seconds.

  1. Replies
    17
    Views
    75,481

    Re: PowerPoint Macro Recording?

    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...
  2. Replies
    1
    Views
    466

    Convert Access to XML without schema

    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...
  3. Replies
    1
    Views
    453

    Re: MailMerge Loses Table Formatting

    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...
  4. Replies
    1
    Views
    315

    Re: Help with MS Access: text format

    It looks as if you are missing the parenthesis around the entire expression you need to convert. Try:

    Expr1:...
  5. Replies
    20
    Views
    2,113

    Re: Create a Word Document

    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...
  6. Replies
    1
    Views
    446

    Re: opening up mail merged .doc

    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...
  7. Replies
    20
    Views
    2,113

    Re: Create a Word Document

    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,...
  8. Replies
    9
    Views
    1,344

    Re: open word from vb

    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):...
  9. Replies
    3
    Views
    432

    Re: Connection to access DB

    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...
  10. Still need help please... Installation - works as ADMIN, but not for users

    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...
  11. Thread: word

    by A441OTA
    Replies
    4
    Views
    531

    Re: word

    Hey SmileyFace, try the following:

    objWordApp.Documents.Add DocumentType:=wdNewBlankDocument
    objWordApp.ActiveDocument.SaveAs "c:\testdoc.doc"

    This will create a new document based on...
  12. Replies
    2
    Views
    2,074

    For future reference... To keep it "neat",...

    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...
  13. Replies
    2
    Views
    348

    Hi Vince, I've never worked with OLE objects,...

    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...
  14. Replies
    5
    Views
    462

    God Bless you Bruce!!!! Thanks so much that...

    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!
  15. Replies
    5
    Views
    462

    Sorting text "properly"

    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...
  16. Alan, The easiest thing to do is open up your...

    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...
  17. Thread: Access tricks

    by A441OTA
    Replies
    3
    Views
    354

    Willy, I agree with Bruce! I tried a few...

    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...
  18. Replies
    18
    Views
    769

    Salvatore is your report setup static enough that...

    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...
  19. Okay, this one is a bit more difficult than it...

    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...
  20. Replies
    14
    Views
    2,508

    Thank you again! That's wonderful advice on the...

    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...
  21. Replies
    14
    Views
    2,508

    Thanks Martin. However, I created a test project...

    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...
  22. Replies
    14
    Views
    2,508

    You can also get a count of active documents...

    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
  23. Replies
    14
    Views
    2,508

    Here are some things to try and/or consider... ...

    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...
  24. Thanks Vince... now let me clarify (my bad!)... ...

    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...
  25. Find and replace in Access (2002) multiple parts of strings

    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"...
  26. Replies
    2
    Views
    265

    Thanks Vince! I will keep everyone posted and...

    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...
  27. Replies
    1
    Views
    381

    Try this instead: ...

    Try this instead:


    .Selection.InlineShapes.AddPicture FileName:="yourpath.yourgraphicfilename.ext", _
    LinkToFile:=False, SaveWithDocument:=True


    Insert file is for just that, files......
  28. Replies
    2
    Views
    265

    Access 2002 to Access 2003

    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...
  29. [Resolved with VSI] Package with external folders and files

    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...
  30. Replies
    3
    Views
    951

    Good morning! I have a database application...

    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...
  31. Replies
    2
    Views
    397

    Shaman that's a really strange problem... I...

    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...
  32. Replies
    4
    Views
    415

    Here is the connection I'm using to an Access...

    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.
    ...
  33. Replies
    1
    Views
    388

    Hey Froggy, I send my data from Access to Word...

    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??
  34. Replies
    2
    Views
    399

    Hi Tazzzman, You don't state which version of...

    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"...
  35. .doc conversion to .PDF, drops header/footer lines

    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...
  36. Replies
    11
    Views
    835

    Here is what I use in a loop that creates over...

    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
    ...
  37. Create a letter template that has everything...

    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...
  38. Replies
    5
    Views
    1,087

    Thanks Techgnome, sorry about putting that out...

    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!!!
  39. Replies
    5
    Views
    1,087

    I'm still kind of new too, however, isn't this...

    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...
  40. Is the text between the bookmarks a paragraph? ...

    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...
Results 1 to 40 of 78
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width