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

  1. Timinator

    Network Traffic MySQL 4.1

    Is anybody familar with the status variable "bytes_sent"? I have been running MySQL 4.0 on a Windows 2000 server for over a year and the variable "bytes_sent" was never greater than 0. Which would make sense because I am using MySQL for a in-house application that is networked throughout the...
  2. Timinator

    How do I read the log-bin file?

    From the Client PC i am connecting to the server via MyODBC. And I downloaded the MySQL control center off the mysql web-site. I'm not sure if this is what you are looking for... as a newbie in this area...I am looking for any possible suggestions. All I want to do is read the log-bin file...
  3. Timinator

    How do I read the log-bin file?

    Does anyone know how to read the binary log from a client workstation? The log is named hostname-bin.001 and when I open the file it is unreadable (obviously because it is in binary). So making a shortcut to that file will not do the trick. How can I open the file via a mysql command...
  4. Timinator

    Static Class Functions

    thanks chip
  5. Timinator

    Static Class Functions

    Does anyone know a way to make static functions in a class that can be called without having to create an instance of the class? [bigears]
  6. Timinator

    Setup a Datasource (ODBC) for all users.

    Thanks. That is just what i needed.
  7. Timinator

    Setup a Datasource (ODBC) for all users.

    Does anyone know how to link to an ODBC database that will stay linked for all users that log into the PC? I setup the link to the database in the Data Sources (ODBC) Manager which is found in the Adminstrative Tools, but it only stays for the current user that is logged in. I would like to...
  8. Timinator

    Remove commas from a text file

    I am trying to input data from a text file that is created from a different program. The problem that i have run into is that some numbers in the text file have commas(ex: 1,400). The program reads that comma as being the end of that record, so it moves to the next line. Is there a way to...
  9. Timinator

    Access Link Table is slow....

    I am using Access 2000 over a network. Perhaps I should give it another try, maybe I did something wrong last time. Thanks. Tim
  10. Timinator

    Access Link Table is slow....

    The reason I have 4 different Employee Tables is because it is too slow to have it linked. I tried the 2 connection thing, but the only problem is that I can't use the Employee Table in SQL statements then. I will have to look into that JRO option. Thanks. Tim
  11. Timinator

    Access Link Table is slow....

    Here is my problem: I have an 3 or 4 programs(VB Interface/Access Backend) that all have the same EmployeeTable. When an employee changes, I have to make the update in all 4 databases. I've tried making it into a link table, but it pretty much kills my program because its so slow. The link...
  12. Timinator

    Open a Adobe Pagemaker 6.5 file

    Does anyone know how to open an Adobe Pagemaker file in the adobe pagemaker program within a Visual Basic program. For example: If i use the shell function to open Adobe Pagemaker, is there a way i can have it automatically open a certain file? Thanks. Tim
  13. Timinator

    convert Decimal to Fraction

    Does anyone know an easy way to convert a entered decimal value into a fraction? Thanks. Tim
  14. Timinator

    Setting an Access Date Type field to Null in VB

    I don't see a option to accept Nulls for Date Type fields, maybe i am mistaken though. Tim
  15. Timinator

    Setting an Access Date Type field to Null in VB

    I'm trying to clear out a date type field in access through a Visual Basic interface. Its not really working. I've tried setting it to NULL, 0, "" and it won't take any of them. 0 is the closest to working, but it sets the date to 12/31/99, which is no good. Any Ideas? Thanks. Tim
  16. Timinator

    Join Expression Not Supported??

    Is there a trick to doing a Join in VB code? I've tried many ways, but i always get the error "Join Expression Not Supported". Below is an example of what i tried last. SELECT * FROM PartTable INNER JOIN OrderTable ON pt_part_number = ot_part_number Any ideas? Thanks. Tim
  17. Timinator

    Visual Basic and Access Frustration.....

    Mavors, The ado is linking to a table in access. The connection i'm using is the Microsoft Jet 4.0 engine. The select statement is something like this "SELECT * From Table". Thanks. Tim
  18. Timinator

    Visual Basic and Access Frustration.....

    I am using a Visual Basic form and an Access table for the back end. To add a record to the table i use the code below: With adoTable.Recordset .AddNew .Fields("order_number) = LastOrderNumber + 1 .Fields("customer_id") = txtPartNumber...
  19. Timinator

    The Excel.Application class

    daimaou, How do I add the reference to the Microsoft Excel 8.0 Object Library? Thanks. Tim
  20. Timinator

    The Excel.Application class

    Do I have to add any componets or anything to access the Excel.Application class? VB doesn't allow me to Dim a variable with the Excel.Application. I have excel 97 installed if that matters. I'm trying to export data from a recordset to an excel spreadsheet. If anyone knows an easy way to do...

Part and Inventory Search

Back
Top