Search results for query: *

you can create an odbc by putting an ado.. control on a form, using the properties dialog to build a connection to your data. you can do this on a startup form or copy the connection string you create and use it in code. either way should work for you.

Have you checked the linked table manager to see if it is set to always ask for a new location of the data? Do any other pieces of software access this data from your machine? Either of these may cause the message you describe

James, Add a route of last resort to your main router ip route 0.0.0.0 0.0.0.0 [ip address of router on other side of dsl] also add: access-list 10 permit 192.168.0.0 0.0.255.255 this should give you internet at your remote sites wwebb@satx.rr.com WebbWill

Haijun, I believe what John was referring to was using code to connect to your data source. I do this by means of the "Connection" object. use this in conjunction with "Command" objects and "Recordset" objects and you have much more control over the connection...

I am writing an app in VB 6 that is a front end to an Access 97 database. I use connection and command objects to pull / push data from the DB. I have one table that is linked to a comma-delimited text file. When I try to read this table and create a new one with the data I get "Cannot Find...

WOW, I see some really great ideas and practices being used to motivate and inspire. I wished I worked for someone that had these skills. I am going to email a link to my boss and mark it as suggested reading. Maybe the ideas will be put to use here. We are told that we can all be easily...

jbenson, Have you tried using a timer to close the form? webbwill

rainbow, you can open the recordset read the field into a variable, and then place it in your picture frame. Hope This Helps WebbWill Past Failures are Guideposts to Future Success

jbenson, How about a 3 second timer then unload the form/menu? WebbWill

Hi Kelly, Here is a snippet of code I use to export tables and such into Excel. You don't have to create an instance of Excel or open one either. As for the special formatting, I do that in Macro from within excel and just run the macro's before I send the files out. Hope this helps, If not...

Sergio, cut and paste this link into your browser. Or try searching with Google using the search phrase "packaging apps with windows installer" no qoutes that is how i found the link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msi/wiport_6gf9.asp hope this helps...

I have an Access 97 database as a backend. VB6 Code supplies the GUI. I am having trouble changing the field type in a table. When the data is gathered it is all text. I would like to change some of the fields to Double's or integer's. What would the syntax be for the SQL statement. Have tried...