Search results

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

I'm writing a sql query in an adp where a few of the columns are calculated using CASE statements. e.g. SELECT columnA, columnB, CASE WHEN columnC IS NULL THEN 1 ELSE 0 END BooleanColumnC, columnD GROUP BY ...... HAVING columnA = @parameter1, BooleanColumnC = @parameter2 When I try this though...

I'm not sure you actually need to transpose your spreadsheet. Your data should import fine with very little changes. I think the confusion may be arising from your fieldname1, fieldname2 and fieldname3. These actually look as though they should be separate records (i.e. record1, record2...

I'm not fussed about online games at the moment, I just want to play over a LAN. Is that possible?

I have a PS2 and my brother is bringing his over at Christmas. Does anyone know if i can connect the two directly to each other using a crossover network cable? From what I've read you can play games over a network with a router but does the same apply to just connecting the two directly to each...

How is he connecting to the internet? directly to modem? through a router? Is it possible the router has a firewall?