Results 1 to 7 of 7
  1. #1
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496

    Post error 32500: invalid group

    is there an easy (easier) way of tracking down this error?

    I am cleaning up a project where the key field (used all over the project, in multiple multiple instances) had been named "type". It has / is being renamed to be "Tag". It's not a tiny project.

    (and of course with this extensive of a task there will be misses... I' think i've gotten all of them, except this one; which may or may not be related to the change from 'type' to 'tag'. It had not been there before.) It occurs at the OnOpen event of a form that has multiple tabs, each with multiple subforms...

    (to be candid, I'm not even certain where to start looking. ANY guidance will be greatly appreciated in advance.



    Click image for larger version. 

Name:	2023-09-30_15-08-39.jpg 
Views:	17 
Size:	14.8 KB 
ID:	50834

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Wow, I would have thought both would be reserved names?
    For code use ctrl + f and search on whole project.
    Perhaps use the documenter to find no code usage?

    Perhaps find the usage next time before deciding to rename?, prevention is always better than cure?
    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

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    What method did you use to make field name change?

    Several system tables have field named Type. I found five. Hope you didn't change them.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496
    'type' Is a reserved word, but surprisingly... 'tag' is not. (Which works out well for me since 'tag' in the term used as an industry standard in the related work.)

    The project itself was first written in a very (very) simple way about 18 years ago. At that time the original author used 'type' (not paying attention to it's reserved status) because that would have been the related industry term at that time. Since then it has incrementally been expanded -with the field name never having been adjusted, most likely b/c there were multiple related tables being used (each account was using a dedicated back-end file) and many tables in those files also included a field named: 'type' - all of which would to have been updated. More work than the warranted -at that time.

    NTL... For renaming, i have been using V-tools which has been very effective and has made the task MUCH easier (although you do need to be attentive to erroneous changes.) I hihchly recommend the investment (there is a try-for-free download available.)

    https://www.skrol29.com/us/vtools.php#download

    anyhow... my question was not so much about the renaming, but more about error (#32500)
    ...which i'm still working on)
    =:-(

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    So please explain how you resolved it. This site like others is here to help people, which is why you came here?
    So try and give back? It might help someone else, you never know?
    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

  6. #6
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496
    agreed. and i should have.
    and where i can... (100% self taught here, so...'where i can cautiously'), i try to


    ...unfortunately, i jumped the gun on 'issue solved'; it is not...
    They way i look at it, every 'issue' is an opportunity to learn something new.
    In this case, i still have a lesson in progress !

  7. #7
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    according to AB it is a reserved word
    http://www.allenbrowne.com/AppIssueBadWord.html#T

    Did you try stepping through the code to identify what line raises the error, or do you already know what is happening at that point?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 14
    Last Post: 08-18-2023, 04:16 PM
  2. SQL error for invalid name
    By Huddle in forum Queries
    Replies: 4
    Last Post: 10-15-2021, 11:24 AM
  3. Replies: 3
    Last Post: 05-10-2018, 07:48 AM
  4. Replies: 3
    Last Post: 07-12-2017, 04:29 PM
  5. Invalid Argument Error
    By koper in forum Access
    Replies: 2
    Last Post: 06-14-2010, 11:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums