How to pass a Two Date parameter to a report at runtime using VB .NET

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - How to pass a Two Date parameter to a report at runtime using VB .NET hi, How to pass a Two Date parameter to a report at runtime using VB .NET 1. How do we pass multiple values eg. @Startdate, @EndDate to crystal reports parameter. 2. I have a report to filter by two dates like FromDate And ToDate thanx Raj -- Raj Kumar Mishra jcast Networks Ltd. New Delhi. India. 91-51678212,13,14 Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46347
  - 2
    - Read the filename from the wdDialigsFileOpen dialog? Dear all, Does anyone know how to read the filename the user selects in the default FileOpen dialog, into a variable? I've tried this (in vain): ================= Dim dlgA as Dialog Set dlgA = Dialogs(wdDialogFileOpen) With dlgA .Show varB = .Name End With ================= TIA, AND Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46345
  - 3
    - Error message received when accessing the clipboard using VBA I'm looking to be able to access the clipboard contents using VBA. Here's some code which I got from this forum (guy name of Helmut posted it) Sub R_clipboard_to_variable( Selection.Cop Dim o As DataObjec Dim s As Strin Set o = New DataObjec o.GetFromClipboar s = o.GetText(1 MsgBox End Su Now this doesn't really do a whole lot of anything, but the end result will have to do with re-writing the headers and footers of about 300 odd documents. When I run this code, though, I get a Compile Error: User-defined type not defined. As I understand it, the dataObject object should be integral to VBA and not something I have to declare a class for. My copy of VBA says it's version 6.3.8863. If anyone can shed any light on this (add-in needs installing, maybe?) then I'd be most obliged Ganeth Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46332
  - 4
    - Using {MACROBUTTON} fields to insert information from Outlook Using Word 200 and XP, what is the code for using {MacroButton} fields to insert Name, Address, (or information from any other field) from Outlook into a Word document? Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46320
  - 5
    - Header/Footer Maybe I was not paying attention but the code I used to create the header of a document on the first page is not being used on subsequent pages. Is there a way in code to tell it to do so? Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46318
  - 6
    - Macros and persistence of Web tools modification I received a Word 2000 document that contains macros. It is a form with many checkboxes. The checkboxes are too big. I can change their width and length using Web tools properties, but when I save and close the document and launch it the next time, the changes are gone. I suspect that the document's macro(s) may be overwriting my changes. I have tried to find these macros using Tools/Macros, but with no success. Can anybody out there help Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46317
  - 7
    - Context sensitive help Are there any good tools for building context sensitive user help in VBA applications ? /BosseH Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46312
  - 8
    - Step through template AutoNew macro? I have a Word 2000 template with an AutoNew macro. This is called by a macro in Excel. I need to make some changes to the Word macro, but I can't seem to figure out how to step through it to see what's happening. I can step through the Excel macro, but when it hits Set WD = CreateObject("Word.Application") WD.Documents.Add the Word document and actions are invisible, and I can't see the steps. Any suggestions? Ed Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46305
  - 9
    - Tables with borders.... i wish! When I run a macro from my document in Word 97 a table is created and the borders are automatically added but when I perform the same operation in word XP the borders are non-existant. I do not understand why, even though if you insert a table manually the border are there (in XP). Is this a bug or do I need to write a macro to draw the lines back in. Is there a setting i'm missing? I just don't know!!!! Please help. Regards Rob Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46304
  - 10
    - adding text to a object Would like to add a text string to the ThisDocument Document_Open() procedure in a number of word documents that have already been created. Would do this from a main word document looping through the other docs. Need a start on how to get the vba to recognize the procedure Document_Open thanks Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46299
  - 11
    - How to add a "cloned document" Hi all, i have a word document and want to add a new one in Word. This new should have the same text and format, the old one has. I am trying since two hours, but have no idea how to "clone" documents. I tried to "wholeselect" the old one and copy it to the new, but format-differences from template, made in the old document, will not be copied. In Borland Delphi i would do someting like this... procedure Clone; begin NewDocument := WordDocument.Create; NewDocument.Assign(OldDocument); end; but dont know how to do that in VBA. Maybe anybody else has an idea... -- Erstellt mit M2, Operas revolutionärem E-Mail-Modul: http://www.opera.com/m2/ Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46294
  - 12
    - Nested tables and wdVerticalPositionRelativeToPage Greetings; I have some VBA that locates obects on a page and returns the Selection.Information(wdVerticalPositionRelativeToPage) for further processing. I have noticed that if my selection is in a nested table, then Selection.Information(wdVerticalPositionRelativeToPage) seems to return the distance from the top of the inner table, and not the top of the page as wdVerticalPositionRelativeToPage. You can notice the same thing by watch the "At:" field on Word's bottom toolbar, when you enter a nested table the field will claim you are higher that you are. So, is there a way to get the valid vertical page information in nested tables? Thanks, --Brian Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46292
  - 13
    - Messed up help screen in VBA Hi everyone, My VBA help screen is messed up and I don't know what to do to fix this. I even reinstalled Office 2000 SR1 and this did not fix the problem. The problem is that the links displayed at the top of the Help screen (like Examples, Methods, Properties, etc.) are all gone. I only see boxes with no text. Clicking on the box does nothing. I have tried to start Word using the RUN WINWORD /A method and still no go. Help!!! Thanks, George Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46290
  - 14
    - large string in vba Hi, I try to use a large string in vba code The string hold a "where" statement for a query. The maximum charaters I can put into it is 251, but the help file says the string datatype can hold up to 2^32 characters, Somebody know what I'm doing wrong ? Regards, Patrick Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46289
  - 15
    - Expanding a form Hi All, I am wanting to create a userform that can operate at two levels. Simple and Advanced. My intention is to add a commandbutton that when clicked expands the centre section of the userform to reveal some more advanced features. I cannot figure how to achieve this. Has anyone any ideas or pointers as to how I should proceed. As always, I would be very grateful for any assistance. Regards Adrian Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46286
  - 16
    - Putting data from sql server onto word form Anyone know a good tutorial (url) or a few todos about subject? /morten Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46282
  - 17
    - Determine if array contains no elements I am using Word 97 with Windows 98. On initializing a user form I want to fill a listbox with values from an array. The array is filled in another procedure. When the array contains no elements however, the listbox should not be shown. Right now my code is like this: Sub Initialize_Userform() On Error Goto Err_Handler (...) lboListbox1.List = Array1 (...) Err_Handler: If Err.Number=380 then 'Code not to show listbox End If End Sub Error 380 occurs when you try to populate a listbox with an empty array. Is there another way to determine if an array contains no elements? I know I can use UBound() and LBound() to determine upper and lower boundary, but that function also generates an error if there is no element in the array. I have searched this newsgroup, but I could not find an answer to my question. Hope somebody can help. Regards, Johan Verdouw Trainer / Microsoft Office Specialist Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46281
  - 18
    - Is this possible ? Adding Checkboxex in to a table cell with VBA I am creating a template which is basically a table. I want to know if it is possible when adding a row to my table to basically populate a cell with a check box, this will be happening for every row added. No bookmark is required as i scan the rows for the state of the checkbox on calculation stage I have been trying to do this .. and been using form fields..but cant see my checkbox appear... can some one point me in the right direction or syntax for the command i need to use many thanks to all who read / reply de vo -- remove the obvious capitals in my m@il address to send directly Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46278
  - 19
    - CLOSING OF WORD FILE hi , Any one can give me the solution for " HOW TO CLOSE THE WINWORD FILE USING VB.NET AND MS-WORD. THANKS RAJ -- Raj Kumar Mishra jcast Networks Ltd. New Delhi. India. 91-51678212,13,14 Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46277
  - 20
    - return the text from a numbered title (list) Hello, I would like to be able to *easily* retrieve the text from a numbered list paragraph (title), which is also a bookmark. E.g. from the following line 2.3.1 Dummy title I would like to retrieve "Dummy title". The bookmark would contain [Dummy title]. This seems rather simple by using something like: Dim bm As Bookmark For Each bm In ActiveDocument.Bookmarks Debug.Print bm.Name, bm.Range.Text Next However, the paragraph might contain a manual page break (because a user has entered one), which causes the bookmark to start just before this manual page break. This, of course, will make the bm.range.text property also return the page break (which i don't want). In the debug screen it's visualised as a little square, but when the string is pasted somewhere in word, it does contain the pagebreak. Does anybody knows how to *easily* get just the text? Ward Ps: I've found a workaround to get what i want (see below), but it's way to complicated. I figure it should be possible to do it more simple. 'Check if the paragraph is preceded by a 'manual page break 'because this should be removed from the range If Left(Rng.Paragraphs(1).Range, 1) = Chr$(12) Then If mDoDebug Then Debug.Print "Pagebreak before" Rng.SetRange Start:=Rng.Start + 1, End:=Rng.End End If 'Do not include 'enter' at the end of the line Rng.SetRange Start:=Rng.Start, End:=Rng.End - 1 'save range for later handling Set mTargetParRange = Rng 'Return header/paragraph text RtrnParagraphText = Trim(Rng.Text) Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46275
  - 21
    - Disabling select in office document Hi I have written an application in C# that converts values in a form, into a well formatted word document (using office automation object) I would like to protect the contents of the document. I have done the same through enabling protection (.protect method) of the document But I observed that the user is still able to copy text from my word document and paste it into notepad, word etc. I do not want this to happen How do I go about doing the same Thank you in advance Manis Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46268
  - 22
    - Password Prompting need for data entry in table cells I am utilising a shared word document with a table that is accessed b multiple users. Is it possible to define a macro that will only allo access to given cells, providing the password was imputed correctly. The table document has to be viewed by all, but only individual cell modified by given users. Please Help ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46264
  - 23
    - Read and Write Word file Hi , I am working on vb.net and word application automation application. my question is :. 1. I want to save one file into another file , example. a) my existing file name is "Raj.DOc" and containing some page. b) and second file is "Raj2.DOc" it also containing some page. c) So I want to Save "Raj2.Doc" file into "Raj.doc" file. with all the page Please help me out with code. i will be very grateful to you. Thanks and Regards Raj Kumar Mishra jcast Networks Ltd. New Delhi. India. 91-51678212,13,14 -- Raj Kumar Mishra jcast Networks Ltd. New Delhi. India. 91-51678212,13,14 Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46263
  - 24
    - running Word commands 1. 'What is the best way to run a built-in Word command from VBA? 2. Why do some built-in commands run successfully, and others don't? If I run: Application.Run MacroName:="WordRight" it works If I run Application.Run MacroName:="StartOfWindow" it doesn't work. I get an error message or nothing happens. Larry Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46256
  - 25
    - Looking for advise.. and help !!! Hi Can some one point me in the right direction because the more i read on the forums and web the more I not too sure how i should tackle a problem This is my first vba project which i have being trying to work out. I have a table with 4 columns 1-3 are data and nett wages is caculated value Employees Name ; Gross Wages ; +/- deduction % ; nett wages test user 100 +17.5% £ 117.50 test user 2 100 -20% £ 80.00 basically i need to figure out the best way of doing it. The vba method by reading the values and creating a calculation for each row or i have been reading about the SEQ method of creating a formula to step down the rows. I have been able to get anything really to work.. with method one the vba i been able to read the cell but havent got the caculation right. and the other method of having the formula in the cell.. the notes about seq has made my head hurt. So can i ask for some light and guidance.... .... many thanks De Vo -- remove the obvious capitals in my m@il address to send directly Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46252
- Next
  - 1
    - Need some sort of AutoExec (maybe) Apologies if there's a better group I could post to. Word2000 + Win2000 or XP I have a couple of mail merge documents that are recreations of some forms from our company. Each contain some checkboxes. I employed the method using AutoText/Macrobutton outlined by several posts I've seen to toggle those checkboxes with my mouse -- with a couple of twists. In order to use a single mouse click AND have the ability to use the method on a file that I've created via 'Merge to new document', I have to not only had to Attach the template to each of the two documents, but Add the template to make it global and add some code to the template's ThisDocument/Open routine to fire the template when I open either parent or merged document and make single clicking work. Here are the routines for that template as they stand. ThisDocument: Private Sub Document_Open() AddIns("C:\data\word\CheckBox.dot").Installed = True Options.ButtonFieldClicks = 1 End Sub ChkBox Module Subs: Sub CheckIt() ActiveDocument.AttachedTemplate.AutoTextEntries("Checked Box").Insert Where:=Selection.Range End Sub Sub UncheckIt() ActiveDocument.AttachedTemplate.AutoTextEntries("Unchecked Box").Insert Where:=Selection.Range End Sub Everything works exactly as desired, so I guess I shouldn't complain, but there is one tiny cosmetic flaw. When I open the menu Insert | AutoText, I see TWO entries each for 'Checked Box' and 'Unchecked Box'. Aargh!!! I wrestled all weekend to adjust the file placement and code to both load the template and fire the Document_Open routine so I could eliminate the need to Attach the template to each file and still have the ability to single click in all files and reduce the AutoText entries to a single instance. No matter what I tried, there was always one piece of the puzzle missing. Any help? I want to have my cake and eat it too!! One caveat: I want the template to remain in C:\Data\Word for two reasons: 1) I backup this folder to two other machines daily and 2) since the AddIns() line requires the full path, if I placed it in Word\Startup, that's a looong path and unique for each machine. -- David Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46250
  - 2
    - PageSetup object: changing papersize changes also orientation?! Hi everybody I have a problem with a document template. The orientation of my template is set to landscape. When users opens the template, the code will check the preferred papersize from users settings (I'm having my own configuration utility for templates to set all defaults like interface language, papersize etc.). In previous Word version (97 and 2000) changing papersize had no effect to the page orientation but now in Word 2002 when I'm changing the size through code i.e. from European A4 to US Letter, Word also changes the orientation of the page from landscape to portrait! If I do the same thing manually from File/Page setup menu, orientation does not change The next problem is, that I cannot change the orientation programmatically back to landscape, because there is a bug in Word. An article in knowledgebase says (http://support.microsoft.com/default.aspx?scid=kb;en-us;275966) ----------------------------------------------- "In Microsoft Word 2000, when you run a Microsoft Visual Basic for Applications macro that accesses the PageSetup object from the Document object or the Section object, you receive the following error message: Run time error '4605'. This command is not available. This problem can occur if all of the following conditions are true: Your document contains a frame (not to be confused with an HTML frame or a frame page) -and The frame contains a table -and The frame is anchored to the first paragraph in the document -and You run a Visual Basic for Applications macro from Word, accessing the PageSetup object from the Document object or the Section objec ------------------------------------------------- Unfortunately my case meets all these conditions. The same article says, that this problem is corrected in Word 2002. This is not true, because I'm having the same problem in Word 2002. In Word 2000 this bug did not cause any harm in my template, because changing the papersize did not have any effects to orientation. Does anyone have solution or hint for this Regards E. Lehto Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46245
  - 3
    - Can't reference a .dot via code Hi I'm trying to reference in a .dot template file with code ('code.dot') into another template file ('test01.dot'). I use this code (both files are in the same directory): test01.dot [code] Private Sub Document_New() Dim msgBoxen As Variant ThisDocument.VBProject.References.AddFromFile Templates(1).Path & "\code.dot" 'referencing the code file msgBoxen = MsgBox(Templates(1).Path & "\code.dot is the path", vbCritical) 'Debug code to show the path Test 'Trying to call a sub from the reference file End Sub [/code] code.dot [code] Public Sub Test() Dim msgBoxen As Variant msgBoxen = msgBox("Hello", vbCritical) End Sub [/code] When I use the test01 template i get this error: Compile error: Sub or Function not defined Do I have to activate the reference code in some way? When I reference the code via Tools -> Reference it works fine. I have also tried to use the absolute file path in the reference code, but it still dont work. What have I done wrong? Ps I have tried to repy with this question in a previous thread but it didn't work, so I'm sorry to have to create a new one. :/ Ds Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46244
  - 4
    - processing multiple word files to save as html Is there a way I can open multiple Word documents in a folder (C:\WordDocs\input, for example), save them as Compact HTML (I've downloaded MSFilter.dot), then save the resulting HTML files in a different folder (C:\WordDocs\output, for example)? I tried using the Batch Conversion Wizard (File > New, then "Other Documents" tab, then selecting "Batch Conversion Wizard, but I don't have access to it. Plus I'm on a network, and don't know if/when I can get this feature installed, so finding an alternative is probably going to be my fastest solution. Thanks. Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46237
  - 5
    - Envelope objects Feedsource Property Hi All, I am working with Word's Envelope object and I've found some bizarre behavior. This is totally dependent on the print driver. When you query a print driver using the API call getdevicecaps it returns printer tray ids as longs. I can then set the Envelope.feedsource = to one of these tray id's. All is good in the world, until. If the print driver returns anything above a number 15, setting this property will fail. Now for the bizarre part. If you query this property for the default tray and it happens to be above 15 it won't fail. So I have a situation where the property = 257 and when I try to set it to 257 I get a message telling me that the parameter is outside of acceptable limits. Anybody else run into such a beast? Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46236
  - 6
    - finding just docname in File search I'm using a file search and I want to be able to seperate a docname from a path name in the found files? Is there a way to do this without looking for backslashes from right to left? I want to be able to change the names of actual docs, and cant if I don't know the docname without the path name of subdirectory name. spammastergrand@aol.com Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46233
  - 7
    - merging pdf files trough Word VBA -> possible? Hello, I'm developing an Word add-in the will create one Word document from several Word documents. This file will then by converted (printed) to a pdf using PdfWriter. No problem with this first part. However, I would like the add-in to append some existing pdf's to this final pdf. So the whole operation would result in one (large) pdf file that originates from a couple of word files and a couple of existing pdf files. I'm not sure that this (appending extra pdf's) is possible through Word VBA. Does anybody has any idea about this? thanks in advance, Ward Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46230
  - 8
    - spellchecking again Hey there, with the help of some guys here, I managed to create an automated list of spelling errors in word documents. I used the following code: -------- Sub ListSpellingErrors() Dim lngSpellErrCnt As Long, n As Long, FFile As Integer lngSpellErrCnt = ActiveDocument.SpellingErrors.Count FFile = FreeFile 'DateiHandle Open "C:\SpellErr.txt" For Output As #FFile For n = 1 To lngSpellErrCnt Print #FFile, ActiveDocument.SpellingErrors(n).Text Application.StatusBar = n & " / " & lngSpellErrCnt & " Fehler verarbeitet..." Next Close #FFile End Sub -------- It works quite ok, actually, but it's unbelievably slow. Can anyone tell me why? Thanks, Sebastian Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46229
  - 9
    - DocumentAfterPrint Hi, I can find the event DocumentBeforePrint, but is there a DocumentAfterPrint? / Ulf Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46228
  - 10
    - Populate listbox from another file I want to say thanks to Peter and Doug the another day helping me with the code for populating a listbox with data from another file in a table. I have another question: The word template that I am setting up is going to be used by many other people within my organisation who doesn't have access to the network that I save the data file in. . I am afraid that the little program won't work. Is this true? The templatea are going to be loaded onto our coy's Intranet, can the code Set sourcedoc = Documents.Open (FileName:="e:\worddocs\Clients.doc") make reference to an URL instead of a file directory? JT Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46224
  - 11
    - Identifying when cursor is in a table I know this is probably very basic, but I can't fathom it. I am doing MoveUp a line at a time. How can I detect when I am in a table. Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46214
  - 12
    - deleting a specific page How can I select and delete a specific page from a document? I've created a form from which some pages will not necessarily be required. Thanks Laurie Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46211
  - 13
    - getting a style to start the next page Hi all, I am programatically filling a doc with data. All the data appears under a heading (the heading is the job number which has been formatted as style Heading1) I want to avoid a situation where the data relating to a single Job number straddles two docs. In other works:- If the whole job details cannot fit on the same page, then insert a page break and start that job at the beginning of the new page. Am I on the right lines by assuming that the best way to go would be to programmatically check that the first line in the doc is formatted Heading1. If not then insert a page break just before the previous instance of Heading1. If this is the best way, can anyone help me with some code or at least a point in the right direction. Thank you Adrian Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46207
  - 14
    - activex message when starting help or vba help Using word 2000. I had to reinstall because of registry glitch. Now every time i start help or vb help i get the following message "An activeX control on this page might be unsafe to interact with other parts of the page, do you want to allow this." .......... with yes no buttons. anybody know what this is and how to stop it? Thanks BRC Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46206
  - 15
    - Spell Check How do I perform spell check in wordpad 5.1 ?????? Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46205
  - 16
    - opening windows crashes my computer I'm having some trouble. When I try to open word my computer will either freeze or I get an error saying that I don't have enough resource to run this program and then my whole coputer needs to be shut down. If I do get word to open I soon have the same result. could this be a result of some virus? Should I delete the program from my hard drive and then reinstall it? Will this erase my files that I created in word? Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46204
  - 17
    - Setting a Macro to start on startup How would I do this? Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46193
  - 18
    - find first empty line i want a macro to search in a documend and when finds the first empty line then select and copy the text above the empty line till the begining of the document. for example. < bla bla bla bla bla bla bla bla bla bla bl bla bla bla bla bla bla bla bla bla bla bla bla bla bla uuuuuu uuu ttttt wwwwww fff mmmmmm mmmmmm mmmmm text text text ggggg gggggg gggg etc. > lets say that we have the above text .The macro must finds the empty line and then select and copy all the paragraph with (bla bla bla) Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46192
  - 19
    - Removing spaces from a varible I have data i am pulling from a mainframe screen. 1 of the varibles is 72 characters long and contains customer first name, Mi and last name. I need to parse the variable into fname, lname, Mi. Is there a way to just go through the varible and replace each instace of 2 spaces with one space. It doen't always have a MI. Using word 2000. Thanks BRC Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46189
  - 20
    - VBA Help Our mainframe formats some of our reports to have multiple reports in one file end-to-end. Each report begins with SAM5XXX. I would like to put a page break at each instance of SAM5. The below macro works, but it puts a blank page at the beginning of the document, thus the two lines after the "Loop". Can anyone suggest how to clean up the code to it does not put a blank page at the beginning? Thanks for your help! Sub SAM5_PageBreak() ' ' ' With ActiveDocument.Content.Find .ClearFormatting Selection.MoveDown Unit:=wdLine, Count:=2 Do While .Execute(FindText:="SAM5", Forward:=True, Format:=False) =True With Selection.Find .Forward = True .ClearFormatting .MatchWholeWord = False .MatchCase = False .Wrap = wdFindContinue .Execute FindText:="SAM5" Selection.MoveLeft Unit:=wdCharacter, Count:=1 Selection.InsertBreak Type:=wdPageBreak Selection.MoveDown Unit:=wdLine, Count:=2 End With Loop Selection.HomeKey Unit:=wdStory Selection.Delete Unit:=wdCharacter, Count:=1 End With End Sub --- TJ Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46183
  - 21
    - Keyboard shortcuts to existing macros How do I add a keyboard shortcut to an existing MS Word macro? Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46181
  - 22
    - Determining if cursor is off-screen How would you determine programmatically if the cursor is not in the visible window, but scrolled off screen? I have a line of code that I want to run only if the cursor has gotten scrolled offscreen. Larry Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46179
  - 23
    - Working with controls in a word document In WOrdXP I have a word form (not a user form, but a word doicument created using the form facilities) in which I wish to manipulate the controls I have in a form. If I use code like: Dim ctlFrom As Control Set ctlFrom = Me..lstbxSubjectSelected it doesn't work, type mismatch as the right hand side is evaluated to the value of the default property of the control rather than the control itself. And as there is no COntrols collection for a WOrd document code like this fails too: Set ctlFrom = Me.Controls("lstbxSubjectSelected") How do I achieve this. Thanks M Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46174
  - 24
    - Bookmark: how to tell if cursor is in one? And which one? Assuming there are bookmarked chunks of text in a document, How can I tell if the cursor is in a bookmarked chunk of text or not? How can I tell which bookmarked chunk of text the cursor is in an highlight that bookmark's text ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46172
  - 25
    - QUOTES "word" Office 2000. Windows 200 Pro & Windows M I would like to develop a method to select all text and puts quotes ("word") around each word that I select For example - Microsoft Word is better than everything else Would become - "Microsoft" "Word" "is" "better" "than" "everything" "else" thank --mike Tag: How to pass a Two Date parameter to a report at runtime using VB .NET Tag: 46165

hi,

How to pass a Two Date parameter to a report at runtime using VB .NET

1. How do we pass multiple values eg. Startdate, EndDate to crystal
reports
parameter.
2. I have a report to filter by two dates like FromDate And ToDate

my Code is following which i have written.

It shows Error like " Date time Required"

Dim SelectFormula1 As String

SelectFormula1 = "{tblSample_Master.DateOut} in '" & StartDate & "' to '" &
EndDate & "'"

CrystalReportViewer1.SelectionFormula = SelectFormula1

CrystalReportViewer1.RefreshReport()

CrystalReportViewer1().ReportSource =
"D:\KOTITI\RptSummaryReportFromDateToDate.rpt"

thanx
Raj

--
Raj Kumar Mishra
jcast Networks Ltd.
New Delhi.
India.
91-51678212,13,14

Top

Re: How to pass a Two Date parameter to a report at runtime using VB .NET by Doug

Doug
Wed Feb 18 05:30:37 CST 2004

What are Crystal Reports? OK, I know, but this is not the correct forum to
ask about them. This newsgroup is for Visual Basic as it applies to
Microsoft Word.

Try http://www.crystalkeen.com/articles/crystalreports/newsgroups.htm

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
"Raj" <rajkumar@jcastnet.com> wrote in message
news:OZddcjg9DHA.2460@TK2MSFTNGP09.phx.gbl...
> hi,
>
> How to pass a Two Date parameter to a report at runtime using VB .NET
>
>
> 1. How do we pass multiple values eg. Startdate, EndDate to crystal
> reports
> parameter.
> 2. I have a report to filter by two dates like FromDate And ToDate
>
> my Code is following which i have written.
>
> It shows Error like " Date time Required"
>
> Dim SelectFormula1 As String
>
> SelectFormula1 = "{tblSample_Master.DateOut} in '" & StartDate & "' to '"
> &
> EndDate & "'"
>
> CrystalReportViewer1.SelectionFormula = SelectFormula1
>
> CrystalReportViewer1.RefreshReport()
>
> CrystalReportViewer1().ReportSource =
> "D:\KOTITI\RptSummaryReportFromDateToDate.rpt"
>
> thanx
> Raj
>
> --
> Raj Kumar Mishra
> jcast Networks Ltd.
> New Delhi.
> India.
> 91-51678212,13,14
>
>

Top