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 Wanet Telecoms Ltd 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. iwanalearn

    mysql to mssql "order by"

    Thanks vongrunt. Works great now.
  2. iwanalearn

    mysql to mssql "order by"

    I have a database that searches for dealers based on the zip code entered. I want the results to show the dealers with the same zip code on top of the list then alphabetical after that. We have switched from mysql to mssql. Learning mssql but need help converting this code. This is how I sorted...
  3. iwanalearn

    Summit48 Power up no led's on front panel

    OK, I found the solution on a different forum. What I needed to do is pull the power cord from the unit. They suggested 1 minute. That wasn't long enough. So, I pulled it for the weekend. Plugged it in and away it went. I also found out that you can't do a reboot with the web interface it's a...
  4. iwanalearn

    Summit48 Power up no led's on front panel

    I was in the process of changing the IP address of my summit48. I accidentally turned the power off. Now when I turn the power on none of the led’s on the front light up and I can’t get the console to connect. What can I do? Thanks
  5. iwanalearn

    CheckBox Display in Crystal Report

    It seems to work in all situations. What would be the better soloution? Thanks
  6. iwanalearn

    CheckBox Display in Crystal Report

    I figured it out: IF (Count ({JobSpecPrepress.Work-Center-ID}))>=1 and {JobSpecPrepress.Work-Center-ID} = "100" and {JobSpecPrepress.Operation-ID} = "100" then chr(254) else chr(168) Works Great. Thanks to all
  7. iwanalearn

    CheckBox Display in Crystal Report

    I just did some more checking and found that the boxes do not show when I have more that one subjob. Example: One subjob 100 100 = checkbox "" "" = blank box two subjobs on one job subjob1 100 100 = nobox subjob2 100 100 = nobox I guess what I need to know is how can I consolidate multiple yes...
  8. iwanalearn

    CheckBox Display in Crystal Report

    I've been trying to get the blank check box to show. Here are the 2 formulas I tried stringvar formula; if {JobSpecPrepress.Work-Center-ID} = "100" and {JobSpecPrepress.Operation-ID} = "100" then formula := chr(254) else formula := chr(168) and if {JobSpecPrepress.Work-Center-ID} =...
  9. iwanalearn

    Truncate all text after ,(comma)

    Thanks for the quick response. It works with with all the suggestions. Thank you
  10. iwanalearn

    Truncate all text after ,(comma)

    Yes, I'm a new crystal reports 9.0 user. I have 5 field that import some have data in all field and some only have data in the first field. I read The Comlpete Reference, but couldn't relate to what I want to do. Example of what prints John,John1,John2,John3,John4 or John,,,, all I want is...
  11. iwanalearn

    body_checks

    Thanks for the responses. Actually I found something that does work well. I've been using the following. /www.*test.*com/ REJECT I found this on a different forum. Yes I do have regex built into postfix. Again Thanks
  12. iwanalearn

    body_checks

    I'm just learning linux/postfix/etc. I've been working with body_checks to stop the flow of spam. It seems to work for me with one exception. I can't get any phrases with a "period" to be rejected. e.g. /www\.test/ REJECT Spam /www.test/ REJECT Spam Neither of these works to stop www.test.com...
  13. iwanalearn

    httpd.conf what am I doing wrong?

    Chuck, Yes I do. actually it is like this <IfModule mod_dir.c> DirectoryIndex index.html Home.php Chamber.php Splash.php </IfModule> Do I want to put this with each Virtual Host since each has a different home page? Also, this information is found above the Virtual Host part. Do I need to...
  14. iwanalearn

    httpd.conf what am I doing wrong?

    Yes I'm new to apache. I have virtual websites on an NT server. I'm moving them over to Suse 9.0 Linux box. I've followed the instruction found here and this is what happens. If at a browser I type in the web address www.mysite.com I get an index list of the folder on the webserver. Same thing...
  15. iwanalearn

    Server crash, Exchange will not connect to server.

    My Exchange server crashed and this is the message that pops up when I try to connect to the server. &quot;A connect could not be made to the Microsoft Exchange Server Computer&quot; &quot;A code page required for character translation to and from unicode is not installed on this computer&quot...
  16. iwanalearn

    Reference worksheet cell in script

    WOW!!! nickjar2, It works great. I can enter the dates in a cell on a worksheet and my query does it's job. I've been trying to make this work for some time, with now success. Again Thanks
  17. iwanalearn

    Reference worksheet cell in script

    I use a ODBC query to populate a worksheet. I need to do the query by date, so I need to change the date in the VB script each time. Is there a way that I can enter a date in a worksheet cell and have the script reference that cell for the date. Below is the code I use now, the red text is the...
  18. iwanalearn

    Calendar Control 9.0

    I'm also have a problem with Calendar ActiveX 6.0. I tried the 'Date' solution, but it didn't work. Any ideas what needs to be done? Thanks
  19. iwanalearn

    Calendar doesn't show current date.

    I have a calendar (MSCAL.Calendar.7) in a MS Access 2000 form that is used to fill in a field. I can get everything to work except that it doesn't show the current date. It shows the date that was set in properties. Im using vb 6.0 Me!datecalendar.Visible = Me!tgldate If Me!tgldate Then...
  20. iwanalearn

    Query Odd Numbers

    Wow! It works great. Seems like a dumb question now. Thanks for the help.

Part and Inventory Search

Back
Top