Search results for query: *

Ok - Thanks Feherke, appreciate the help

...// generate SQL statement $result=$dbh->prepare("SELECT * FROM performers WHERE accent='$txt_accent' AND hair='$txt_hair' AND gender='$txt_gender' AND location='$txt_location'"); // execute SQL query $result->execute()...

Oon my Search page I've got dropdowns that are linked to an SQL database and pull a list of names (e.g. the combination accent northern-brown-male-manchester brings up A & B, southern-grey-female-london brings up X & Y) This works fine. What I'm trying to do is add an if statement so if no rows...

Why didn't I think of that?! Will check when I'm back in work tomorrow....Thank you very much!

Hi, I've got a piece of VBA that logs in to CMS, pulls the data in to the workbook and logs out. This works fine on my (older) desktop PC, but my laptop gives a "run-time error 429 ActiveX component can't create the object" at; Dim cvsApp As Object, cvsConn As Object, cvsSrv As Object, Rep...

My work have recently upgraded from excel 2003 to 2007 (very progressive!!) and, amongst other problems, I had a macro that imported 2 csv files into an excel workbook that worked fine in 2003 but won't in 2007; When I run; Sub Import() Dim oCSV As Workbook Set oCSV =...

I currently use the following code to filter for 2 criteria that are required from a range: Sub FilterRange() Sheets("Call Centres").Select Selection.AutoFilter Field:=2, Criteria1:=Range("ICC1").Value, _ Operator:=xlOr, Criteria2:=Range("ICC2").Value End Sub Where the criteria required are...

Much appreciated

I've trawled through the internet and cannot find anything on this at all. All I'm after is a macro that will update linked cells once fired, rather thatn having to close a workbook, then open it again, updating the links when prompted! Anyone got anything?

Good spot!

Brilliant. Much appreciated (feel guilty about being so lazy with my code sometimes!!)

Oops - Have reposted, Thanks

I've got a workbook with the enclosed code embedded to each worksheet, which format the cells depending on the data entered (I know the code isn't too tidy, I'm only doing this as a favour!!). When more than one cell is selected and data is deleted, I get a Runtime error 13, type mismatch. Gone...

I've got a workbook with the enclosed code embedded to each worksheet, which format the cells depending on the data entered (I know the code isn't too tidy, I'm only doing this as a favour!!). When more than one cell is selected and data is deleted, I get a Runtime error 13, type mismatch. Gone...

the structure of the files is currently Branch_name - mm/dd/yy

golom thanks you for all your help with my 2 problems i have tried to input and run the above code but it is returning a error user define type not defined and seleting the top row ("Dim FSO As New Scripting.FileSystemObject")

sory i want to look for files with that dat format amd then rename them sorry if i was unclear

golom thanks you very much for you help with this, it works fine.. i am just adapting the code slightly so i can use it with another file and was wondering if it is possible to not only look for a matching string like branch_name but alos to look for any file for the previous day so it looks...

...= "H:\Retail Network\Private\GMS Call Centre\Call Centre\MiDatabases\BranchTelephony\Work In Progress\OutboundData\" Draft = "Branch_report" & "*" FinalFilePath = FilePath & Draft If Dir(FilePath & Draft, vbNormal) <> "" Then Name FinalFilePath As "H:\Retail Network\Private\GMS Call...

thanks for you feedback i am trying to think of another way of doing it do you know if it is possible to use the name function and the widcard together, the problem i have is the files are run at different times each night and therfore the name of the file is different each day