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

  • Users: Hm786
  • Order by date
  1. Hm786

    How to Suppress duplicate values for a column in Group Footer

    13775 5STARMAX 9393 13786 5STARMAX E 9378 Pay 13775 5STARMAX 9393 13787 Hi, How do i suppress the 13775 5STARMAX 9393 valuse in asp page not to show twice. Any help is appreciated. Thank you, hamida
  2. Hm786

    Linked OLE objects in the templates

    Hi, We have our company template which we use as our template for creating all our crystal reports. Company logo changed and they wanted to use embedded pictures to keep the links. When I created the ole embedded picture logo and the company footers in the templates, it is showing the logo...
  3. Hm786

    Common Dialog Box

    It is active x control for the opendialog box inserted from the access more tools. MSComDlg.CommonDialog.1 class.
  4. Hm786

    Common Dialog Box

    Private Sub Command6_Click() 'this is an extract for all the Zip files 'FTP them to the Mainframe 'Added by HBM on 11/16/2006 as per Ann's request Dim Db_Curr As Database Dim Rs_Curr As Recordset Dim St_OutPath As String Dim St_OutFile As String Dim St_FtpFile As String Dim St_date As String Dim...
  5. Hm786

    Common Dialog Box

    Hi, I am trying to multiselect the files from the common dialog box in MSAccess and ftp to the server. Right now I am able to select one file at a time and able to do multiselect. Can anybody help me in this issue? I also tried to use the flags but not working. Thanks, Hamida
  6. Hm786

    Counter in Frontpage

    Hi, I inserted a Hit counter from my front page editor on my .asp page and also on my html page. When I am previewing this through the internet explorer the counter is not doing anything it just showing as a image. What should I do to make the counter work or is there any other way to create...
  7. Hm786

    Multiple Parameter selection

    Ian and Synapse, Thank you very much for your help and the report is working and I changed the code slightly and it worked. ( if {?Cotact_Id}>0 then {Command.Contact ID}={?Cotact_Id} //--else //--true ) or Thank You, Hamida
  8. Hm786

    Multiple Parameter selection

    Ian, Here is my formula ( if {?Cotact_Id}>0 then {Command.Contact ID}={?Cotact_Id} else true ) and ( if {?ContLastName}<> 'ALL' then {Command.Contact Last Name} = {?ContLastName} else true ) and ( if {?Contact_FInitial}<> 'ALL' then Trim({Command.Initials}) =...
  9. Hm786

    Multiple Parameter selection

    Hi, Using 'and' in the formula is not working. The parameters are for example contact, Phone, Firstname,Fax. If they enter contact 1 and then first name as'GROOM' I should get information for contact 1 and also for the First name 'GROOM'. This my formula ( if {?Cotact_Id}>0 then...
  10. Hm786

    Multiple Parameter selection

    Ian, What about the user select parm1 and parm2 or parm3 and parm4 how do I code. They want to select either one or multiple combination. Thanks, Hamida
  11. Hm786

    Multiple Parameter selection

    Hi, I created a crytal report with 5 input parameters. User can select any combination of the parameters. How do I code this in the record selection formula. For example if the user select parm1 and parm2 the report should pull only Parm1 and Parm2 related info. If they select only parm3...
  12. Hm786

    How to create a shortcut file

    Set WshShell = WScript.CreateObject("WScript.Shell") this to create and instantiate the WshShell object which I am not able to Set oShortcut = WshShell.CreateShortcut(sShortcutPath) this to creating the shortcut My code passes through the Wshshell but gives me the internal error that some...
  13. Hm786

    How to create a shortcut file

    Hi, I am trying to create a shortcut file from vb code. I am using the WshShell object but I am getting error message. What dll should I install on my machine. Thank You, Sincerely, Hamida
  14. Hm786

    date format

    I just want to strip the time from this d_start_date field in my sql which runs against sybase database. I am grouping on this field which gives me extra rows with the time. Thanks, Hamida
  15. Hm786

    date format

    Hi, I have a question, in my sybase sql i need to show only the date not the time. Is there a date format function which does this one. Please help me. Thanks, Hamida
  16. Hm786

    How to display page number in a cross-tab report

    Lbass, I don't have Crystal reports XI I only have Crystal 9.0. Thank You, Hamida
  17. Hm786

    How to display page number in a cross-tab report

    Hi, I need help in displaying the page number on the cross tab report on its virtual pages. Thanks, Hamida
  18. Hm786

    Excel subtotals

    Yes I used the data subtotal feature but I need to show that subtotal in the TotHH field. Thanks, Hamida
  19. Hm786

    Excel subtotals

    Hi, I am new in writing macros in excel. I need to write a macro, showing the subtotals per headend in a Total's field for example HeId TotHH HH 1268 DIG CMTY Yes 0 1 1255501 1268 DIG REG Yes 0 25 1255560 Based on this above data I want to show the...
  20. Hm786

    How to supress a group base on a value

    Thank you Lbass, your suggestion worked like a charm. And my special thanks to every body who responded to my question so quickly. Hamida

Part and Inventory Search

Back
Top