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 Chriss Miller 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: mgkSHA
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. mgkSHA

    Writing From VB to MS Word - - A form letter

    Hello: I am using the current code to create mailing labels in Word directly from VB..it pulls personnel data straight from the data table and creates the 5160-style mailing labels: Sub MailMergeLabels() Dim LabelType As String Dim SQL1 As String Dim oAutoText As Object Set oApp =...
  13. mgkSHA

    multi-range parameter values

    I am not sure if this is possible. I can do this is VB, but I am not sure how to do it in Crystal. I have a personnel VB application I am working on. I have created a work history report that shows the present and past work history events for each employee. Now, I can easily pass a parameter...
  14. mgkSHA

    Multi-Range parameter help

    I am not sure if this is possible. I can do this is VB, but I am not sure how to do it in Crystal. I have a personnel VB application I am working on. I have created a work history report that shows the present and past work history events for each employee. Now, I can easily pass a parameter...
  15. mgkSHA

    Max SQL Query, how to do it in Crystal?

    Hello: I am having a tough time getting a query that runs in my VB app to work in Crystal reports. Basically, I am making several reports with a join between two tables: Master and Action(personal data and work history). Now some reports, need only the MOST-RECENT work history for current...
  16. mgkSHA

    Inner Join question..please help

    Hello: I am having a tough time getting a query that runs in my VB app to work in Crystal reports. Basically, I am making several reports with a join between two tables: Master and Action(personal data and work history). Now some reports, need only the MOST-RECENT work history for current...
  17. mgkSHA

    is this possible? Modifying a table's structure

    I am burning the midnight oil tonight at work because many unexpected things have come up. I was handed a mdb today at 4 pm and told to transfer the tables to Access XP and create a VB interface. The user of the application said the database was out of memory and we were asked to "bring...
  18. mgkSHA

    How Do I insert a Sum into this formula?

    Hello: I have been struggling with this forever and I need one more step to complete this. I have a field on a report that is a string value and I need to add up the values into a sum within a running total field. I have written the following formulas to convert the string into an integer and...
  19. mgkSHA

    How do I getting the Sum In This Formula

    Hello: I have been struggling with this forever and I need one more step to complete this. I have a field on a report that is a string value and I need to add up the values into a sum within a running total field. I have written the following formulas to convert the string into an integer and...
  20. mgkSHA

    What is wrong with this formual syntax

    Hello: With assistance from other programmers on this board I am trying to get a running total field to work on my report. Based on advice I have been given I am trying to convert a string to a interger and then back to the same format so I can do some calculations. On both formulas and when...

Part and Inventory Search

Back
Top