Search results

I don't want to set the default value of the control to the form behind it simply because I won't always access this form in this manner. I know I did it last time without having to code on both forms as well. I coded only on the original form and it passed the data through to the next form.

I can't believe how easy this is but I'm still having issues. My original database was corrupted prompting me to need to do this again and i can't find the original source I used to solve this problem. I have a form (Main_Inventory) that has a button on it with an event procedure behind it...

Great this worked perfectly. I'm sure I could search it out, but now it asks me if I want to continue and update the 1 record for each line in the item table. Anyway I can get it to always answer "yes" to that question?

Actually, what if my item field is NOT number data type? Its actually TEXT data type.

Thanks for this. I'll try it out. I like to keep inventory snapshots every once in a while so I can track the movement of inventory over time. That's the reason for saving the values. Our system is set up around evaluating inventory allocated to multiple online selling channels at a time, so...

I tried the SQl you gave me and that creates something that can be useful. I'd still like to try the recordset option if possible. Do you have any idea how to fix the problem I'm seeing now?

I tried the original fix that you gave me and now its updating ALL the records in the item table to the same value. I need it to only update the amounts for each item. Do I have to add something to the SQL statement that would create a relationship between the Recordset and the Item table?

Thank you for the reply. I will certainly try this out. The answer to your question about why not join my item table to the query is I had not idea you can do that. How would I go about joining the two?

I’m trying to create a function to keep track of inventory levels and I’m having a little problem with the VBA code I’m putting in. I have a 2 tables that look like this tbl.Transactions Fields (TransactionID (PK), Date, Item (FK-tbl.Item.[Child_SKU]), Type (‘Credit’ or...

Thank you. This works perfectly.

I have a new Column on a table that I need to start filling in the data for existing records within my table. In order to determine exactly which records need a value for this column, I exported a query that specified which records meet the criteria of needing a value for the new column. I...

Thanks for your reply. I'm no database guru, but I'm pretty sure my tables are in the 3rd normal form. What problems do you see specifically with what I described? Second, I understand that as a general rule you don't want to store calculated fields such as age, etc. in a table. However...

I have a table that stores individual costs associated with products in my database, and then also stores the sum of those costs in a "Finished Cost" column. I do need to store the "Finished Cost" data because we use it all over the place. I'm wondering what is the best way to automatically sum...