Search results

Despite all my previous bluster, thinking it through now, how could Microsoft do this? This date problem only arises when Access has to interpret a string as a date (e.g. it must decide what is meant by "#26/04/17#"?) If Access interpreted this string according to regional settings, it would...

Sorry I'll shut up now. :D

yyyy/mm/dd has as little chance of being adopted as starting numbers with 0. The new millennium was actually on 1st Jan 2001, because the years started at 1AD (no zero). Or perhaps it was 12th Jan 2001 (to allow for the 11 lost days, Colin). Oh you've got me started now. Stop me before I get...

OK - in my opinion the best date format is 2017-07-21, because if you list these in a folder, they go into date order.

Colin - Don't get me started. Please.

Thanks Minty, That's an excellent article by Allen Browne. My examples were VBA not SQL so if in doubt, calculate using the US way then convert back. I now need to revisit all my date coding because I had wrongly thought Access now used regional settings in all cases. It's a good lesson to...

Galaxiom is sadly right about the date format following the US format by default. It is also inconsistent as I found when I just tested in the immediate window: ?month(#02/03/17#) gives 2 as the answer but ?month(#22/03/17#) gives 3 as the answer. So it assumes the first segment is the month...

I have Outlook linked to my Gmail account. That works.

What have I started?? But before we settle on a permanent solution, please bear this in mind:- "Pope Francis last year [2015] signalled an openness to changing the date of Easter in the west so that Christians could celebrate it on the same day around the world. The discussions now involve...

Thanks Colin, but I'm ok for the next 10 years! That's pretty cool though, to calculate the first Sunday after the first Full Moon occurring on or after the March equinox. I wonder if it can do the Julian calendar dates too (as followed by the Eastern church).

I took the easy way out by making a table containing dates for the next 10 years with a boolean yes/no field for non-working days. Being in the UK, these were Saturdays, Sundays and Public Holidays. All UK public holidays except Easter can be calculated (e.g. the first and last Mondays in...

Hi Adam, I see no-one has answered this thread and I think it's because it's lacking in detail, so people aren't sure what you are asking. It looks to me that you are talking about a report based on a recordset (or two). There has to be a master table or recorset to move through and...

Hi Colin (LOL!) Not so - I agree about not marking threads as "Closed" automatically, but I still think solved threads should be marked as "Solved", and for there to be a reminder. But not falsely marked "Solved". Additionally it would be helpful to be able to mark a thread as "Closed"...

Er ... oh I see. You don't declare variables for items on forms that you are referring to. For example: The above(ExitDate and AdmitDate) are not "Variables", but controls on a form. Have I read you right?

You need to do what Galaxiom says for all existing code. The statement doesn't have to be put into every individual procedure, just at the top of the page of each module for which you have code - under Option Compare Database as in Option Compare Database Option Explicit Then if you set the VBA...

That's pretty neat - 2 identical answers a minute apart! Your result would have been (e.g.) "[txtBarcode]=ABC" The result would now be "[txtBarcode]='ABC'"

This is the offending line: stLinkCriteria = "[txtBarcode]=" & Me![txtBarcode] Because it is text not a number, you need additional quotes: stLinkCriteria = "[txtBarcode]='" & Me![txtBarcode] & "'" That's a single quote ' before closing the main quotes " and the same in reverse after.

There's also some useful API code here https://gist.github.com/knjname/ba3b7d433655d5930a08#file-vbashortpathlongpathconversion-bas which I have converted to a function for my own purposes (see code below). The provides a function GetShortName(sFile As String) to convert a long path to a short...

Thanks for the support Colin. I agree with Vassago about not closing threads. After 30 days there's little activity likely anyway. I also agree with him about "forced solved" threads, which are toxic timewasters to anyone googling for an answer - as I have found with other help sites. I used...

Hi Colin, Thanks for doing this. I've noticed people are bad at marking posts as "Solved" even when they clearly have been solved. I did my own site suggestion on this but it didn't attract much response, probably because the solution I suggested wasn't that good. But perhaps what might work...