Search results for query: *

excellent. Thanks Tony.

thanks johnwm, I understand about writing an update query, but I am not sure how I can regularly run it. Do I have to write a stored procedure and envoke it via shell script? Can I run the query on a schedule?

Hi All. OK, like most threads on here, I am a newbie. We have a MySQL 4.1 Database running on a RedHat Linux box. Every so often (nightly?), I want to run a job against the tables to select the records from "X" Days ago and update a flag in that table. First, can this be accomplished? And...

Thanks. I guess I am getting lazy and anxious in my old age. I just got the VB call working and finished the ASP call earlier. I am good to go.

Not necessarily looking for someone to write the code, but have been looking for examples and I can not find. I want to take the below code and make it a DLL so I can call it from VB or ASP applications. Any help greatly appreciated. Dim strUserName Dim strPassword On Error GoTo...

I have this problem now...can anyone help me?

OK, so basically, I can copy the backups (or tables), to a different directory....Uninstall, reinstall standard...then reattach?

Going back to the original questions... Is there a way to do this?

Never Mind.

Search function is down, so just going to ask.... I know there is something with the Bit field not converting correctly but can't find the documentation on it anywhere. Anyone know off the top of their heads what the issue is? Thanks

SkipVought , again I appreciate all you have done.... I still have the one time only problem no bombs on With ActiveChart Method ActiveChart of Object Global Failed. I think I am just going to tell the user if he wants to run more than 1 chart, exit the program and log back in

I appreciate everyones help, but Now I get another error pointing to this Method 'Sheets' of object'_global'failed objExChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:C" & LastOne), PlotBy:=xlColumns this is skipvought's second option Again, this works the...

hmmm tried both of the above....both now cause this error on the following line Method 'Sheets' of object'_global'failed objExcel.ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:C" & LastOne), PlotBy:=xlColumns

I have a VB app that creates a custom excel chart. First time I enter the values and run it, it works fine. I try to clear everything out and run it again, but second time I run it I get an error Run-time error '1004': Method 'Charts' of object'_Golbal' failed This points to the...

Thanks for your suggestion. I took your advice and atleast for now am OK. I really need to read up on this more. I will check out that book. Thanks Again.

OK, strike that....I see what it is doing, but now don't know what to do. Class initialize is hit before anything else is available to the class (referenced/passed variables). So I guess I need to move my select out of my Where clause. Any help? Also starting to think that using a class...

I step through, and maybe I am dense, but I can't figure out what is going on.

I have something weird happening. I have a class that has a statement like so (shortened for this purpose) Private Sub Class_Initialize() Dim sSQL As String Dim db As Connection Set db = New Connection db.CursorLocation = adUseClient db.Open...

Thanks Golem! That is exactly what I wanted to know!

Anyone??? Suggestions? Clarifications?