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 TouchToneTommy 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: iwanalearn
  • Content: Threads
  • Order by date
  1. 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...
  2. 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
  3. 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...
  4. 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...
  5. 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...
  6. 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. "A connect could not be made to the Microsoft Exchange Server Computer" "A code page required for character translation to and from unicode is not installed on this computer&quot...
  7. 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...
  8. 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...
  9. iwanalearn

    Query Odd Numbers

    In Microsoft Access 2000, I want to query a number field and have the query only pull out the odd numbers. I've found in a different thread showing how it is done for even numbers and it works great. See Below. I'm new to Access and can't figure out how to apply this to odd numbers. Thanks...

Part and Inventory Search

Back
Top