Finished Product Is Also A Raw Material
Feb 23, 2007
I'm new to Access (2002) and have been trying to learn by reading books, posts, forums and practicing with models. I've set up a database for inventory, primarily to track the cost of goods sold as raw material costs change from month to month. So far I have tables for raw materials, container sizes, suppliers, and finished products. But I have a problem - in some cases a finished product is also a raw material, so cannot appear in both tables. (Let's say we make cookies and we make ice cream, and we also make ice cream with cookies on top as a third/separate finished product!) Should cookies have two records ('CookieFinished' and 'CookieRM') and can they be linked together so cost is determined before it's part of another? Is there a better way? Thanks in advance!
View Replies
ADVERTISEMENT
Aug 19, 2013
If I had a textbox [txtTotalDay] which its days/Time was in decimals and a start textbox [txtStartDate] and a start time and number of shifts the product can run how can I accomplish this?
Example:
[txtTotalDay] = 3.50
[txtStartDate] = 8/19/13
[txtStartTime] = 6am
[txtNumOfShiftDay] = 2
ANSWER : The time/date it would finish would be 8/21/13 @ 4:00pm
View 6 Replies
View Related
May 9, 2005
i have a form, in which two of the controls on the form, are unbound image controls, which display linked images. Now i have a button, which when both images have been displayed successfully, i would like to set the enabled property of this button to true.
How can i detect, that an image has ended up linking and is now fully displayed ?
Thank You
View 1 Replies
View Related
Nov 25, 2005
What is the usual way to store the weight in a Bill of material database? Do you store the weight for each assembly and each component or only the weight of the smallest components (where the weight of each assembly is calculated by adding the weight of each component)?
The way my table is set up just now only the weight of the cast component and screws are recorded and no values are recorded for the assemblies, I just want to make sure that this set up is apropriate as I wouldn't like to redesign my table once the system is up and running.
View 1 Replies
View Related
Feb 7, 2007
Im nearly finished creating my first real production database, its pretty exciting! Theres a few things that I need to accomplish to consider it 100% working and im wondering if anyone has any input on the following matters:
1) Users import their data via an excel spreadsheet. Its all done behind the scenes. One routine pulls in information about servers from an excel spreadsheet and after formatting it via queries, puts it in the main table. The spreadsheet in question starts with the servername cell. On the spreadsheet, the first row contains the name of the server, but the second and subsequent rows contain blank space in the servername column, but imply that the rest of the information is for the various connections associated with that server listed above... IE:
Column "ServerName"
Row1: Server1 IP address Switch Etc
Row2: <blank> IP address Switch Etc
Row3: Server2 IP address Switch Etc
Row4: <blank> IP address Switch Etc
Row5: <blank> IP address Switch Etc
Row6: Server3 IP address Switch Etc
and so on and so on...
What im wondering, is if its possible to fill in the blank spots with the cell above the records that start blank? (to populate the record with its respective server). Any input on methods to accomplish this would be appreciated.
2) Is there a way to attach code to the different buttons on the record selector? For tracking purposes, everything that my users do is stored in a seperate table. The only thing I cant seem to track is when users enter a record via the main data entry form. Automated tasks are no problem, but I cant seem to find a method to attach code to, say, the next record button on the default record selector.
3) I have a few queries that collectively import data from excel. When I do this, I remove confirmation messages so that users dont have to click through a sea of 'OK's. Im wondering if theres a way to count how many records get pulled in from an import, seperate which were good and which were bad, and simply pop up a message box stating that X records were imported succesfully, and X were not due to whatever reason.
4) Is there a way to sort text as if it were a number? I have a few fields that need to be text format, but contain numbers most of the time. The sorts always put 1 above 10, 9, 8, 7, etc, and id like to either find a way to make a query that changes all single digit numbers to double digit numbers or simply sort it in a numerical format.
5) What considerations should I take into account when it comes to the amount of data that access 2003 databases can effectively store and use? Ive heard that access can effectively handle 32000 records or something to that effect. Over that, what will I be dealing with? Slow performance? A complete roadblock?
I realize that there are a lot of questions here, and by no means wish to have my work done for me. Id very greatly appreciate any feedback that anyone wishes to give 8) Even if you dont want to code routines for me, thats fine.. I actually enjoy figuring this stuff out on my own, and a simple nudge in the right direction would suffice.
Thank you so very much!
View 2 Replies
View Related
Jan 6, 2008
Hello everyone,
I've competed my Access Application...Finally! I spent 3 months developing it!
Now I've finished it! I want to put it in work.
I need someone to guide me step by step (Sorry I'm really get tired from searching :( ) how can I do to make my application working in a small network (5 computers) ???
I want that only 1 user (master) get the entire data; for exemple all the Orders placed from other users...
I searched for Split but I did't figure out how to create backend frontend?? and how to make difference between Front End Master and BackEnd?
Please Any guideness will be Highly appreciated!!
Best Regards,
View 5 Replies
View Related
Feb 28, 2008
I have completed a db and am satisfied with the structure and forms. The object window is hidden when the database is opened, and the main entry form automatically opens for the user. This db will be in a network folder and several users will have access to it. I want people to be able to enter data and run reports, but not make any changes to the database itself, or accidentally delete the database file or some other change to the structure. What is the proper way to set up the folder rights and anything else associated with the previous question?
Thanks.
View 1 Replies
View Related
Sep 21, 2006
Hi Guys,
I've tried searching the forum to no avail,
I have a table (tblBarcodes) that has two fields, Barcode & Material
The Barcode field is already populated with specific numbers, but what I need to do is when I enter a new material on my form it will assign it a barcode from the tblBarcode and then append the Material code to the that table against the relevant record.
Is this possible?
Thanks again
View 1 Replies
View Related
Jan 3, 2008
Hi
I have created a small form that hold a cube of 9 boxes on it. The idea is that it will act as a small icon that indicates the system is loading. (Purely cosmetic)
I have triggered the boxes to change colour on a loop when the form loads but the problem is that the loop function is being carried out before the form actually loads. How do I get the form to display first and then carry out the loops to change the colour of the shapes?
Thanks all...
View 5 Replies
View Related
Feb 4, 2014
I'm trying to create a report for my organization that sums the amount of material used by date. For example, I have five separate locations in my organization that all consume the same material. It gets reported separately by location. I need to know the total material consumed each day. Then I need to sort that daily total from largest to smallest quantity used. I've tried to do it in a query, and also by summing/grouping in a report. I thought this would be fairly straight forward, but no success as yet.
View 4 Replies
View Related
Nov 5, 2014
I have a Subroutine that is using CutePDF writer to create a PDF from a report, then attach it to a new message in outlook. The problem is the code runs too fast and it's looking for the file to attach before the file is created.
I'm getting
Run-time error '-2147024894 (80070002)':
Cannot find this file. Verify the path and file name are correct.
Yes, I know why I am getting the error, and yes I could use a loop timer, except it may be 5 seconds before the person finally clicks OK in CutePDF dialogue box, it may be 5 minutes or it may be 5 hours.
View 8 Replies
View Related
Apr 8, 2013
Finally got my DB straight so I am not using calculated fields however can't figure out the best way to handle the Combo Box so I do not show closed records ( Item checked out and item returned).
Please see the attached table of materials checked out and materials returned. How to setup a query so that if an item has been returned and matches the item checked out, Both the original check-in and the matching return records are filtered and not displayed in the Combo Box.
Also, I am a little worried about partial returns as when an employee only returns half the amount.
View 14 Replies
View Related
Oct 10, 2005
Maybe a strange question but what is the best way to display access forms in a PowerPoint presentation or in printed material. If i do a print screen and then tidy it up the resolution is not great.
Any ideas
View 1 Replies
View Related
Apr 27, 2014
I 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 Related
Dec 31, 2013
I have created queries from Incoming Raw Material and Out Going Raw material Tables..Now how to get balance Stock of Item wise,
My Query Look as under
item wt In Coils Out Coils Wt Bala Stock
part A 100 kg 10 3 30 Kg 7
part A 100 kg 10 5 30 Kg 5
I want that Balance Stock shall be 2 Coils of Part A , How shall I get the same result.
View 2 Replies
View Related
Mar 17, 2006
Hi..
I have a form called 'add product' and when the form is accessed it opens up a blank form.. the user scans the barcode of the product.. heres my question..
I want it to check the products table first to see if the barcode is already in there.. if it is... to bring the correct record up.. so that the quantity can be updated..if not.. to return an error message.. stating that the product already exists..
Any suggestions.. its been one of those days today.. cant think straight!
Cheers
View 5 Replies
View Related
Nov 11, 2007
Hi,
I have to calculate the quantity of the ordered products, grouped by Product_ID, and I have to be able to print this totals for specific dates.
For this query I need data from 3 tables:
tblProducts
Product_Name
tblOrders
Product_ID
Ordered_Quantity
tblCustomers
Delivery_Date
Products_Ready (Yes/No type, used for showing only those records which I need, in this case I will set it in my query to "No")
Whithout including in query Delivery_Date, everithing it's simple. I made a query, grouped by Product_ID, and running a sum on Ordered_Quantity.
But if I include Delivery_Date, because it can be different from order to order, the query doesn't show the totals the right way, once/Product_ID.
Can anyone help me on this? A piece of SQL code or everithing else is greatly appreciatde.
Thank you in advance, Attila
View 3 Replies
View Related
Oct 2, 2006
Hi,
Can some help, I have got a form with a field showing different product number on there, how is it possible to calculate the total of each product on the form?????
View 7 Replies
View Related
Oct 26, 2006
Thank you in advance for any assistance you be able to provide.
I would like some help on searching for product codes or serial numbers and formatting this into an order form a current customer form.
I have 4 main tables
CustomersID (PK)– Name, Address, City, Post Code, Tel Number
OrdersID(PK) – CustomersID(FK), Order Date,
OrderDetailsID(PK) - OrdersID(FK), ProductID(FK), Quantity
ProductsID(PK) - Code Number, Serial Number, Description, Color, Unit Price
I think I have all of these linked correctly
Here's what I am trying to achieve (so far with little success)
I have a customer form that I fill in name address etc; I then have a button that will take me to a customer order form, easy so far.
In my product table there are about 2000 separate products (spare parts for electrical appliances) so what I would like is for a popup box to appear when the order form is loaded (as a drop down or combo box isn’t practical ) so I can search for the product by code number or serial number only for a particular spare part. The description and price are fixed in the products table and should not be changed on the customer order form, I would then like the selection of the code to transpose to the order form.
In other words I would like when the code number has been entered and the product found that the info should then be added to the order form (model or serial number, part description, color and price all taken from the products table) I would like it that when the product has appeared on the order form that it cannot be changed, only by being deleted.
I know this appears to be rather basic but for some reason I am hitting a brick wall, I have looked at many db's and even tried to dissect Northwind to do what I want but cannot make it happen, now after 8 days in the wilderness I need help or guidance.
Thanks in advance
Kim
View 4 Replies
View Related
Oct 20, 2006
I have been away from access for a while now and I am sure that this is simple. I tried a search but found nothing.
The issue:
A)The user enters in a product number, if not found then a message appears to tell them so...this I know how to do
B)If the product is in the table then I would like it to display some of the fields on the form.
EX: Prd # 0659875
MSG = does not exist
ExB) prd #: 0584785
Reason No.:1
Description: abcdefg hijklm nopqr stuvwxyz
So the whole this is how do I populate the text boxes that display the fields with the proper searched critera (prd. no.)
Thanks,
viper
View 3 Replies
View Related
Jan 13, 2007
Hi
I've been trying to get my head around this and after coming up with no search results Gonna ask for ya help.
I've attached a jpg which uses sample data so nobody needs worry as the program displayed will still be available free.
What I'm trying to do is:-
Should a user build programs for general sale they can then sell the first copy at full price but should a customer wish to install other copies then the user will have the option of selling additional copies at decreasing rates depending on how many copies a client purchasesHas so saying that looking at the jpg if I was to bye a program for a network of 20 systems and want to install legal copies on each I would pay the full price for copy 1 and £75 For copies 2-20
My thinking is I first check for any multiie prices for a product when the productID is selected then if that returns >0 then I need to check the invoice system to see if a client has already payed for X copies that way I can get the correct price for the EstimateInvoice.
The Problem I'm having is I can't seem to get my head around the getting the correct record as it uses a low and high number with a listed price Please see Jpg I have been thinking of using Between Low and High of Low >= X And High<=Y But that's bothering me as I'm not sure if it would just return one record.
If returned more than one record maybe I could use sorting to get me the lowest price for X & Y but I don't feel happy with that?.
Hope that makes sense
Many Thanks
Mick
View 7 Replies
View Related
Dec 1, 2006
I have 2 tables a project table and a project additions table, they have a relationship of 1 to many. When I run the query using both tables it only gives me the results of the project numbers that match in both fields. I need to have all information from both fields.
View 1 Replies
View Related
Jul 18, 2005
I have started a type of CRM database in which all my customer information and product info is stored.
In order to create quotations for each customer, I want to be able to search and select products by product ID, adding quantities if necessary, to be printed as a report.
Any ideas?
Many thanks
View 2 Replies
View Related
Sep 19, 2014
I'm going to design an access database for an LPGas company. This company sells LPGas and LPGas cylinders.
Suppliers:
1.AlfaCylinder supplies it's cylinders(not the same kinds of cylinder as ME's)
2.MECylinder supplies it's cylinders(not the same kinds of cylinder as Alfa's)
3.PerfectGas Co. supplies it's LPGas.
Products :
This company sells cylinders and fills different kinds of cylinders with LPGas. for example, 11 kilogram LPGas in one kind and 25 kilogram LPGas in another kind and so on. Therefore, products are :
See the attachment
No problem with customers table. There are two kinds of customer. 1. Known customers 2. Unknown (everyday changing) customers. (there is a record for them in customer table named as Uncustomers, that at the end of the day, the sum of sale of this kind entered under this name.)
Problem is : As you see, there are some products with the same ID and same name or same type but different prices. How can I arrange the product table?
View 4 Replies
View Related
Jul 23, 2013
How would i set up a table for a list,.. ie.
For each product there is a list of 5-10 things?
Product1.....Product2
a...............f
b...............g
c...............h
d...............i
e...............J
There can be new products added and new subs in the products. How can i build my table to correspond with data integrity?
View 1 Replies
View Related
Feb 21, 2012
I've got an order detail form which has
product id, product description, customer, quantity and below the form a Total quantity
When I enter the same product id, and when i press the button to update, the table of stock quantity deducts from total quantity
If I use different product ids, it doesn't work, but updates only the current product id, where the mouse current record is set by mouse.
By the way i use dlookup to check if the stockquantity has enough items.
View 10 Replies
View Related
