@WGM; yes, thanks. Now I seem to recall that it is Access World Forums.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I'm more active on a couple of Excel forums and I noticed that activity on those have slowed down significantly in the past month.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I suppose another benefit of AI, is they just give you what you ask, and no advice, which lot of people seem to not want to hear, when they are approaching something the wrong way, or their data structure is rubbish?
That way they can carry on, blissfully unaware.![]()
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Very true. I hassled with Copilot for 6 different tries to provide me a tab delimited list of items. Copilot insisted that each iteration would work, even guaranteed that the new iteration would work, until each time I pointed out that it did not work and showed the result. Spaces were always supplied, not tabs. Copilot has a way of praising you when you catch its mistakes, so that you don't get so irritated I suppose, until you really do (I finally told it to quit screwing around and give me a solution that worked). Same "This time it will work!", but same spaces. Copilot never suggested a different delimiter (other than the tabs that I requested). When I finally asked for a different delimiter Copilot used the vertical bar which did work fine first try.
It appears that Copilot is unable to change course when it runs into a dead end and keeps butting its head against the same wall in spite of repeated failures.
Good points Dave. I found copilot helpful to get some logic straightened out, but I also found that it gets focused on a theme/idea and is hard to adjust to the original approach. One thing I did find that led me to saying --it doesn't remember earlier requests-- I asked that, when providing code suggestions, could you provide a brief description/definition of each variable. "No problem", but it continued to give variables - no descriptions and often changed the name/spelling of variables. I did find that it did provide comments within vba code.
I did get several suggestions to expand the scope of some code and a brief description of what the expansion would do. It often led to some dead ends/frustration, but it did make me think and probably improved my prompting. I like the co-coding approach, but it does highlight that you must do review and due diligence.