Recent content by WimDC

Thanks everyone for all the help and I will try the suggestion of theDBguy

Hi, I searched multiple forums, but couldn't find an answer. Maybe there's no solution for my question... Is it possible to open a certain form with a certain record-id from a URL? Database is shared and split (frontend/backend) Suppose I have a database DBTEST.accdb and form DBFORM where I...

Hello, In a new project, I want to keep "statistics" of what records were "clicked". (See attached database in Access2010) Now I have a very simple form with the different records. Those records can be modified/added by the user. Is it possible to write VBA so when a user clicks on a...

Problem solved, thanks to the PeterF who's query pointed me in the right direction.

Hi PiterF, thanks for your reply; I had a look, and you use the table twice. That's new to me, but seems very interesting... Your query is not 100% what I have in mind, but it's really close ;). I think I can use your query to get my output. If not, I'll be back in this forum :(. Wim

Hi, I have a table (or query) with the following fields USER_ID CODE (can be "A" or "B") DATUM (dutch for "date") REF_DATE REF_EXPLICATION Each record HAS data for the first 3 fields; the other fields CAN have data. (of course, each user and each code is linked to a separate...

Yes, that did it. THANKS !!

Hi pr2-eugin, Thanks for your reply. I know I have to normalize the database / design; that's why I called it a "really dummy database". My only intention was to show how I have to find the "last totals". I want to try your suggestion (= after normalizing), but for the moment, I don't see...

Hello, I'm trying to build (a rather simple) totals-query, but the "last" function doesn't give me the right values. Suppose I have a database where the amount of products that were sold are stored per month. It's possible that some products are not sold in some months. (see the really...

Hi oxicottin, I found your Employee Monthly Attendance Year View database and would like to use the principles for my HRM-database. Is this database build with the built-in-Access components (like unbound textboxes for the dates?) or is almost everything programmed in VBA? Can you provide me...

Thanks for your suggestion and I changed some forms / relations. (see new attachment) But not want I want. As you can see (frm_transactions2), the 3 possible products are in the left column. I did this manually, just to show how I want it. I mean: in the left column AND FOR EACH RECORD, I...

Hello, is it possible to create a 2-column subform, where the first column shows ALL the records of a table or query and in the second column the user can choose (dropdown) values from another table. I also get an error in my summary-query. SITUATION (see attached dummy-database): - each...

Hi Paul, you're a hero (;)), because your solution seems to work (at least 2 colleagues could use the QBF without the prompts). BUT... it is very strange because in the Dutch Access-version I use, I can only choose "Formulieren" (= Dutch for "forms") in the query-design-window. And that...

Hi, I'm developping a large database where the data can be "filtered" through some query-by-forms. For me, everything works perfect. BUT... some of my colleagues (notice: "SOME"...) get the parameter-prompts when executing the macro. I spend hours to find the cause, because we are all on...

Hi Brian, thanks for your suggestion. It seems to work for all values, even "null"! So, that's what I wanted and where I'm happy for :) But can you just explain how to understand that query? (I want to learn...) The first part (= Forms!critform!critfield) is easy (if the value in my...