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...
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...
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
...Dim j As Integer
Dim l As Integer
Dim i As Integer
Dim iloop As Integer
Dim LastOne As Integer
SheetNumber = SheetNumber + 1
Dim Client As String * 75
Dim Campaign As String * 75
Dim BuyingDemo As String * 75
Set objExcel = CreateObject("excel.application")
Set objBook =...
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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.