Search results

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.

New Question Please Re: Counting the number of records on a form How does one get this field to refresh after each new record entered? For example, When I open the form, I have 10 records and the field shows that. But let's say, I add 5 more records and the field is still showing 10 records...

Yes, I see this is much more complicated than anticipated. :banghead: I was able to get to the other database you sent; thank you. :) I opened it, the open file sample form came up. I hit the add button. It opened up the area to browse for images (awesome) Selected my image, hit open. It...

Yes, Thank you, I was playing with it last night. re: "There is a sample database at this site" :) I don't think I have enough posts yet to see the other link, but I am going to look at that today as well. I am going to continue to play with the docman db today while I am more focused and...

I am going to try to upload my DB with screen shots if anybody wants a go at it :) images.zip = the images I made for this DB, it includes directories keepontrying.zip = the actual DB itself Screenshots of DB (some w/ notations) Thank you

Thank you very much