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 SkipVought 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: *

  1. mgkSHA

    .SelectPrinter headAche

    I am hoping someone has had this problem before and can shed some light on this. Via Vbscript I automate a bunch of Crystal operations (this is version 9). I have the name of a printer stored on a table and get all corresponding driver info and port info from the registry. I can assign the...
  2. mgkSHA

    Please help comparing DateTime value

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

    Please help comparing DateTime value

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

    Please help comparing DateTime value

    I am one step away from a Crystal Automation project being completed. This problem is driving me crazy, so I hope you guys can help me. I have a Date field and a formula that calculates time. I have combined these two fields into one formula that I use as a datetime stamp: the formula is...
  5. mgkSHA

    Please help Number to time conversion

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

    Crystal 9 Help Needed Badly

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

    Crystal 9 Help Needed Badly

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

    Crystal Enterprise newbee

    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...
  9. mgkSHA

    Crystal Web Reports

    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...
  10. mgkSHA

    Help with web interfacing

    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...
  11. mgkSHA

    Please help..macro password

    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...
  12. mgkSHA

    Text File help

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

    Text File help

    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...
  14. mgkSHA

    Text File help

    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...
  15. mgkSHA

    List all controls in a Word Doc - and directory

    Greetings: I have switched jobs from primarily database development/report development 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...
  16. mgkSHA

    date formating question

    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...
  17. mgkSHA

    Writing From VB to MS Word - - A form letter

    Now that I have added vbCrLf, my bookmarks won't save, and I get nothing...ACK! I have no clue why this is giving me such a headache :). I would much rather ditch the bookmarks and write to Word directly, do you an example of that. I tried to pass a recordset to a standard Word.Application...
  18. mgkSHA

    Writing From VB to MS Word - - A form letter

    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,
  19. mgkSHA

    Writing From VB to MS Word - - A form letter

    Hello: Well, I got the overall functionality of it working, I picked up on the coding fairly quickly..but now, my question is, how do I format it correctly (again, sorry, I have little Word integration experience :)). This is currently how the document prints: (on a single line:) 01/06/2003...

Part and Inventory Search

Back
Top