Recent content by stephen81

Thanks Pat for your very thorough reply. Some valuable points, and I totally understand your points about documenting.

Afternoon all, long time member but very infrequent visitor in recent years. I used to do a fair amount with Access/VBA, but haven't really got my hands very dirty for about 10 years. I now need to take a couple of applications using Access front end (Access 2003 I think) and a SQL Server 2008...

Thanks Tony. Great bit of software, just seen the security guard switching my computer off!

Hi On several occasions my work PC has been turned off when I arrive in the morning. I've checked the Event ID 41 and can see that powerbuttontimestamp has a value <>0, which suggests someone has manually switched it off by holding the power button. Does anyone know how to convert the timestamp...

I'm also getting the same issue. Please can you let me know how you corrected it? Or better still, post the solution here so everyone can see it?

Fantastic! Strangely I had tried using 6 instead of xlCSV, but it still didn't work... I've added the reference to the Microsoft Excel Object Library and it's working perfectly now. Thanks!

Hi all I'm trying to open an Excel file from within Access, then save the file back as a csv. I'm currently using the following code... Private Sub RunExcel() Dim xlApp, xlBook As Object Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Add("X:\MyWorkbook.xls")...

I'm trying to replace all the dates in my workbook in a specific date format with a different format using the following code... With Application .FindFormat.NumberFormat = "dd-mmm-yyyy" .ReplaceFormat.NumberFormat = "mm/dd/yyyy" End With Cells.Replace What:="-", Replacement:="-"...

I apologise if this question has been answered elsewhere but I have tried looking and can't find anything that helps. I'm in the process of upsizing an access database to an adp front end and a sql server back end. One of the forms in my original database was a continuous form with some...

In case anyone has missed it, Microsoft have now said they will extend these free downloads indefinitely. Virtual PC and Virtual Server are also now free. :)

I think Brian is right. Generally it's the context that determines whether a word is offensive or not. There are some words that now get labelled as offensive no matter what the context though. As mentioned earlier "nigger" is one of these. Part of the problem though is that once these words get...

Yep. Definitely looks as though that did the trick.

OK, could be making some progress here. I've tried my CASE statements with out the alias after the END and so far they seem to be working.

Thanks Kodo but I see I perhaps wasn't very clear in my question. The CASE statement I put in was just an example. It's actually dates I'm working with so my case statement is actually more like CASE WHEN columnC<= GETDATE() THEN 1 ELSE 0 END booleanC