History report

[DirkWagemans]

Hello professionals,

Only recently have I started working with Access as a starting IT-engineer.
I currently have a project to create an Inventory Management System from scratch.

What I want to program is a "history report".
All changes made to the inventory database need to be registered on a form. This form needs to contain the editor (by name) and the user (by name). Also the date, item and cost need to be displayed on this form. Preferably all in 1 line if that fits.

I could simply make the changes added to a different table and manually wipe that each month after printing the report.
Can I make it so all changes to the inventory are documented from pressing "accept" maybe just copy all data input into the form to a report/table. At the end of the month an engineer can print the form. Then can the history be wiped to make place for a new month with new changes?

Sorry if it's cryptic, I'm a pleb still.

Feel free to ask any questions. I am currently still in the designing phase so all I can offer at the moment is a mock-up, but if images are better, please let me know!

Thanks in advance!

 

[plog]

can the history be wiped to make place for a new month with new changes?

That's a bad idea. Generally you don't wipe/delete/purge/move data in a database. You use logic to retrieve just what you want.

With that said, I can't open whatever file you attached--what's a bmpr file? Hopefully that was a screenshot of your relationships and not what you want your form to look like. Forms are the last step of the process. First you set up your tables properly, then you build the reports you want to verify you can get the data out of your database, then finally you build input forms to add data.

Please post your table structure in a format I can get to (.bmp, .gif, .jpg, etc.)

 

[DirkWagemans]

You're completely right. It would be better to simply add a query to the "print report" that will prompt you to select the date of logged data you wish to view / print a report of.

A .bmpr file is a Balsamiq Project file, which is a mock-up of the design of the forms (not the tables).

I will probably simply add a "logging table" where the data will be copied to after the change goes through in the inventory. This logging table will then never be wiped but engineers can simply select the time span they wish to see information of in a report view.

So: click "print report" --> prompt for time span --> query to get the prompted data --> view report --> print

 

[plog]

Actually I would create a form for the user to input the time spans. Then use VBA to open your report.

Form-->user input dates-->user click 'View Report'-->VBA to open Report to desired data-->print