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 strongm 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: GZook
  • Order by date
  1. GZook

    I need to print a line when DateTime changes from AM to PM

    It kind of worked. The line appeared after the first PM. I believe this may be because I have my detail fields in a group header to avoid a list of duplicate records. The AM PM line is in that group footer. I'll just add a parent group based on @AMPM and put the line in that group header. We'll...
  2. GZook

    I need to print a line when DateTime changes from AM to PM

    It kind of worked. However, the line appears after the first PM. It should be before. I'm just gonna make a Group by @AMPM and put the line in that group header.
  3. GZook

    I need to print a line when DateTime changes from AM to PM

    You had an = sign that shouldn't've been. IF hour({datetimefield}) < 12 then "AM" else "PM"
  4. GZook

    I need to print a line when DateTime changes from AM to PM

    I'm trying to use "gampm = Right(CTime({datetimefield}),2)" to get the AM/PM part of the DateTime field. However I get the message "A string is required here" with the cursor positioned after "Right(". What type does CTime() return? How should I accomplish this?
  5. GZook

    Does Crystal have anything like MsgBox()?

    Chelseatech wrote: <<You can do it inside a UFL. If you can write VB, I can send you the source code - it's one line inside a VB function.>> Thanks, I'm interested. My report is in-house on a LAN, not on the internet. One question, and I should probably know this, but what is a UFL...
  6. GZook

    Does Crystal have anything like MsgBox()?

    In debugging a report, I need to investigate the values of Shared Variables, and would prefer to do so without having to return them as the result of the formulas. Can this be done?
  7. GZook

    I need to detect End of File for a child table.

    Thanks to both of you for your suggestions. This is what I was trying to do in the first place and easier than what I finally did. I'm gonna make a copy of my report and give it a try. My solution is somewhat roundabout, but it works. I split the detail band into 3 sections (one for each...
  8. GZook

    I need to detect End of File for a child table.

    I have a setup where there is a master table which is related via CaseNo field to three child tables. For each master record, there will be data in only one of the child tables. Using only one detail line, I need to include data from the master table and the child table that is not at end of...
  9. GZook

    In V8.5 Can you relate fields with different names?

    I have two tables in which I need to link: Quelist.CallId --> Calls.ID Can this be done? Note: The Quelist table also has an ID field. By default, the visual linker tries to link the two ID fields, which aren't even supposed to link.
  10. GZook

    When moving apps, Always use the &quot;Package and Deployment Wizard&quot;.

    Just some FYI: Installation of VS Installer requires that Visual Studio Service Pack 3 or later be installed on the target computer. V S Service Pack 5 is available at the MS Download Center. Go to the bottom of the form and selecting &quot;Visual Studio&quot; as the Product/Technology. Then...
  11. GZook

    When moving apps, Always use the &quot;Package and Deployment Wizard&quot;.

    WOW, I leave last night at 5:00 PM EST, come in this morning at 8:30 AM EST and there are 9 new notifications of posts to this thread in my e-mail. I thought, Boy, someone's been busy! lol This is all great stuff. I'll look on the VS CDRoms, My hard drive, and Johnmw's new link! Thanks...
  12. GZook

    When moving apps, Always use the &quot;Package and Deployment Wizard&quot;.

    Zor, Look at the MicroSoft Download Center site at www.microsoft.com then &quot;More Downloads...&quot; In the Download Center, I found two links to Windows Installer 2.0: One for '95, '98 & ME; the other for NT4 & 2000. On the Download Center's search (bottom of the form) I entered...
  13. GZook

    When moving apps, Always use the &quot;Package and Deployment Wizard&quot;.

    The link for VS 6.0 Installer is still giving &quot;The page cannot be displayed&quot; Same for the older VS Installer 1.0 link.
  14. GZook

    Re: &quot;When Moving Apps... DPW Thread&quot;, Not Always!!

    Correction: I ment PDW, not DPW.
  15. GZook

    Re: &quot;When Moving Apps... DPW Thread&quot;, Not Always!!

    Correction: Since creating that thread, I've learned that the Package and Deployment Wizard doesn't work, on the installation side, in all situations. See the Helpful Tips thread &quot;When Moving Apps, Always use the Package and Deployment Wizard&quot; for a discussion of this. Seems to work...
  16. GZook

    When moving apps, Always use the &quot;Package and Deployment Wizard&quot;.

    Update: Just tried the link for Visual Studio 6.0 Installer (which had the newer date) but got the ol &quot;This page cannot be found&quot; message. Guess I'll have to try again later.
  17. GZook

    When moving apps, Always use the &quot;Package and Deployment Wizard&quot;.

    Vizion, That's great. I believe Zor's post was just to make people aware that it doesn't work in all situations. See my Question thread: &quot;Package and Deployment Wizard Question&quot; for my specific situation. Johnwm, I'm looking at the MicroSoft Download Center site which I found by...
  18. GZook

    Package and Deployment Wizard question:

    I understand from one of Zor's posts that &quot;it won't put my application on an NT machine&quot;. I'll still look into the MS Visual Studio Installer for future installations, but I've already got the installation package burned into a CDR and I'd hate to waste it. Besides, my situation is...

Part and Inventory Search

Back
Top