Search results

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...

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...

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...

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, 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, One of the fields in my table is numeric and can have no value or a numeric value. I also have a form where users can enter the criterium OR can leave that criterium-field empty. (query by form) In case they enter a numeric value, my query retrieves all the matching records. So far so...