Search results for query: *

...is the current code piece: Set App = CreateObject("CrystalRuntime.Application.9") Set Rept = App.OpenReport(fileName) '** // continue with code to populate report, etc. '** // there are three final output options, export '** // to txt file and save as work...

Actually, I was close all along, I was treating my strVal (the string from the .log file) as a number or Date using #'s around it. After I saw your post I modified the code to this: Rept.recordselectionformula = "{@DateCombine} > DateTime('" & strVal & "')" now it...

Thanks for your response. The problem is, I can't use now() when trying to set the recordselectionformula. After I run the procedure I WRITE OUT Now() to mark the last time this application ran. So the next time I run the Crystal Automation script I need to pass in this value. So the last...

...combined these two fields into one formula that I use as a datetime stamp: the formula is called @DateCombine, and it has this simple formula: ********************************************************* DateTimevar timeStamp; timeStamp:=DateTime({TWDATA.LastChangeDate},{@convertNum})...

I have had a very bad day with Crystal (an unrelated export issue) and I really need some help because now I am frusterated :). Basically I have a time field that is stored as a number. The values range from 838.00, 1,763.00, 936.00,etc. Basically these represent Military time within the SQL...

I have already downloaded this hotfix, but I thank you. If you have any other ideas please let me know...thanks

Crystal Experts: I am hoping that someone can clarify some horrible issues I am having with Crystal Reports 9. I have been developing CR Reports for about two years now and I am very familiar with connecting, formula writing, etc. Recently, I started a new job and I have hit a real wall with...

Hello: I posted a question earlier, but I think I need to step back an inch. OK, I have Crystal Reports 9 and Crystal Enterprise 9. I have a finished Crystal Report. I have never used Crystal Enterprise before. Basically, I want to view this report on the web server (the server with Crystal...

I have a question regarding publishing Crystal Reports over the web. I have developed CR reports for about two years, but my only experience has been with ADO/ODBC connections. Currently, we have reports connecting to a Pervasive SQL Datasource. We are NOT using an ODBC connection. The...

Hello: I have been developing Crystal Reports for a while now, but I my previous encounters have all been with ADO/SQL/ODBC data sources. At my position, we currently use library or ddf files to connect with Crystal. One of our clients has Crystal Version 8 and wants to move their existing...

I am at my wits end over here...need some help. I have a large Word module that I am re-writing. Now on certain documents the MACROS are protected. Now the ActiveDocument itself is not protected. The following code produces no results because it is not protected: ActiveDocument.unprotect...

Thanks Andy, it was the append feature..now it works

Andy: I tried this, it does not work...see the code below, all I get is one line printed from the very first entry: With Documents(1) For Each aBook In .Bookmarks j = fn1 & " " & .Bookmarks(aBook).Name Open "C:\worddocs.txt" For Output As #ff...

Hello...I am trying to loop through a large folder with many Word templates...I need to extract the names of the boomarks, fields, and macros in these templates. I have the following steps done: 1) Function to recursively loop through the directories 2) A nested function to get the file...

any ideas? :)

...into full-cycle software development. I am proficient with searching directories in VB, getting the properties of tables, names, etc. I am not *very* familiar with Macros and VBA for Word. One of the new tasks I need to do is Loop through a directory of fifty folders (one per state) and list...

Greetings: is this possible: I have a standard report with parameters, everything is fine. I am grouping via date. My question.... I have a datefield with standard format: mm/dd/yyyy, of course I can change the date format, etc. But, is there a way to display the date on my report in this...

...recordset to a standard Word.Application object and I got errors. Here is the current code with the bookmarks which is not working...thanks again ************************************************************ Sub CreateLetter() On Error Resume Next Dim rs As New ADODB.Recordset Dim sSQL As...

I might be able to play with this now..but yes, I am using bookmarks. If you would like to send a code sample, I would appreicate that....genemkos@msn.com Thanks,

...to pass though string values at the proper locations. This is the current code I have which provides me with the current one line of data I have: ************************************************************ Sub CreateLetter() On Error Resume Next Dim rs As New ADODB.Recordset Dim sSQL As...