Hello, We use the attached worksheet to track inbound containers to our warehouse. there can be as many as 50-70 per week. I would like to get an access table created to do this. This Table have multiple simultaneous users. And be used for storing, retrieving, manipulating data. Hoping to get some help on this as my access use in the the past is very limited. Thanks in advance.
Import your excel table into an Access DB. Once you have imported it, create a Form to input future data. Build your queries using the QBE. Here is a link to a tutorial on Access if you are not well versed. Use the Access wizards to do this.
http://www.accessmvp.com/strive4peace/
Crystal has a basic tutorial that will get you started. I have created a very basic start attached using the procedure outlined above. You may wish to redesign the form.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you very much for your reply Alan, I will check it out soon. I appreciate it!
Hello Alan, Excuse my lack of knowledge but how do you get the Form Log to update to another container's information for editing or such? I tried entering in another number in the container field but the information does not change? Operator error i'm sure.
Dont worry about that last request, I think I have it figured out. I will start another post if more questions arise. Thanks for the help, and the link above.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks