Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Misc

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-06-2018, 07:44 AM
JesterGrafix JesterGrafix is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2018
Posts: 2
JesterGrafix is on a distinguished road
Default Create an part order form in Access


Good morning. I have been searching around the internet trying to figure this out. I am new to Access so it's all kind of confusing to me so far. Basically what I need is to create a form in Access that people can fill out that will list items that they need. I have a complete list of the available parts that I currently have on hand. This list includes:
  • Part Number
  • Description
  • Manufacture
  • Manufacture Item Number
They will also need to be able to add this information for items that are not currently on my current list. My initial thought would be that the person could do a search for the item, for instance using the Manufacture Item Number or a key word in the part description, for example "bearing". When the part is found maybe they click a button that adds it to the list of needed items. They will manually add some information to the order, for instance their name and where the item will be used (a machine number). If anyone could point me in the right direction this would be a huge help to me! I work in a parts crib in a factory and the current system for someone to request items to be ordered is clunky at best using a very outdated Excel sheet. This project could also be done in Excel, I only wanted Access because I have seen some very nice forms made in it that look and seem very functional. Thanks for taking the time to read this!!!
Reply With Quote
  #2  
Old 05-06-2018, 03:44 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,249
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Please visit AccessForum.net (http://www.accessforums.net/) for Access related discussions
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-06-2018, 04:01 PM
JesterGrafix JesterGrafix is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2018
Posts: 2
JesterGrafix is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Please visit AccessForum.net (http://www.accessforums.net/) for Access related discussions
Thanks so much!
Reply With Quote
Reply

Tags
access, form, order

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unprotecting just one part of a protected form. snowboarder2 Word 1 08-24-2016 02:01 PM
Best options for setting tab order in a form DBrooks Word 1 02-16-2013 01:32 PM
Purchase Order Form eddt1 Office 12 11-28-2012 02:00 PM
3-part perforated form mags Mail Merge 1 01-14-2011 08:12 PM
Create a Custome Form and export data to Access ashleybyrdnc Office 0 03-05-2010 09:41 AM


All times are GMT -7. The time now is 06:35 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft