Recent content by Maxihero

Hi guys, I know this is nothing new, but I somehow didn't manage to find it out for the Access 2010. I have splitted my database to the front end and back end and what I'd need to do is to restrict the front end to be read only and only for some users to have the possibility to write and...

OMG, I'm really sorry Dave - I didn't mean to spend your time. I really appreciate this, it's more than a GREAT HELP. It will surely give me much better image of how to do the things concerning the tables and queries. And I'm sure also to anothers who might read this thread. Many thanks again!

Thanks for your advice, Dave. However, I don't fully understand - ok, let's say that I don't store anything in the Funds table. I run the query, which gives me the activity of the funds (this query is based on the Classes table). But I still cannot see the way how I could make (without storing...

Well, at the end it's not so difficult. The one just need to run first the update query to update all active values to "No" and after run the Insane ai's query. It's very cumbersome (as nearly everything in access..), but it works. Thanks again!

Thanks a lot Insane ai! I really like your solution. :) The only problem is, that the query doesn't include the changes from "Yes" to "No" (in case all classes are closed). But I guess here we really cannot avoid counting.

The problem is, that in the form I need to separate the active and inactive funds and it must be automatic (meaning, the actuality of the fund must be chosen automaticaly (not manualy by user)). I want to have two subforms - one Master - "Funds level info" and child - "Classes level info" and I...

Hi Dave, I'm not sure if I understand. The question is how?

Many thanks ai, this is exactly what I've needed. :) However, I'm getting the following error message: . I've copied exactly your query, so I'm not sure what might be wrong: UPDATE [Fund Level Records] INNER JOIN [Stats Open] ON [Fund Level Records].SSB_FUND_CODE = [Stats Open].SSB_FUND_CODE...

Hi ai, Thanks for your answer. I already have a query counting the number of "open" values, but I am not sure how to update the values in my "active" field in the "Funds" table based on these results. Could you be please bit more specific? Like what code exactly I should make and where exactly...

Hi guys, I have two tables "Funds" and "Classes" with one-to-many relationship, resp. (through the "Fund_name" fields). There is the field "Active" in the "Funds" table and the field "Open/Closed" in the "Classes" table. What I would like to do is to put "No" value into the "Active" field...

I must leave it this way (It is an imperativ).

There are two tables - one called "Funds" and one called "Classes" which are related with "one-to-many" relation (for one fund we can have many classes). Both tables are showed in the subform. Now, when I want to add a new record to the subform, having a certain record selected (in this...

Hi guys, I am in the following situation - I have a form which contains a subform with records from two tables (with relation). Now, if there is selected a record in the subform I would like to add a new record as follows - I want to pre-fill the values (depending on the selected record in the...

For the Access, there's need to use "iif", therefore:

Thanks plog. With your help I've finally found what I've been searching for: http://timmurphy.org/2010/10/10/conditional-count-in-sql/