Recent content by newbie4access

On one of my old databases, I am trying to update from one crazy huge table to many smaller tables. Because it's all about the Item, the ItemID (pk in Item_t) will be fk in many other tables (but not all of them) with a one-to-one relationship. Thus when in datasheet view of my Item_t (table)...

I'm going to try the subform way now

plog, Hi again ... I am trying your setup with the fees. But I am confused (sorry). I see how this would work if the fees remained the same, but ... all of the fees will almost always be different, never set nor consistent. For instance, a Listing Fee amount can be zero (with a special offer...

MarkK, I will try this too. Thank you so kindly for the head start. :)

plog, I will try this :) Don't be surprised if I have more questions along the way :) Thanks

Can anyone kindly share or demonstrate how to start coding this in VBA?

BlueIshDan Hi, I removed it; I still get the same #Error/s.

MarkK, I appreciate your help. I have not learned VBA yet. All the VBA books on Amazon require previous knowledge, even the beginner books (which is where I need to begin). It seems nuts to buy a beginner VBA book that requires VBA knowledge. Do you know of any truly beginner resources? plog...

This works ... Item Expense =(Nz([AcqPricePd],0)*Nz([AcqQuan],0))+Nz([AcqMiscFeePd],0)+Nz([AcqTaxPd],0)+Nz([AcqShipgPd],0)-Nz([AcqDiscAmount],0) This works ... Item Sold...

Re: ComboBox oddity / the value you entered isn't valid for this field However, when I am adding a 2nd combo box made just like the other (Designer) to the same form, I am getting a new error: "the value you entered isn't valid for this field". I am unable to save data to the table via the form...

Awesome! That worked great! Thank you!

I have a combo box that I'd like to get data based on specific contact types for the user to choose from - like designer, so the user does not see irrelevant contact types like maker (unless it's a designer & maker). The good news is, I have made this work in theory, but the bad new is when it...

Hello :) I use access 2010. I am assuming by the error code, one can not use a calculated field to calculate another field. Clarification would help. Thanks n advance.

Never mind - I figured it out!

There is a video on youtube that discusses this. I apologize for not recalling the link. I am no expert, but look into form "popup" and "modal". You may or may not need more code from there. I do not know any code yet. I'm a newbie.