Solved Stub method is giving me issues

[mGraham]

Thanks for your insight guys, my boss decided to have someone he knows come work with me that knows access so I will probably be scraping the whole stub thing after all.

 

[Gasman]

I always start my question to ChatGPT as ' Access VBA to '

 

[GPGeorge]

I always start my question to ChatGPT as ' Access VBA to '

Another prompt I've heard about, but not yet had a chance to try is along the lines of.

"You've been hired as the senior developer on an Access VBA project. Use your most advanced VBA skills to solve the following problems/address the following requirements/create the following solution."

 

[The_Doc_Man]

And yet technically, that is not correct. As of a version of Access some years ago, after Ac2003 but before Ac2016, ALL Office members that use VBA use the same VBA library, so Access VBA IS Excel VBA IS Word VBA etc. The differences are the behavior and nature of the objects being referenced. Heck, I've even seen some terminal emulator software that allowed use of VBA to handle special emulation issues. I never tried to do it, but I verified that it was there and was using the VBA library.

 

[GPGeorge]

And yet technically, that is not correct. As of a version of Access some years ago, after Ac2003 but before Ac2016, ALL Office members that use VBA use the same VBA library, so Access VBA IS Excel VBA IS Word VBA etc. The differences are the behavior and nature of the objects being referenced. Heck, I've even seen some terminal emulator software that allowed use of VBA to handle special emulation issues. I never tried to do it, but I verified that it was there and was using the VBA library.

Technically correct, but beside the point.

As noted, "The differences are the behavior and nature of the objects being referenced. "

The point is to provide sufficient context to the prompt so that answers will should be pertinent to the task at hand. In this case, the context is an Access project, not a Word project and not an Excel project. The objects being referenced are Access objects, not Word objects and not Excel objects. Providing that context as the lead-in to the request is relevant and potentially crucial to getting useful responses.

AI can appear to be quite bright but still not fully grasp context. Prompt engineering requires you to provide guidance on what you do and do not want to include, or as someone has said, you need too assume the role of adult in the room.

 

[The_Doc_Man]

Technically correct, but beside the point.

The point was that previous posts didn't make the distinction that you did. Microsoft VBA is the same, syntactically, for all Office members. There is one and only one reference document for VBA. And MAN, do they ever have to split hairs when dealing with object references.