Recent content by marcello62

Thanx for all the help! @mintjulep: I had noticed before the range method did not work at all, not outside tables and not inside tables. Then, I noticed that the select method worked, but only outside tables, not inside tables. But in the end macropod proved that using the range object...

Hi there, I use vba code from an ms access code module to format bookmarks in a word document. Therefore I use the following code: doc.Bookmarks("mv5_5").Select Selection.Font.ColorIndex = wdRed Selection.Font.Bold = True This works fine for most of the bookmarks, but for bookmarks...

I guess you are right about the fully qualifying the bookmarks, it's better practice, but this code works outside the tables. Formatting the bookmarks would not help because the colors and the bold property I set are dependent on conditions which I test in the code. I'll repost my question in...

Hi there, I use vba code from an ms access code module to format bookmarks in a word document. Therefore I use the following code: doc.Bookmarks("mv5_5").Select Selection.Font.ColorIndex = wdRed Selection.Font.Bold = True This works fine for most of the bookmarks, but for bookmarks within a...

This worked! Apparently the tric was to select the bookmark before manipulating it's font. Thanx very much!

Hi there, I fill a word document from a ms access vba code module using bookmarks. Now I want some bookmarks to be represented in a color, say green. I fill the bookmark: doc.Bookmarks("b1718_1").Range.Text = doc.Bookmarks("b1718_1").Range.Text = Format(rs!mv5_1_10p, "0.0") This works. Then I...

Thanks PHV, MajP, Actually I came across another solution, which consists of passing the msoFileDialogFolderPicker parameter while initializing the file dialog object: Dim fDialog As Office.FileDialog Set fDialog = Application.FileDialog(msoFileDialogFolderPicker) This also works fine.

Hi there, I'm using an MS Office FileDialog to browse for and select a file. This works fine. Now I want to let users browse for and select a map in which they can drop an output file. So this functionality should show only maps, not files. Does anyone know how to do this? Any help will be...

Hi there, I use code for file selection which contains, among others, the following lines: Dim fDialog As Office.FileDialog Set fDialog = Application.FileDialog (msoFileDialogFilePicker) With fDialog .AllowMultiSelect = False .Title = "Selecteer de gele lijst"...

My code looks like this: Private Sub cmdSplits_Click() 'Splitsen stageverslagen 'Auteur: Paul Gransbergen Dim db As Database Dim rs As Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("tblDocInhoud") DoCmd.SetWarnings False Dim wordApp As...

Thank you all for your reactions. I think indeed that the Quit statement terminates the winword executable. I was only familiar with the Set .. = nothing and the close statement. Moxy 1, your code looks great! I tested it tests the active status of all kinds of executables. Do you perhaps know...

Hi there, I'm running an app with code to manipulate a word document. The problem is that after running the code, including lines like wordvariablename.close and set wordvariablename = nothing, there are still numerous winword.exe processes active in the windows task manager. Does anyone know...

Thanks Ido, But the retrieval of the users is not the problem. The problem is how to get them in a field on a report which is already defined - based on a dataset. So the report is a set of records from a database, and I want to pass the names as strings to a field in the report or page header.

Hi there, I have created a crystal report based on a dataset. In the page header, I want to display the name of a user, who can be known in code at runtime but who is not registered in the database. I'd like to know if there is a method to get this information in a textfield in the pageheader...

Hi there, I'm maintaining a DLL written in Delphi 7. This DLL is compiled together with others to work together with an executable delivered by an external supplier. This executable is compiled from Delphi Sources but we don't have access to the sources. Every now and than this main program is...