Recent content by vega

:banghead: Im completley lost here and have been problem solving this since the last post. Im not sure what the gotFocus event is or how I would use it. I have no idea what types of events I need in the first combo box (parent), or how I am supposed to durect them. I see examples of...

Greetings all, So the common, limit the contents of combo boxes based off selection in other combo box dilemma. I know about the baldy web resource (Forms: Limit content of combo/list boxes) and have been trying to implement the (second) solution for what seems like weeks now but im not...

Hey Paul, Thanks for the reply. Ive actually referenced your website before. It somewhat helps, I get the general idea. But the content of your cboCities is in the same table as your cboState. I want my drop down selection to point to a Query. Also, what does vbNullString mean, I have not...

Not sure if thats a good title. What I am looking to learn how to do is a selection of a drop-down menu that will populate several other fields whenever a selection is made. Or how to auto-populate text field(s) based on a dropdown list or combo box selection. Before I come here for help I...

jdraw, thank you much for this resource, reading now and hope to pick up more best practices.

Hello, I think I have a similar problem and I think post # 2 above relates to the solution. I have 2 queries, one calculating picking cost per (strawberry) crate per day, 2nd query calculating hourly cost per crate per day. Essentially there are 2 dimensions that I am measuring, picking and...

Thank you for your response. end users is management and production supervisor; used to monitor estimated cost per crate harvested and variety type and location harvested. other user - personnel whom fill out form in the field data is collected on paper form (attached), I then transpose it...

I need to create an access app and am having a hard time getting through the planning stage. Im an analyst in Ag. I have a field reports that captures 2-3 dimensions of data types; picking labor cost, hourly picking cost and variety harvested. The form is laid out by days of week. Formerly...

Hello jz, Stuck where I left off. Im lost as to how I'd create such a query. Ive still not created any queries and cant "see" how Id' be able able to tally application of one material aginst that materials inventory Q or exactly how im of managing inventory. You mentioned not to have...

jz, I just wanted to thank you for the help and contribution in this task and project, it made a big difference and provided some momentum. Can I feel free to post any potential followup issues? Thanks again

Good Moorning, Alright, that’s what I thought and wanted to confirm. I had an idea this morning; for food safety reasons I need to match application with the origin of the order best I can so... in the frmApplication what if I include a sub form featuring tblOrders so that the user can...

that's a valuable example, im not sure how I would have figured that one on my own. Regarding the combo box linked to tlkpMaterialList, I understand but here's the thing regarding unit cost; although I have a field I have no cost data yet; technically I wont have cost info until there's an...

Ok, Im following. How do you display a form in datasheet view in 2010?

essentially, so that I can assess whats been applied of a certain material versus how much is on hand AND to match materials with their purchase cost (material X may have a different unit cost in 3 weeks) I would derive this via a select query

While I ponder queries... I am making/modifying forms. You made a helpful recommendation; create tblOrderDetails to itemize all materials in a given order. So I am trying to put a form together from tblOrders so that the user can enter order data; how can I have them use the same form to enter...