Recent content by atol

cool cool..yep, makes sense....thanks a lot man.. much appreciated....

This is awesome. Thanks Mihail. If i have situation where 1) I select something in Combo1 that is in Form1. 2) The Combo3 (from Form3) should be filtered. Pretty much the cascading going from Form1 to Form 3 directly. Would anything change to the code above? Thanks again!

hey Mihail. You are correct. That is the case I am trying to solve. Will appreciate if you could assist, Rgds Atol

Hi there, I will appreciate if someone help me with the following. I have three nested forms that is Form3 is withing Form2 that is within Form1 (in reality = 1 Form and 2 subforms cascaded). I want to select a value from Combo1, that will further brings the values in Form2, and then further...

Hey guys, Apologies about the misspelled word. I wanted to conceptually understand if this is doable; and it seems it is, based on what you guys have mentioned on this tread. This is a good start for me. Of course I don’t expect to pick up everything you are saying here since it requires some...

Thank you for your advice Paul. Once saved, I guess the challenge I would foresee would be related how to extract the data from the email...I am not sure if Outlook can save in xml, or I can import to Access as xml, and the upload to a table from that potential xml file? Here is an example...

Hey guys, Here is the issue. I am receiving emails (work related) in the same format (where the information is in the body of the Outlook email). Basically the emails contain some financial data that the team needs to manually enter in Access database. The great question is - is there a way to...

Guys, thease are great ideas. Thank you both very much. I will play around home tonight and if i have some clarification, i will post out... Thank you again!! Atol

Hey guys, Here is my dilemma: I need to produce some metrics showing when a record has changed its state. So I have a table, called tblRule. For each Rule, the user would populate a filed “CurrState” from a combo-box on a form. Now, I have to find a way to track somehow when a specific Rule...

Hi David, No they don't. All spreadsheets are with different size, format, etc. My plan was to prepare a separate tepm table for every spreadsheet, then run a query to narmalize (or extract only the needed columns), and then store only that data. Not sure if it make sense.

I am heaving hard time finding some info on the following. I am receiving daily about 10 spreadsheets with different formats (different header names); only 10-20 percent of the content is the same across all the spreadsheets. The output is that i need to convert all of these formats into a...

what you guys are sayig here makes a lot of sense. That's why i have been coming to this forum - to learn from pros and people with experience like you guys. Thanks again.

thanks a lot... good suggestions. i will definitelly explore options.

Does Access 2007 have any Workflow tool capabilities? Hello and Happy New Year! I will greatly appreciate if anyone can let me know if Access2007 has some cababilities of worflow tool? I work on a project, and would like to use at this point Access to aggregate data for some control metrics...

oh i see...yes, that makes a lot of sense... Chris, thanks a lot man!