Search results

: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...

How do you do... My name is Vinnie. I hail from Ventura Ca and am a business financial analyst working in agriculture in Oxnard, CA. Last year on a acreage basis we were the Strawberry and Celery farming capital of the world, the company I work for farms these commodities in addition to many...

Got it! These methodologies are important for me to follow and I want it to be subconscious as I set up for new projects in the future. Thank you for the example – your form and example is identical to what I created, I just have more linking fields. The main purpose for this is to associate...

good morning, I completley understand BUT maybe im missing something; the tblApplication is the main table that the end user will be populating; an event occurs and they make an entry. That event will always take place on a ranch; via planning and modeling (main pilliar of my job function) I...

LakeRanch and LakeLot is info I need present in tblApplication for each entry, I will define the options whoch will reside in the tklpRanch; I think you mean for me NOT to name these fields in the tblApp the same field titles in the tblRanch, yes? Unit cost, yes, I will be able to get this...

Thank you kindly jz, this helps and more importantly Im better understanding the overall logic/architecture of the db. I attached new relationships reflectign my changes. Is this better? Im going to work on the query tonight. Thanks again