Search results

  1. C

    Working with form records

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

    Help with looping through records

    Less typing with ! 😀
  3. C

    Help with looping through records

    Actually that should be RS!EmailID
  4. C

    AWF Slowing Down

    I see number of threads and posts, not views
  5. C

    AWF Slowing Down

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

    AWF Slowing Down

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

    AWF Slowing Down

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

    AWF Slowing Down

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

    Where and what were you doing on 9/11/2001?

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

    Where and what were you doing on 9/11/2001?

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

    Plus One to Alpha Field

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

    DoCmd.SendObject and CDO

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

    DoCmd.SendObject and CDO

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

    Continuous form Allow Edits=False locks fields in form header

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

    Working with Timesheet Form

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

    Cumulative Total with a Curve Ball

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

    A great idea to fix our universities

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

    Form sizing / scrolling for smaller screens

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

    Re-design a wellworking data base

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

    Advice on how to improve query efficiency when Filtering on nvarchar(4000)

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