Recent content by rkaupp

Hi, very sorry for the late reply. It works despite adding some complexity. Thank you!

Thank you. I have given it a go, but unfortunately, it either gives me an "Error 3061: Too Few Parameters. Expected 2" or Access crashes entirely; I have tried to understand why this happens, and apparently (according to other forum posts) this is because I use temporary variables (syntax...

Hi all, I have a bit of an issue for which I suspect there could be an easy solution, but so far it defies my logic. I work in a charity, and I have a table to record donations from funders to projects, with the following fields: TransactionID (autonumber - primary key) Project Funder...

Thank you for this example! I will see whether that can be the way forward. I admit that re-calcuating all cumulative balances every time is a bit cumbersome, but then I only need to it quarterly so maybe it is fine. Thanks, Rémi

Hi all, I am trying to get a specific output and I don't know whether I should do it in a query or in a report, hence I post in General. My problem is the following: In my database, some tables store financial data in the following way: "Project", "Transaction Date", "Amount" (with a few other...

Oh well, I think I'll find something using the links on http://en.wikipedia.org/wiki/SQL_Programming_Tool. Thanks.

Yes I regularly use the query builder, but then I have a number of UNION queries which are either impossible or hard to edit in the query builder (this is due to the design of the database, something I don't have control on unfortunately). If there is a syntax error, actually Access tells me...

Hello, I'm not sure this is the right forum but I didn't find my answer through other searches. I find the built-in SQL editor for queries in Access 2003 pretty limited, and I was wondering whether there is somewhere an external SQL editor (maybe available through an add-in to Access), which...

Thanks, I've now understood and it works. Just some issues left with the filter not being applied when I change a person (as the filters are only applied when clicking on the checkbox and not in the combo AfterUpdate sub), but I think I can sort this out myself. Thanks a lot for you help, Rémi

OK, but how do I "manipulate" these? I am using Access 2003, where the only option I have in the suform proporty window: I can select a field fir "link child field" and another for "link master field", but I cannot "manipulate" these such as adding an IF condition. If I use this, then when I...

Sorry, I wasn't clear: the combox box in the main form allows you to select a staff member. The list includes: ALL Bob Sarah etc. When I select "ALL", i would everybody's tasks to be visible in the subform; but when I select any other item from the list (i.e., a staff member), I would this...

Hi all, First of all, I am not a very skilled Access programmer, and I mostly re-use bits of code I find on help sites. My problem is the following: I have a main form with a combo box which allows me to select a staff member, and a subform which then shows tasks for this member. I use the...