Search results

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

Marshall, I thought you were also checking/confirming that each table had a PK defined. If you had a routine to do so, it might help in diagnosis. It would be quick running and read-only. (AFAIK) Quick and automated to show that a PK(s) had been dropped/compromised. If all tables have a PK by...

GPG, Interesting observation/experience. Since Marshall has a procedure to check/confirm that Each Table has a PK, routine running of the procedure should identify if this condition( no PK on Table6) exists.

Sounds like a plan--- keep us updated.

Hi Ian, welcome aboard AWF!

Show your revised code "that isn't working".

Amallon, Can you describe how to interpret the graphic to show "30 x chicken currys, 4 x Lasange..."? Perhaps you could tell us more about the current display---the who what, why, when sort of approach... as Pat has asked.

You may find some info at this older thread https://www.access-programmers.co.uk/forums/threads/export-attachments-to-folder-not-putting-attachments-in-folders.309573/

Kev, That wasn't my intent. If they use VLookup everywhere, then maybe they were limited to Excel. Perhaps you are introducing the use of Access --your method to do it -and that was never done before. So from a context perspective --this could be a new process, and you are discovering some...