Search results

Many Thanks for the reply!! I've tried all the cycle options, and look at all of the tab layouts, But can't solve, this problem, I anyone can throw more information on the problem, I look forward to your reply.

I have downloaded Northwind 2007, I'm having a problem with the tab sequence when entering the products to order, when I reach the Total Price, and press TAB the curser jumps back to the top of the page. What I want to happen, is that when get to the Total Price, and press Tab, I want to go...

I have a form that I'm working on, but I'm having problems getting the data to sort in "Fathers Full Name" order as opposed to GED Family ID. I have no VBA experience. I have posted a copy of the code that relates to the form that I'm using. When the form loads, All I want to be able to do is...

I think for this purpose, it would be great to maintain both the current price as well as previous prices for a product. With regards to the additional table to track price changes for products what would you suggest the new table contains, and what if any relationships to the current tables?

Okay, I have spent the last couple of days creating some test data, and creating some of the reports. The next task for me to complete relates to the ProductBOM table, so far I have managed to create most of the BOM Files along with Components and Qty’s that I require. Is there a way of...

RE -: The relationship between the log and stock transactions, Technically, any log event, except for the temperature test, should create a transaction for the product used in order to carry out such an event. The temperature tests is the only log event that I can think of that has no effect on...

At last found out where I was going wrong. When making the sub form, I was not bringing the PProduct(ID) into the form. All of the videos I have watched all forgot to mention that in my case the PProduct would be hidden on the form... Oh Boy Oh Boy. TWO DAYS, it has taken me to resolve. But...

I have created the form and subform for the ProductBom the property sheet control source is :PproductID(fk) Row Source : SELECT Products.LogID, Products.Item, Products.Description FROM Products; Row Source Type : Type/Query Bound Column : 1 When I select the combo box for PproductID (FK)...

Thank you for the reply, The Sizeincm field, I have removed it from the table, for the time being, We used this field to keep track of the maximum size the fish would grow to. I’m not sure that I fully understand what the (FK) is. My understanding is that a foreign Key, is the primary...

Further to your latest post, please find below a list of all tables Tables Component ID (PK) PEXPID (FK) Procode Inventory LogID (PK) Item Description Category Location Cost Reorder TargetStock Attachments Discontinued Comments Sizincm Inventory Transactions TransID (PK) Transaction...

JZWP22, thankyou for the reply, What I failed to mention in my previous post, is that I have created the necessary forms and also a subform for entering the necessary data. I am to access, so far I have been able to resolve any problems by reading hours and hours of forum posts, The...

I’ve created two tables to enable me to list component items required to make up certain products, my current database already has a “Inventory” table, and in addition I have created two tables as follows-: First Table “PEXP” PEXPID (PK) ProdCode Second Table “Component” ComponentID (PK)...

Is it possible to create a Kit/Parts Explosion List for Product’s as follows Is it possible to create a Kit/Parts Explosion List for Product’s as follows -: Product Code -: WC0001 Description -: 25% Water Change The components used to complete a 25% Water Change are as follows -: Product...

How do I write a PK from my Transaction Form to a TransactionID field on my log form? I have added a yes/no to amend stock. if y then as follows -: Private Sub AmendStock_AfterUpdate() If Me.AmendStock = -1 Then DoCmd.OpenForm "Inventory Transactions Form", , , , acFormAdd DoCmd.Close acForm...

How do I write a PK to a TransactionID field So close to completing my first database, only got one little mod to sort out. I don't know how to write the Transaction pk to the TransactionID on my log form. I have added a yes/no to amend stock. if y then as follows -: Private Sub...

Fishtank Database Programming assistance required!!! Hi Everyone, I'm looking for some assistance with programming advice in order to enable me to maintain activity logs and also maintain stock levels from with in one form. I'm currently using two forms but this is not ideal, as I'm having to...

Privateer, Thank you for your input, I was up until 03.00 inputting all of my data and I now have all of my Forms,Reports,Queries all working, now at the click of a button I can see everything that I need to know, I'am able to look at all costs, running cost and more importantly losses and...

Sorry for the confusion, The main purpose of the log table is to record all activity, things like water chemistry, water changes, water tests, have no affect on stock levels. Things like maintenance, medication, stock purchases, stock losses, all affect stock levels. Currently I use two...

The transaction item will keep track of all of the stock purchases and usages, My main form will be the log form showing -: LogID LogDate Notes Temperature Amonia Nitrite Nitrate In addition to the above I need to make the necessary changes to the Inventory. Should this be the...

Let me know how you are coming and let me know if you need any help with combo boxes. Good luck. Privateer This is what I have so far, the first four tables -: Employees, filter’s, suppliers and the transaction types, I have only given a brief description for these items. The other items I...