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 bkrike 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: JoeNg
  • Content: Threads
  • Order by date
  1. JoeNg

    MySQL table or database exists

    I like to check if a MySQL database or table exists. I searched on-line and cpan.org. I can't seem to find the right command. Any ideas? Thanks Joe
  2. JoeNg

    Disable 'Disable Hyperlinks/ in ObjectPAL

    Is it possible to enable or disable 'Disable Hyperlinks' option in objectPAL? Thanks
  3. JoeNg

    SQL blank date

    I have a SQL that inserts values into a Paradox table. The SQL executes without any problems if the date value is not empty. However, the SQL would not execute properly if the date value is empty. How can I get around this error? Thanks For example: sDataDate : String; sAcctNo : String...
  4. JoeNg

    StrToFloat with Thousand separators

    StrToFloat does not work with Thousand separators. Is there a easy way to convert, say, '40,000.00' to real type? Thanks
  5. JoeNg

    DBEdit DisplayFormat

    I have a DBEdit field bounded to a numeric field of a table. The field's DisplayFormat property is defined as #,###,##0.00. When I entered 12346.78, the number on the form would become 123,456.78. So far, so good. However, when I change the value from 123,456.78 to say 123,000.00, I get this...
  6. JoeNg

    Disable e-mail "link"

    I have a field for e-mail addresses on Pdox 9. Everytime I click on the field the e-mail program pops up as though I want to send an e-mail message. It's a pain. How can I turn it off? Thanks Joe
  7. JoeNg

    Borrow table structure

    Can I create a table by borrowing the table structure from another table? Thanks Joe
  8. JoeNg

    Where in DBGrid am I?

    I have DBGrid with a Paradox table, how can I return the field value where the cursor is? Thanks Joe
  9. JoeNg

    Excel save as csv

    I would like to convert an Excel spreadsheet to csv. ... Dim objExcel As Excel.Application Set objExcel = New Excel.Application objExcel.Workbooks.Open "C:\1.xls" objExcel.ActiveWorkbook.SaveAs "C:\1.csv", xlCSV objExcel.Quit Set objExcel = Nothing ... This does not seem...
  10. JoeNg

    Days in a month

    Is there a VB function when I can use to determine the # of days in a month, also handle leap year ie February? Thanks

Part and Inventory Search

Back
Top