Search results

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...

Yes - instead change the form recordset type from dynaset to snapshot

Where is the code? If on the subform try Parent.recalc

There are many ways this can be done and would help if you showed what you actually tried together with details of relevant tables and fields. I would use two queries - the first to get all the periods you want and the second to calculate the cumulative totals For the first, you may already...

Perhaps that is all you watch. We get Suits, Hollywood Wives, a variety of American sports to name a few. Really think you should use I rather than we as you seem to live a very limited life and I’d hate to think our American cousins get the impression the UK population are all like you

Sounds like what you need is larger fonts or a smaller form I would look at your form design - are there fields that do not need to be displayed all the time? Just show them on a click event. Or perhaps increase font size using the mouse over event? Or use a tab control? Or an expand feature...

Without knowing the specifics of your setup, check the documentation for your TS or google something like ‘print to local printer from terminal server’

Why are you using like? And why not indexed? The use of the initial % will negate the use of an index anyway