Search results

I resolved many of the issues I had been attempting to resolve with the attached version. Now I am having trouble with the code to get the form to go to the record selected by the Combo boxes. If you use the form you will see all fields start blank, the combo's display proper applicable values...

Rain, Unfortunately this doesn't help. I have found plenty of examples of Cascading Combo Box, but can't get any of them to work for this application. (I even mentioned that I was working with them in my initial post). I am really weak on the Form side of things and just not managing to...

My bad - accidentally reconverted to 2010. Here it is...

Rain, My apologies for the delay; let me see if I can better explain: Other fields included in the original table are all related to Inventory quantity and value totals i.e. Beginning Qty, Beginning Value, Planted Qty, Planted Value, etc. (I have re-attached an updated .mdb with those fields...

Rain, I removed the other fields/columns which relate to inventory values of the date ranges and associated Production Divisions of the table. The form is intended to allow the user to report off an existing date, evaluate an existing date, or enter a new date range-Production Division...

Rain, I guess I was hoping to accomplish this with list boxes instead of a combo box. I used this post from John Booty http://www.access-programmers.co.uk/forums/showthread.php?t=188663 to create a search combo, and realized his (or someone's point I read) point regarding this not allowing...

So many questions relating to this here and elsewhere, but I just can't equate any of the solutions to my challenge. I am trying to create the form so when the first field (Start Date) has a date selected, it limits the following field (Report Date) to the matching available data, and same...

Thanks Pat! I think your post helped clarify some of what Craig wrote that I was having difficulty digesting. This level of complexity in a database is beyond what I am used to doing (I am a financial guy not a programmer) but I am slowly grasping it. I have utilized Craig's method but...

So disappointing :banghead:(reminds me why I began avoiding all of Microsoft's specialty products) but SQL Server Express will not work for this situation. The data I need to access is in DB2 format which requires a separate download to SQL Server and the download will only work with the...

Thanks ButtonMoon, Lightwave, and Craig. I am spending today getting SQL Server Express installed and will do my best to assimilate all of this through some good old fashion trial and error throughout next week, but will likely end up reposting for some help. Peace

Thanks Bill & Cronk. I had started with Bill's method but realized it was not allowing me to impact the criteria data in two separate fields of the query. I tried Cronk's recommendation but could not get the code to function; likely my lack of VB knowledge. It did however lead me to searching...

Craig, I guess I need to clarify. The source data is NOT stored in Excel. I currently import it into Excel then import into Access because the source data program does not archive historical data (or even in some cases where it does archive, it does not do so logically to where I may need...

The query is not the record source, a table which contains start and report date are the record source. The query is used to select the data to be run through analysis (with the use of many subsequent queries). Basically the table contains the evaluation period (start and report date), the...

Have a huge DB that I did too much work to before making sure I was creating it properly. Was back tracking and trying to normalize and set up relationships and referential integrity but ran into the following issue: The database uses tables which are periodically updated through imports from...

I am attempting to create a toggle on a form that would instruct a query which criteria to use. Specifically they are date criteria. I want to be able to toggle between evaluating on a start basis verse a ship basis. If the toggle is set to 'Start Date', the query would use the start date as...

Thank you Paul!!!!! Wow - took me a minute to translate the SQL into the UNION query but after that worked like a charm. Many, many, thanks! Asoul

pbaldy & plog, I get that... But my data from the source system already outputs the data in the one row across multiple columns along with about 20 other columns ofcomponent data of the over 27,000 UniqKey's. Assuming a table with over 175K rows would not slow the database, is there a way to...

I am trying to perform, in Access, the equivalent of a HLookup combined with a Match function in Excel. Converting and automating a process I originated in Excel into Access, but its been several years since I used Access regularly. Here's the data and what I am trying to do.... Table...

Hi all, I used to do Access programming back in the mid 90's and after enjoying the outside world for many years I am now back in an office hacking away. Working on several large projects to improve data flow at a large Greenhouse operation and am running into several walls - look forward to...