Search results

Maybe a few more error handlers in Functions & Subs to display the error on the screen as the user proceeds through the program. One easy way is to stick advancing numbers through the code that the error message can show along with the message. The developer can then look at that actual location...

"Personally, I don't think there's intelligent life on other planets. Why should other planets be any different from this one?"

I would have thought that Alt+Ctrl+Delete would be the only option. But would you want to tell your client to use that? I always took the view that the less they knew the better and whatever they do you should be in control of anyway.

I see that NS&I are reducing the odds of a win by 5% from April 26 and reducing the interest rate payout from 3.6% to 3.3%. This is when interest rates are held or rising outside their little world. I don't know about anyone else but I reckon that the prizes started to reduce in 2024 and that...

another way is using string handling mVar1 = Len(Trim(Field)) mVar2 = instr(field,",") mVar3 = instr((mVar2+2),Field,Space(1)) mNew1 = left(field,(mVar2-1)) mNew2 = mid(field, mVar2+2, 2) mNew3 = Right(trim(field),mVar1-mVar3+1)

Correct, it isn't an issue, it never was an issue. I thought I'd explained why I posted in #1 & #5. Basically it is something I've done since A97.

excellent

I often think that your own way of doing most things is the better way. A bit like other peoples kids, who are always more of a damn nucance than yours hve ever been!

I wasn't aware of that fact, hence the post.

After all of the years using Access, the other day I accidentally dropped on something I had never come across before. I have always used form variables as memory variables. Mainly just because I can in Access and also so I can easily see them if I need to. I will store what otherwise would be...

I would like to calculate the difference between a field in one record to the same one in the previous record in a datasheet. basically on the the 1st record I want to show the number of days back to the second and so on 1st record 12/03/26 =2 2nd record 10/03/26 =1 3rd record...

A question that constantly reiterates itself: Is Gwyneth Pratrow a shilling short of guinea?

Nothing changes..........unfortunately

Have you got a permanent link from a small BE table to an always open FE form?

Here are two more for a Friday Doc. A very damp and dismal Friday it is too. We've had rain for over 40 days and nights now, so just waiting for the plague of locusts which are no doubt on their way. Probably in rubber boats via France. They are the last two cartoons I have actually. They used...

Sometimes a client would come up with what they thought was a brilliant idea that would massively improve my software. It was such a good idea that they thought I should add for free. Only problem was that the idea was very company specific, just theirs in fact. When I told them that I would...

It has been my experience back in the days when I sold commercial software that if a backup is started when the BE is in use somewhere, editing or not, it will be incomplete. I would advise customers to do at least Odd and Even backups onto separate odd and even disks, or USBs. That way they...

It does appear that you aren't far out there Isaac.

There is definitely no macro. Only the autoexec which I always have renamed on the FE as Autoexec1 to prevent it working during development. Neither do I have the display form set. I have never used macros in access except for Autoexec because when I started out with Access they just seemed more...