Search results

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

ilanray, First, I agree with the others that checking that there are records in the recordset (eg Not EOF) is fundamental. Second, do you have any evidence that the recordset has any values? And what those values may be? You could do a recordcount. It just seems that you may be assuming...

Kev, How did they deal with this before you joined the company? Or is this some new process since your arrival?

Does anyone understand the requirement sufficiently well -- and can provide a description of same?