Search results

Richard Rost has a current youtube video on this subject. See this

I agree with Markk. This is the most positive interaction I have had with Chatgpt etc. I took a random click event and asked what it actually does; What does this click event code actually do? Private Sub cmdUpdateRowSource_Click() On Error GoTo Error_Handler If (Me.txtSQL & "") = ""...

Welcome to AWF, Kevin!

Ben, Why did you opt for Excel? I agree with George that analyzers exist, but I don't think they describe what the code does. With Access vba you can identify the buttons on every form, and you could extract the click event code for each, However, I think it will require your looking at each...

Ben, If you post a code example along with the desired result, I'm sure others will understand the requirement and offer some vba solution(s). If it's button clicks, then you're dealing with Forms. Isolate Form controls (command buttons), then the button click event code.

Welcome to AWF, Peter.

Welcome aboard AWF!

Nector, Since this is a forum intent on sharing and community, how about sharing your solution that is working so that others may benefit?

Have you tried CoPilot or Chatgpt? Just suggesting that some "definition type" questions might be answered quickly via Google/Chatgpt. Question: (to CoPilot) In MS Access what is the corresponding RunCommand equivalent for DoCmd.DoMenuItem...

Welcome to AWF!

Milhouse4118, You may want to review this article and code by Crystal(strive4peace). The purpose of the utility is Loop through all your Access databases in or under a path and copy what's in the system object table (MSysObjects) for each to the documentation database; and get file...

See this link for an example using data macros for audit logging.

MisterB, Did you save any changes you made to the form's design?

Hi George, I did not see the presentation but am interested in most things John does. I'll be watching for the edited YT. Jack

My thought was this: -manually create the table you need -supply each field and type -identify the proper field as the PK -now the table exists -next run your query to append records to the new table. OR programmatically vba code along this set up to create your table and autonumber Primary...

SpaceCowboy, Can you define the table with the fields and PK you need and then append records to that table separately?

As has been said, the autonumber field will be valued when the record is saved. It will be lost if the edit( record) is cancelled or deleted. It appears you have a concept of how Access is doing, or should be doing, something, and your current concept is not correct. Autonumbers are unique to...

Hi Rheged85. Welcome aboard AWF!

You may get some insight from this youtube video by Richard Rost.

You might try one of the existing M$oft templates Bug Tracking, or Call Tracker or Customer Service. They would give you most of the basics and you can adjust/modify to suit your needs. I agree with George's comments. There are links in my signature Database Planning and Design to many...