Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: marcello62
  • Content: Threads
  • Order by date
  1. marcello62

    how to handle bookmarks in a table in a word document using vba for applications

    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...
  2. marcello62

    how to deal with bookmarks within a table?

    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...
  3. marcello62

    How can I format a bookmark?

    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...
  4. marcello62

    Browse for a directory

    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...
  5. marcello62

    terminate winword.exe with vba

    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...
  6. marcello62

    How to fill a field in crystal reports

    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...
  7. marcello62

    Runtime error on closing application

    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...
  8. marcello62

    External DLL not recognized again

    Hi there, I have an application running in Delphi, consisting, among other components, of two dll's talking to each other. Now, I want to rewrite one of them in C#. Therefore, I am trying to call a Delphi DLL from C# and a C# DLL from Delphi. Thanks to a tip on this forum I got the Delphi DLL...
  9. marcello62

    External DLL not recognized.

    Hello, I have written a very simple dll in Delphi, it only contains one procedure which generates a message. I have done this for test-purposes, because I want to call the .dll from C#. I registered the .dll with regsvr32, and I try to set a reference to it in C#. However, I get the error...
  10. marcello62

    USE VARIABLE IN SQL

    Hi there, I am new in Db2, and for my first project I try to use an SQL statement in a stored procedure, the statement getting it's values from variables. However, I can't seem to link the variable to the statement: SET sSql = 'UPDATE EIGENAAR SET SALDO= ' || @BEDRA; This does not work...
  11. marcello62

    Excel .xls file opens four times

    Hi there, I have created an Excel .xls file. When I try to run it it opens up four times. I can see this from the windows menu at the top of the screen, showing four open windows, named: name.xls:1 name.xls:2 name.xls:3 name.xls:4 These entries are also visible in in the Excel Icon in the bar...
  12. marcello62

    How to add a database field in a startup script

    Hi there, I'm wondering if it is possible to use some kind of option in a shortcut command to add a column to a Microsoft Access database. Maybe there is startup parameter to accomplish this? Any help will be greatly appreciated, Thanks.
  13. marcello62

    Run Access from USB stick?

    Hi there, I am responsible for several apps in MS Access, running on all the platforms, starting with MS Access 2.0. (!) going all the way to MS Access 2003. Most of my clients are reluctant to update. For me this is a difficult situation since my administrator only permits Access 2003 to run...
  14. marcello62

    Problem with .XSLT transformation

    Hi there, I have to convert about 20.000 big .XML files to .txt format. Therefore, for each file I use 5 .XSLT stylesheets to render 5 .txt files, which I want to get together using C# syntax. However, I have problems looping through all the .XML files, the program crashes. I noticed this...
  15. marcello62

    XMLTextReader can't read part of XML attributes

    Hi there, I use the XMLTextReader class to process an .XML file. To keep things simple I'll list one line of a test file: <CUSTOMER ID="1"> I use the XMLTextReader.Name method to return "CUSTOMER" I use the XMLTextReader.GetAttribute() method to return "1" Now I'm looking for some way to return...
  16. marcello62

    How to get data from an access query in a word document?

    Hi there, I have a word document, and I want to insert several positions in this document from an MS Access database. The database table which the query is based on represents clients, and a whole batch of letters has to printed out. Does anyone know how I can implement the link between MS...
  17. marcello62

    How to reduce space between report lines in code

    Hello, I design a report using the following code: 'begin Dim txtNew As Access.TextBox Dim labNew As Access.Label Dim lngTop As Long Dim lngLeft As Long Dim lblCol As Long Dim rpt As Report Dim strSql As String Dim db As Database Dim rs As Recordset Dim i As Integer Dim...
  18. marcello62

    How to select an image in a form?

    Hi there, I want to add a reference to the file-path of a picture to a database table. In the user interface, users should be able to select the picture in a picturebox (I guess this is the right control). I'm looking for a way to get to the file-system in some sort of control, and use this...
  19. marcello62

    How to activate a refresh of a list on form1 by closing form2?

    Hi there, I have a form (form1) with a list. From this form, I open another one (form2)in which I can change some settings. Form2 allows me to change some settings. After doing so, I can close form2, and I return to the underlying form1. The list on form 1 get's it's data from the settings...
  20. marcello62

    How to sort a report in code?

    Hi there, I have an MSAccess 2000 database with a report which I want to sort in code. I converted this database from MS Access 97 to MS Access 2000. The report has the query queryname as it's recordsource. When it ran under MS Access 97, I sorted the report in code by setting the orderByOn...

Part and Inventory Search

Back
Top