Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-06-2018, 07:44 AM
JesterGrafix JesterGrafix is offline Create an part order form in Access Windows 7 64bit Create an part order form in Access Office 2010 64bit
Novice
Create an part order form in Access
 
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 Create an part order form in Access Windows 7 64bit Create an part order form in Access Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Please visit AccessForum.net (http://www.accessforums.net/) for Access related discussions
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-06-2018, 04:01 PM
JesterGrafix JesterGrafix is offline Create an part order form in Access Windows 7 64bit Create an part order form in Access Office 2010 64bit
Novice
Create an part order form in Access
 
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
Create an part order form in Access Unprotecting just one part of a protected form. snowboarder2 Word 1 08-24-2016 02:01 PM
Create an part order form in Access Best options for setting tab order in a form DBrooks Word 1 02-16-2013 01:32 PM
Create an part order form in Access Purchase Order Form eddt1 Office 12 11-28-2012 02:00 PM
Create an part order form in Access 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

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft