Inputing Pounds And Ounces...
Sep 21, 2005
I have table with item details...in the item details, I need to put the weight of the item in order to calculate the Price Per Pound. but the problem is that not all items are calculated by pound and some of them just need to have individual weight entered to so we could identify which is large and small...
so in a way I have to put like 2lbs or 2oz... how would I go about doing that?
later I need to divide some of them by total but not all. should I make a another field for lbs or oz?
View Replies
May 27, 2005
Hi everyone,
i have 2 tables with one is called companies and one is contacts, is it possible to use one field on a form to input the company name into both tables at the same time?
thanks for any help
David
View 2 Replies
View Related
Aug 2, 2005
What Im trying to do is make invoices that I have in to data base...
reason for it is to keep a close watch on the price fluctuation since the stuff we get are from different country. We don't really need it but this is my own little project just for myself...I have all the tables made and form ready but I have couple of problems.
1. How do I calculate and save it in the table? I Know this violates 3rd normalization but I need to do this since the price will change almost every week. basic calculation which is total price / quantity.
2. How do I get the previous record on the form automatically? lets say that the date I put in is July,4,2005. How do I get this to show up in form for the new data input? and keep that date until it is updated using form.
3. Since I'll be getting same stuff lots of times, and since they all have item number, How do I get it to auto fill? lets say that I input a item number and rest of the form automatically fills in the rest of the values...and updates are saved to the table and next time I input the same item number updated data will automatically fill in the rest.
Thanks in advance. This is my first post so, please go easy on me...:)
I also search the forum but couldn't find anything that I understood...
Is this a project too advanced for newbies? As I have stated earlier, I have everything layout but I'm just trying to make it easier inputing new data.
and all the codes that are here, I'm lead to believe they are Visual Basic.
and good book for newbies on VB?
Thanks. and sorry for the long post...
View 1 Replies
View Related
Feb 28, 2005
I'm looking for a way to have a form set up that has a submit button on it so that when it is pressed it takes the data and inserts it into a table. I need to make sure the button is only pressed one time. And.... I would like to take away the new record, previous record ect.. buttons at the bottom off the form. This possible?
View 3 Replies
View Related
Jan 13, 2005
How would I modify multiple comboboxes in subforms at the same time. For example.. In main form ComboboxA user selects 1992, Combobox1 in subform1 is also changed to 1992, as well as Combobox2 in subform 2.
Whats the best way to do this?
View 2 Replies
View Related