Search results for query: *

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...

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...

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]

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...

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...

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...

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

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

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

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

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...

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...

I set up a form that has 6 different combos that pull data from a database each time the form loads. I use the same recordset and connection for each combo. I just reopen the record set with a new sql statement for each combo. The problem is that it takes 6 seconds for the form to load. That...

Anyone know the Windows API call to make a Data Combo box drop down? I know how for a combo box, but the call for the combo box doesn't work for the data combo. Thanks. Tim

Does anyone know a quick way to display 2 fields in a Data Combo box? The combo box has to have the row source and the data source properties though. Thanks. Tim

This isn't really a problem, just looking for info. I created a data report in Visual Basic. The folder that I created the report in filled up with like 20-30 .tmp files. Is that normal? I thought if they were just temporary files that they would go away when the program is closed, but...

Does anyone know a quick setting or piece of code to limit an entry in a combo box to an item that is in the list? I need the user to be able to type in the box so i need to use the combo drop down, but i don't want them to be able to type values that are not in the combo box. Thanks. Tim

This is kind of a general question for anyone who has info. I am trying to switch over a total Access Database to a Access back end and Visual Basic front end. I understand how to link tables and queries, but what is the best way to create a report with the data from the access database? Is...

I created a combo box on a form that allows the user to choose to see the records that contain a value or the records that don't contain a value for a specificed field. The form is linked to a query. I used in IIF statement similar to this in the critera area for the field...