Parts Database Qty In - Qty Out
Nov 8, 2006
Hello!
Simple one for most, but I have having problems with a Database I am setting up
The database controls stock movement (i.e. inwards stock and outwards stock)
I have set up a Parts Inwards table with the following fields:
Part Number (linked)
Qty In
Stock Location
And I have set up a Parts Out bound with the following fields:
Part Number (linked)
Qty Out
Stock Location
Now for the problem, when I run a query to tell me how many parts I have left in the stock room i.e. Qty In - Qty Out, it duplicates the data in the Qty In.
I assume its got something to do with the fact that I have multiple Qty out’s for a single Qty In entry…hope this make sense?
Can someone help?
View Replies
ADVERTISEMENT
Jun 25, 2013
how to restrict access to forms and reports using the Active Directory. It is a pretty simple method to pick up and easy to use in any database. My problem comes when I try to apply this same method to tables and queries as well.
View 5 Replies
View Related
May 24, 2014
I am creating a Machinery database to match parts up with equipment. So they can see what the Equipment is and all the available parts. The sort needs to be like this
First Sort:
If the manufacturer of the machine is the same as the manufacturer of the part sort that at top then sort alphabetical
Is this possible? Each equipment would have a different manufacturer so I can not do some type of hard coding.
View 1 Replies
View Related
May 22, 2013
I am currently creating a form to input new return parts into a database. I am trying to automatically generate a tracking number (##-AA-####-####). I have gotten myself to generate the ##-AA-#### in a list box and almost was able to generate the sequence number, 0001, 0002, etc. using the dmax function. I would like to generate the sequence number one higher than the highest, depending on part type and last 4 digits of part number. Our parts have unique last 4 different p/n but more than one can fall under the same type.
View 14 Replies
View Related
Jul 5, 2006
In a field “NAME” I have “Adam Smith”.
From this field I want in a QBE window (not in VB) to make two new fields “FIRST NAME” “Adam” and “LAST NAME” “Smith”.
In Excel there are the functions FIND and SEARCH with which I take the number of the gap “ ” (5) between Adam and Smith and with the functions LEN, RIGHTS and LEFTS I have a result.
What could I do in Access 2003?
View 3 Replies
View Related
Apr 28, 2008
Hi,
I am trying to delete a part of a string but not all of it.
For example; American Express Inc. I would like to delete only the "Inc.", but leave "American Express".
How is this done?
Many Thanks,
Tim
View 4 Replies
View Related
Mar 1, 2006
Hello All,
I am new to this forum :) and learning Access :confused: .
The Database
Tables:
Employees
Products
ExpectedQuantity
PartQTY
Parts
Most of the products are similar so they have the same parts for the majority. However they do not all have the same parts. So I created a parts table that contains all the parts needed for any product. Now each Product also can contain multiples of one part (such as wheels) where I would want to list the Product and the parts list and quantity needed of those individual parts for that product. Hence the PartQTY table.
Now what I want to be able to do, is go into a form where each record is one of the products. A subform (datasheet view) for that product that shows all the parts and the quantity of each part that make up the product. Such as 4
wheels, 5 screws, etc for Product A.
I would like there to be an ExpectedQauntity field in the main form which once you found the product you can enter in the number of that product expected. Then this Qauntity would be multiplied by the qauntity of each part required (in the datasheet subform a column with =[expectedQTY]*[PartQTY]) and list next to each part the number needed to order. So if for product A the expected quantity is 50 I would have to order 200 wheels and 250 screws for that product.
A report would Sum each part qauntity after the expectedqauntity has been entered for each product. So I could print a report that tells me how many of each part we need to order based on the expected qauntity of all the products.
I think I am complicating things and would like a fresh mind to assist me in which direction to go.
Thank You,
Adam
View 9 Replies
View Related
Feb 27, 2008
I know how to Grab the Right and left Characters and grab the mid characters from a field value
ex: Right([fieldName],4)
My question is how to I grab characters based on a space
Say for instance "Fred Smith" or a name field. There are going to be varing lengths of last names...but the format is the same...First Name, Space, Last Name....
QUESTIONS:
How do I search the string, count to the space, then take all characters after the Space?
One step further how would I grab the middle name in this example?
"Fred M Smith"
View 14 Replies
View Related
May 6, 2012
How to find out the Salary. A school remains closed for Winter vacation from 15th Dec. of Current year to 28-29 Feb next year.)
The management disburse the salary to the school as per following procedure
If the Employee has not completed 6 months period (180 days) as on 15th December of current year he will not be entitled to winter salary (2 and a half months) from 16th Dec. of current year to Last day of Feb. next year. For rest of the period he will get normal salary. i.e. for 11 days of June and July, August, Sept. Oct, Nov and 15 days of Dec. of current year he will get full salary.
To elaborate it further it means that if an employee has been appointed on 19th June of the current year his winter salary with effect from 16th Dec. of current year to last day of Feb next Year will not be disbursed. For other time period he is entitled for normal salary.
View 6 Replies
View Related
Jun 30, 2006
OK, here's my delima (my head is spinning)
I have a standard Product table:
tblProducts
ProductID (PK)
ProductName
VendorName
Description
UnitPrice
InStock
Every Product has many Parts, but one Part may go to many Products
I will build this table:
tblProductParts
PartID (PK)
PartName
VendorName
Description
UnitPrice
InStock
How would I relate them together? I figure I need to use a Many to Many, with this table inbetween:
tblProductPartsList
ProductPartsListID (PK)
ProductID (FK to tblProducts)
PartID (FK to tblProductParts)
I feel like I'm missing something, can you let me know what you think???
THANKS!!!
View 5 Replies
View Related
Aug 8, 2006
I have one field with complete url´s.
Example
http://www.rocketspanish.com/links_spanish_immersion.php
or
http://apps5.oingo.com/apps/domainpark/results.cgi?q=naco&cid=ca-dp-260com_nopop&url=http%3A%2F%2Fnaco.com%2F&hl=en&ac=s
I like to make a groupby but only from the left side up to ".com"
Is there a way to select only the text untill ".com"
Thanks
Wouter
View 2 Replies
View Related
Aug 8, 2007
Hi, can anyone help me do this...
In my products table I have fields such as Bulletpoint1, Bulletpoint2, MainDescription etc.
Each holds part of the product description
In a seperate table I have my description templates with placeholders for the bulletpoints and maindescription. for example....
<ul><li><!-- Bulletpoint1 --></li><li><!-- Bulletpoint2 --><li></ul>
Now, for each record I want to grab the template and replace the placeholders with the real text.
I've got as far as putting this in a query...
Expr1: Replace([DescTemplates]![TemplateData], "<!-- Bulletpoint1 -->", [Products]![Bulletpoint1])
That does the job nicely or the first bulletpoint but where from there? There must be a neater way than having a load of query columns each updating the last. ie.
Expr2: Replace([Expr1], "<--Bulletpoint2 -->", ...
Expr3: Replace([Expr2],...
Or is that the simplest way of doing it?
Cheers!
View 1 Replies
View Related
Jan 1, 2008
If I have three fields
Surname - text
Given name - text
Dateofbirth - dd/mm/yyyy
how can I generate a field consisting of
surname(then)first letter of given name (then) year of birth
(ie SMITHK66)
Thanks in advance
View 2 Replies
View Related
Aug 2, 2012
I have a table with an ID and PartNumber field.
Parts tbl
PartNumID PK(Auto)
PartNumber
Heres some example data:
1 M24308/2-2F
2 M24308/4-2F
3 ORD9F0000
4 ORD9M0000
5 D90000VLO
6 D90000JOO
How would I design the table to allow me to define alternatepart numbers and also related parts? For example:
Record 1 is the primary part and record 3 is the alternatepart.
Record 2 is the primary part and record 4 is the alternatepart.
Records 5 and 6 are related parts to records 1, 2, 3 and 4.
I have a form that allows the user to select a part and displaythe part data. But I also want the alternate parts and related parts displayedon the form, maybe in a subform with tabs. I havent gotten there yet because Icant determine the table design.
View 3 Replies
View Related
Oct 27, 2005
i've created a database for city permits to be issued (which works perfectly thanx to alll your help), but now i need to be able to print out 1 permit at a time when it is issued (immediately after the data has been entered into the forms). i have 3 tables & 3 forms: contractors/owners, permtOrders (which has tabs for the different types of permits), and permitOrderDetails. the problem is the forms are set up for data entry (and only open in add mode for obvious reasons)...i need to be able to print an actual permit (like the carbon copy, landscape kind that usually tears out of a book). once the user enters the information into the forms, i need a little bit of that info from each form to be carried onto the actual printable permit. i'm not really sure how to accomplish this. :confused: i don't really know if i explained this right, but any suggestions are greatly appreciated.
View 6 Replies
View Related
Nov 3, 2004
I'm not sure what the best way to set this up is, and I'm hoping someone can point me in the right direction.
I have a long list of different parts that I have acquired and taken inventory of. I am selling kits that contain different amounts of certain parts. For example, Kit 1 contains 2 of part A, 3 of part B, and 14 or part L. I will only be selling complete kits and not the individual parts.
Here's what I'm thinking. I need a table for the individual parts that lists the quantities of each. A table for the kits and a subtable for the kits that lists the quantities of each part. A transaction table.
Then I just need a form that has a combo box with the kits listed, date of transaction and quantity shipped, and a button that runs a query to subtract from the quantities of the individual parts based on the kits table and subtable.
Can someone please help? I'd really appreciate any tips.
Thanks.
Richie
View 5 Replies
View Related
Feb 26, 2007
I have a sales invoice table that contains parts that start with *, for example *SPR362.
I need to select only those parts that start with the *, as this is the wildcard in queries how do i select those products that start with it without it being recognised as the wildcard and selecting all records?
The field name is simply: Part
:o
Many Thanks
View 4 Replies
View Related
Nov 4, 2013
I want to create a form to search my parts.example I typed in a part number 123 , the other text box also will come out the detail about the part 123.
View 2 Replies
View Related
Nov 22, 2013
How to calculate all records that have not yet been linked to other records. For example: I have 1 Product, which is linked with multiple components which is subsequently linked to subcomponents. All these types can be linked to Alternate Parts.
In order to reduce redundant information I would like to show the unlinked parts to the user. Therefore I would like to make a query which shows all unlinked parts.
I have the following tables with subsequent PK Part Number field values:
tblProduct->ProductPN
tblComponent->ComponentPN
tblSubComponent->SubComponentPN
tblAltParts->AltPartPN
I am unable to find a appropriate query structure with criteria for this issue due to the many different fields required and the fact that if in one query all these tables are shown no data will be shown ...
View 5 Replies
View Related
Jan 8, 2014
I am running a query to some me total parts made between 2 dates. The dates are selected from a form with the query looking to this form to selected the date range.
When I run the query it shows me total parts made for each day. What i would like is a single total of parts between the range.
I assume I could achieve this by a 2nd query...
View 2 Replies
View Related
Dec 5, 2013
I have a report that is generated daily that is a TXT file that is also the has the same file name each morning. One section out of this file is needed in a database that compiles and sends out reports to our customers. This section of the TXT file is variable in length, but is always preceded and ends with a specific text string that I can search for. It is also formatted in columns that are always the same width.
I currently have to hand enter this section into the database every morning. Not the easiest of tasks... I would like to get this automated.
View 1 Replies
View Related
Dec 7, 2011
We use a lot of different pipes for our work for different projects, I have inputed some basic data into a table called item description, this conotains the pipe detail (diameter/type) supplier and length its supplied in.
What I want to do is create a form which we can populate with all the defferent types of pipe in one of our jobs. I want to create a form for adding new parts to the table so its more user friendly to other users as opposed to using the table itself.Also when we are listing down the different pipes and fitting within one of our jobs there may be a few duplicated for example there may be 3 90deg bends.
Can I create a report once the form has been populated with all the different items which groups the duplicates together and totals them up? Ideally the final report will list each different part, and the quantity/length required.
View 1 Replies
View Related
Dec 19, 2014
I have a table with the folowing structure:
ID(integer)
Value1(Double)
Value2(Double)
I need to split this table in 4 equals parts:
- count of id must be equal or close to equal(ex: 467 split in 3 x 117 and 116) for each part
- the cumulated Value1 and Value2 must be equal or close to equal for each part
View 3 Replies
View Related
May 15, 2014
hiding parts of a form if a option button is selected. There are two option buttons and two parts to the form. I would like each part of the form greyed out or made invisible depending on which radio option button is selected.
View 14 Replies
View Related
Dec 19, 2014
I have a table with the folowing structure:
ID(integer)Value1(Double)Value2(Double)
I need to split this table in 4 equals parts:
- count of id must be equal or close to equal(ex: 467 split in 3 x 117 and 116) for each part
- the cumulated Value1 and Value2 must be equal or close to equal for each part
View 11 Replies
View Related
Apr 10, 2015
I would like to create a query to show only the Work Orders that all parts ordered have been received.For the Work Order, each part ordered has a "complete" yes/no checkbox.If I use that field in the criteria of the query, it does return only parts that are "complete." However, it still shows me a Work Order where there are parts ordered but not received "not complete." how to set the query to exclude those cases and only return Work Orders that all parts ordered on the Work Order are received "complete."
View 3 Replies
View Related
