Search results

As I understand it Tom does not want to run any code if he selects the wrong shortcut. Having determined the active sheet name he should compare this with the name stored in the macro and act appropriately, ie run the macro or issue a message and exit. I never ran against Activesheet but always...

I agree and that is a comment I have made in a previous thread, it also applies to the Brits in the med area, and does not effect peoples perceptions. Brian

Most of the Americans I have come across outside of America, whether in Europe or Asia have been loud and arrogant, my daughter who holidays in Central America says the same, those I have met in the US. have been polite welcoming and generous. Brian

I have suggested that instead of going to Spain each year Col goes to the US , hires a car or motorbike and meets some Americans , those you meet in America are very different to those you meet "doing Europe " or elsewhere come to that, it's like judging Brits by those you meet in the bars of...

I no longer have Access to try but you should be able to build Or codetails is null at the end of your criteria or maybe start with CoDetails is Null or Brian

Just looking at the logic and not any wider issues shouldn't you be using Date() rather than Now(), or does the time come into the thinking? Brian

You could write code to loop through the date range using weekday to identify the days you require. There might be a smart way to do it from just knowing the first day in the range. Brian

Like does not return nulls, you will have to check for them.

Oh, I don't think we need to start a second gun thread, the existing one has already shown that the Americans don't trust their government to not enslave them, and that many , if not most, don't understand the second amendment. Brian

As I was reading this thread whilst having breakfast the news was on the TV ,( who says blokes can't multitask :D ) there was a news item about Obama visiting New Orleans , it painted a different picture to that by Col. Of course we can't possibly know the truth from thousands of miles away. Brian

When you click on Queries to see the list of questions, top left there is a button label New Thread, clik on that to start a new thread. Brian

I did say that, and also that I thought that it could be modified, try replacing sht by Sheets("yoursheetname").Range("A:C") or ("A1:C9") or whatever BTW it is normal to Dim lastrow as Long Brian

I've also seen this LastRow = sht.cells.Find("*",searchorder:=xlbyrows,searchdirection:=xlPrevious).Row Where sht is the reference to the worksheet, I'm sure that it can be modified for a range but have not done it. Brian

Namliam's code only finds the last row with data in column A if my memory is correct, it been a long time. A Google search does reveal many hits, this one also lists the pros and cons. http://www.rondebruin.nl/win/s9/win005.htm Brian Apologies to Namliam I didn't read his code carefully...

If you count the number of records in each group , with say Count(Sup_STAT_DTC) , in Q1 then in Q2 select only where this is >1 then you will get only the records with duplicates. Brian

I think that he will need to include the dats in that join, plus he might like to count the records in each group in Q1 and run Q2 where that is >1 Brian

Two things are stated to be responsible for the decline in pub attendance 1. The drink driving law. The young are more responsible than my generation. 2. The smoking ban, most drinkers appeared to be smokers so once they couldn't smoke with their drink in the pub they stayed at home. I also...

Note that the false result can be another IIf clause Thus replace your or with , IIF( Then add another closing ) also as it stands remove the first two( Brian

Yes people forget that a date time field always has a time, if not quoted it defaults to 00:00:00 Brian

I never had 7 going straight from XP to 8 when I had to buy a new laptop, then to 8.1 . I never see the start screen as I boot to the desktop and have had no complaints about 8.1 , but to be fair these days I don't do much, some say I never did. Having spent a couple of years at school...