Hello World!
Ok, so I am working on a project and I want some advice from some Access experts on the best way to get this accomplished. So I have a huge list of inventory 200,000 + I run a macro and I get a table with a sample of exactly 100 items. I then print of a report that has one column for what the measurements should be, and another column with a blank space to fill in if that value is different. 100 reports takes about a week to fill out by 5 different people, because there are about 15 different variables on each report.
Keep in mind that each reports values are completely different depending on the item. So the problem that I have is that I want to be able to record and track each item that has gone through the report, and verify each value that was correct and if it wasn’t correct , what value it was changed too. I am getting better with visual basic and I do have coding background in Python. I have already figured out how to add the incorrect data to the table. Although, there are so many variable possibilities I also need to be able to add the data that is correct which would be chosen by a check box.
I also want to be able to pre-populate the form based on a text box that I type in at the beginning.Is a way that it will just pre-populate and go through the entire table in order? Because I don’t want to have to fill out two columns each time I complete this form. Finally once I am able to add both the correct and incorrect smoothly. I then plan to append a query to find the percentages of correct vs. incorrect which variables they were etc.
As you can see I already have a plan and am working on it, I could just really use some direction! I really appreciate the help, also please be as detailed as possible.
Thanks!
Ok, so I am working on a project and I want some advice from some Access experts on the best way to get this accomplished. So I have a huge list of inventory 200,000 + I run a macro and I get a table with a sample of exactly 100 items. I then print of a report that has one column for what the measurements should be, and another column with a blank space to fill in if that value is different. 100 reports takes about a week to fill out by 5 different people, because there are about 15 different variables on each report.
Keep in mind that each reports values are completely different depending on the item. So the problem that I have is that I want to be able to record and track each item that has gone through the report, and verify each value that was correct and if it wasn’t correct , what value it was changed too. I am getting better with visual basic and I do have coding background in Python. I have already figured out how to add the incorrect data to the table. Although, there are so many variable possibilities I also need to be able to add the data that is correct which would be chosen by a check box.
I also want to be able to pre-populate the form based on a text box that I type in at the beginning.Is a way that it will just pre-populate and go through the entire table in order? Because I don’t want to have to fill out two columns each time I complete this form. Finally once I am able to add both the correct and incorrect smoothly. I then plan to append a query to find the percentages of correct vs. incorrect which variables they were etc.
As you can see I already have a plan and am working on it, I could just really use some direction! I really appreciate the help, also please be as detailed as possible.
Thanks!
