Search results

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!

Chris, This is really good approach. Thank you very much. Just a quick clarifying question - since the group by quiery is a dynamic one (meaning it is pulling data from a table that constantly gets updates), should I use an update query to update the holding table?

Folks, Here is the issue I have been struggling with. I have a table, which contains orders by individuals. Then I need to group those orders by certain criteria (let’s say by product type); I used a select query and grouped them by. However from that query, after i grouped them by, I want to be...

DCrake, thanks a lot for the advices. I do have a copy of my 2003 version and all tables are linked correctly. I will spend my day tomorrow to get this thru and hope i have some luck to get it done. Much appreciated! Atol

DCrake, I missed to answer the second question you asked. I actually do not have the database split. If you have any recomendation how to start that would be great. Doe example, if I try to open the database in 2003 version, would it restore the relationships? Thanks again!

DCrake, thanks! That might be the key. However, the database is already in use in 2007, and data is olready updated. I guess i have to get some readings on how to move it back to 2003 and then convert to 2007? I guess my problem is that i am not sure how to do it. But dont want to waste your...