Im looking at creating an MS Access database for manufacturing items. Ill need to be able to create default items to be made and also use this to assign members of a team a list of items to make for a current day of the week which i can then input back into the database to keep it up to date with what they have made, have they kept to targets etc....
View RepliesI need to create a small inventory database tracking product in stock and "x" amount of raw material to create it.
Is there a way, using MS Access that I can track inventory of the product as well as update how much material was used to create the product?
I am new to access but I know how to create a database and enter the fields I want, eg: product id, model number, product color, in stock, re order, lead time.
My problem is associating another table to deduct/or add the amount of material based on totals.
In a nutshell, I want to track product inventory as well as track raw material in stock to create more.
Thank you for any help!
I am creating a database for creating quotations. The quotation number is generated using the date, for example the first quote today would be quote number "05202015-1" because it is the first one today. The next quote today would be quote number "05202015-2" and so on. Is there a way to make access automatically generate these quote numbers based on the date?
View 3 Replies View RelatedI want a good describe about how to create database for supermarket specially how to build a form for selling item, what is a structure of tables ........
View 1 Replies View RelatedI can use barcode scanning to track items through the process, on the condition that the relevant field on a form is highlighted.
The issue is I want the scanning/tracking with wireless scanners to be going on in the background while an operator can use the other functions of the database.
I'm thinking the solution is two computers, one to run the barcode scanning & tracking the other for the rest of the database functions. The problem is we only have one work PC and getting money for a new PC will be like pulling teeth.
Is there a one PC solution?
is there a way to create a profile on each person on my database, to show their contact details and whether they've made a purchase from me before, or must I literally just make a table entering each individual person and purchase?
My boss (in another job) showed me very quickly an extremely old database one of his old employees had made for him years ago containing all of his clients, each shown individually, and he was able to click through each one, and each window showed the client's name, contact details, personal details, etc. and he just had hundreds of entries for all of his clients and was able to scan through each individual one. I am 99% sure he said it was on Microsoft Access that he'd done it.I just want to monitor how many of mailing list subscribers have also made purchases and whatnot, as I do rewards for them, and it'll be much easier to view each person's profile and the orders they've made than have to scan through a table to find each separate order?
I just want to know how to manage items in set and individual item. Suppose my product list are
individual items = A,B,C,D,E,F,G,H,I,J,K
and 5 pc set = A,B,C,D,F
and 3 pc set = G,H,K
How should I design the table. Previously I designed the table for individual items and whenever orders for set is placed user had to enter individual items with quantity.
E.g. order is for 5 pc set = 3000
A=3000
B=3000
C=3000
D=3000
F=3000
Now I need to just say 5 pc set and it should be automatically populated. And also if order have combination of individual and set items.
I am looking to create something called a "transactional" database that tracks historical information.I want to track and keep a record of employees at my organization who have had disciplinary action. We currently have a 5 step approach leading to termination.Eg. Step 1: receive Letter #1 Step 2: receive letter #2 + manager meeting step 3: receive letter 3 + manager and director meeting, etc etc.
I believe this is transactional because for each employee, we would need to see when they received the letter in the past, and an employee may receive two or three "step 1 letter 1" notices due to whatever circumstance.I stumbled upon this database and I found the bottom part where you Add/Edit Employee is what I am looking to do...except I can't Design view or anything to see how all this cool stuff is done! The link is: access-programmers.co.uk/forums/showthread.php?t=154187
Essentially, I want to create a user friendly database like the link above where a clerk/admin assistant can open Access, search for an employee by name or department or manager, and then be prompted to add information such as Letter #2 delivered, manager meeting occured, employee signature, etc.
I'm creating a database full of contacts. I have a contacts table with detailed info on each contact and I also have a company table with details on each company - all companies attached to a contact are in the company table plus a few others. I'd like to be able to pull up a company profile and see all the contacts we have associated with that company displayed in a list.
View 1 Replies View RelatedI am trying to create a Special Recorded tracking database where a member of staff will log the tracker number into the database and then at a later date someone can come and update the data, what I want to do is scan the tracker barcode with a scan gun and its details appear for updating, I can do this part but when I make any amendments to the data it doesn't save the new data and I don't know why? I am using a combobox to display the tracker number and me.text1.value = me.combo4.column(1) and so on and so forth to display the data, when I change this data it doesn't save.
View 1 Replies View RelatedI would like to Create a database for indexing / organizing PDF documents. My Company currently use a 3rd party accounts program and we raise sales and purchases using numerical numbers ( but we can Jump to a new range of numbers within the program) for example if the purchase order numbers become simliar to the sales order numbers. But this 3rd party software does not let us scan documents into it hence the need for an alternative database.
For the data base I was thinking if only creating a index of the sales order numbers to start with. the first few question I have are.
1.) Should I Use the Autonumber as my first index column or should I replace it with our own sales order numbers in that column.
2.) is there a way to autopopulate the sales order numbers in a table for historical sales numbers.
3.) can you scan directly into Access
How to start planning the design off the database as I know this is almost the most important aspect of a database.
Why Access (2010) database is creating backup copy by itself?
View 2 Replies View RelatedI am looking to design and create a user interface for my database. Preferably hiding the standard access interface and upon opening the database have a pop up form with buttons to direct users to forms queries.
View 3 Replies View RelatedI read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.
Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.
I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?
I've changed my splash screen for a database using the method of creating an alternative bitmap.Is there a time setting for this or an alternative?
View 6 Replies View RelatedHow do I create a table that can cross index items in another table. Maybe I am not using the right terms here so let me show a small example.
Say I have a tables of words.
tblWords
numWordID
txtWord
Then I have some entries, all more or less synonyms of each others
fresh
new
clean
Now I want to create a cross-index table, related to the table "tblWords" where I can select synonyms from words already in the table "tblWords", so if I for the word "fresh" add "new" and "clean" as synonyms or entries, if I then go and look at the word "new" it will already have the synonyms "fresh" and "clean", likewise the entry "clean" will then have the synonyms "fresh" and "new".
Kind of a many to many relationship junction table but only with one table!
I hope my explanation have not been to confusing, but let me know if you need a clarification.
Thanks
Hi just started working for a Company and I found they have tons of
databases but no structure or standard, so I would like to build a tool that will go thrue a list of databases and get all the table names, the items and type. Is there functions in vba that can get me a list of the tables in the database and the get all the items in the database ?
Thanks on any input
I have a listbox control on my form which works in conjunction with my search field on the first form. I can add new items with FRM_ItemsAdd. I can delete records by pressing the delete button.
However now I want the ability to Edit items in the list. How can I tell access I want to edit a record?
Attached is my access db.
I have a query that I would like to put a count into but I don't know how
1. count how many line items there are in the query
2 count how many line items there are where the "days late" are
I'm creating a database for my job. I have 4 tables with information. When I need to deliver some items i must know which items to take, They are in those 4 tables.
I want to make it that i can click a menu on my switchboard that i see a report with all the information with a clickbox behind it. If i select this box and click a button generate it creates a report with all the items i've selected with the select box.
So in short:
1.) How do I create a table with all the items from the other tables that are automatic updated when insert a items in one of those 4 tables.
2.) How do I create a report where i can select some items that are generating a report with the selected items.
I work in the Insurance Industry and I am having a hard time trying to find the formula for finding the answer to the below issue I am having.
In a table I have 4 columns:
1st: Total # of Claims (Claim Count)
2nd: Total # of Items (Item Count)
3rd: Item % of Claim Count
4th: Average # of Items per Claim (This is the number which I am trying to get)
Is there a formula which could give me the "Average # of Items per Claim"?
I have two versions of the switchboard items table. (A2003 switchboard). I have a login form, and I want to be able to change the switchboard items for different users
so I have code that does this
close the switchboard,
copy the new switchboard items table
reopen the switchboard
And every time, it says it cannot copy the table because the switchboard items table is in use. The code in the switchboard opens recordsets, and I have quadruple checked that they are closing correctly, after use. The switchboard itself is bound to the switchboard items table
I have just tried something different which is to manually close the switchboard - and then I CAN copy the tables.
Might the code be atomic in some way. The switchboard does not release the locks until the code completes?
I thought about it, and got round it now, by just copying the data from the new table to the master table, rather than trying to copy tables, but I am still curious.
I am trying to create a list box that passes to the database a value that is different from what shown in the drop down list. For instance, I want to show the users a drop down list with "Yes" and "No", but then storing into the database "1" when "Yes" is selected and "2" when "No" is selected.
View 1 Replies View RelatedI have a form that could have duplicate material descriptions , is it possible to have on that form a field that counts the number of line items for that material and when the material changes the new number will appear .
View 7 Replies View RelatedI have two tables to track our engineer visits, one tracks the visit as a whole and the other tracks the individual instruments the engineer worked on during that visit. This way I can track visits to customer sites separately to the visits made to an individual instrument.
Right now, I create a visit and then add Visit Lines (containing the details of the instrument visited). These instruments, or 'Visit Lines', are being displayed in the Visits Table via a related items box. Visit lines are associated with Instruments in the Instrument Table via a serial number lookup. All this works great...
However, I want to display both the serial number and the instrument description in the related items control in the Visits Table. Since the Visit Lines table only has the instrument ID lookup and not the instrument description I can't display it in the control.
I need to either:
a) Create an instrument description in the Visit Lines table as a lookup and have this automatically pull in the description based on the serial number the user selects.... which I can't figure out how to do - it's just an autocomplete.
b) Create an instrument description in Visit Lines and have a macro grab the corresponding description from the Instruments table based on the serial number input - but just for this record...
I have a table of items for our companies quotes. When we go to print out our quotes to send to the customers, the salespeople would like most of the items to be grouped under certain "headers" for the systems they are part of.
Ex:
Autopilot System
Part #1 Qty 2
Part #2 Qty 1
PA/GA System
Part #4 Qty 4
Part #5 Qty 1
My 'Items' table currently has these fields:
ID (PK)
System_ID (FK for 'Systems' table)
Part_No
Qty
etc...
'Systems' table has these:
ID (PK)
Sys_Description
I have a query using a RIGHT JOIN and a GROUP BY to tie everything together, I'm just not certain how to go about displaying the information the way I did above.