Search results

  1. C

    Automation Error

    Suggest step through the code to determine which line triggers the issue - perhaps this one?
  2. C

    Updating from Access 2013 to 365?

    Yes you can get a runtime for 365 access but a full version is included in most versions of office Ensure you install the 32bit version as 64bit is now the default If you decide to install 64 bit ensure you have a full version for development purposes - you will need to make some changes to...
  3. C

    Help with formatting decimal places in calculated query field

    the format function provides a text result - use the round function 48: round(((36/48)*(([Yards]*36)*[Inches])/1296)) and 48 is a dreadful name for a field - it will get you into trouble
  4. C

    AWF Slowing Down

    the AI answer is only as good as the question asked.
  5. C

    Solved Why an overflow?

    You could try setting i1 and i2 as variant
  6. C

    Solved Why an overflow?

    Multiply an integer by an integer results in an integer value
  7. C

    Solved Dmax problems

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

    AWF Slowing Down

    So why not name them? No To recover his costs
  9. C

    AWF Slowing Down

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

    AWF Slowing Down

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

    AWF Slowing Down

    so become a jack of all trades and master of none?
  12. 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...
  13. C

    Help with looping through records

    Less typing with ! 😀
  14. C

    Help with looping through records

    Actually that should be RS!EmailID
  15. C

    AWF Slowing Down

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

    AWF Slowing Down

    You should be able to see for yourself https://www.access-programmers.co.uk/forums/
  17. 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...
  18. 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...
  19. 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.
  20. 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
Back
Top Bottom