Search results

You could try setting i1 and i2 as variant

Multiply an integer by an integer results in an integer value

Try Dmax("TransDate","tblTrans") Yo don’t need a criteria

So why not name them? No To recover his costs

I can think of one, and that had nothing to do with the popularity (or otherwise) of Access. How many do you know? Most of your posts are on the water cooler, very few on technical issues. So suspect you need a different forum. But at least here you can be a big fish in a small pond. Yes the...

I go to sites that have that in depth knowledge of the subject with members who have strong and relevant experience. Most of the time I'm looking for expertise rather than opinions. If I have a watch to be repaired, I take it to a watchmaker, not the local supermarket.

so become a jack of all trades and master of none?

You can - it just isn't generated automatically (except perhaps you might get one if you set the field to random rather than increment) . I sometimes use a 0 PK record to hold default or message type values. However you do need to insert the record as the autonumber field cannot be edited. I...

Less typing with ! 😀

Actually that should be RS!EmailID

I see number of threads and posts, not views

You should be able to see for yourself https://www.access-programmers.co.uk/forums/

And how many members is that? Perhaps 20? How many (currently) active threads? 4 or 5?. And most of the threads are about US politics. Not about what your dog got up to last night. Depends on what you want the site to be about - I think the URL says it all There are other forums here for...

Those are networking/social sites, not a technical forum. You need to compare with other technical forums. Perhaps stackoverflow? Agree the comments that AI is starting to attract users over technical forums - but where does AI get its information (aside from online manuals). The way AI is used...

At this point in time, according to the site stats, there are 900 viewers looking at the site. Of these, 12 are registered members, the rest are ‘visitors’. Of these there are many robots, including Google.

No - I went into contracting, primarily identifying and filling in the financial holes between corporate systems typically using access. Took me 3 years to recover financially and went well - until Covid😀. Now I’m semi retired, working a couple of days a week for a few smaller clients

What was I doing on 9/11? I was doing a barn conversion to create a training centre for our rapidly expanding business. I was there to review progress and answer ‘where do you want this’ type questions. The news came through the builders radios around 4pm. Much of our business was with...

and I would go with I would go with "R" & mid(FieldName,2)+1 tt="R999" ?"R" & mid(tt,2)+1 R1000 gets over the number of digits issue

One thing I'm not clear about with classic outlook - support ceases in 2029. But does that mean classic outlook will stop working? Support for access 2010 ceased whatever time ago, but it still works, as do earlier versions of windows. The bigger risk to me, supporting a number of commercial...

At the moment it is the only solution for working with received emails if you don't have classic outlook. As a private individual there may be alternatives to new outlook which you can use, but many businesses are unlikely to move away from new outlook. There have been a number of presentations...