Recent content by miked18

Thanks for everyone's input. It has been a long time since I've used access so I am having to relearn it as I go. @Pat Hartman The continuous form was what I needed, thank you.

Ok, so multiple subforms. probably nicer that doing a bunch of tabs... still, my question is how to have the query add only the rows it pulls and make them editable without coding a bunch of text boxes? would it need to be more of a table view than a form or report type format?

Ah see, maybe I made it sound so easy. In my mind, it doesn't seem so simple. #1 there would be multiple queries, so I don't think I could set the form record source to a query. 1 query would be to show what needs to be Sown, 1 to show what needs to be harvested, etc... #2 I don't want to edit...

Hello again, hopefully this will make sense. first some background. I grow microgreens. What I am looking to do now is have a form that has different tabs that will be populated with data by queries. These tabs are for "tasks" that need to be completed on "this day". The tasks are "Soak" (...

I get that it may be bad design, but I am not sure how else to do it to accomplish what I am after. I appreciate all of the responses. @CJ_London, thanks. I see my error now and forgot that "" is a string. Setting the numeric fields to "0" fixed that. Thanks.

I have a form where i enter products, quantity, price. you can enter up to 8 products (it's ok) I have a button to update the quantities and calculate the the total price.(cmdUPDATETOTALS) simple code. TotalQuantity = quantity1+quantity2, etc. TotalPrice = price1*quantity1+price2*quantity2...

Anyone for hire on this site :LOL: My head is spinning. I appreciate all of the feedback from everyone, thank you. So right now I have a google doc doing this. it is getting messy and is so slow to do calculations.... In the doc, I can select say 2week sub for Customer A for an order on Week...

I grow microgreens, so I have to put in these orders ahead of time so I can plan for my planting periods and quantities. but i get you point about not having to update the records if they get changed. thanks

Hello again, Looking for some help on another part of my db. in another post I mentioned adding orders into my db for new customers. Some of these will be reoccurring subscription orders. I need to be able to pull up a customer and see their future orders. (i would also like to be able to...

Hello, I am struggling to find a way to do reoccurring orders. Hoping for some help.. It has been over 10 years since I've messed with ms access, so I remember a bit, but still getting back into the swing of things. I am trying to make a database for ordering products. When a new customer...