Search results

Thank you!! It works perfectly ;)

Dear All, I have a combo box in a form, would it be possible (and if yes how) that after selecting an item from the list, that item will be used as a parameter in a query? Many thanks in advance ;)

I solved it in the meantime: I put Null to the Default value and now it shows nothing by default In case of the Option group I put Yes to the Default value and now it is neither greyed out nor showing "Yes", it is just "white" by default

I just have one more question: If I insert a combo box or an option group, whenever I open the form the combo box lists the first value by default (however I did not set that) and the option group is greyed out until I click in it How can I make the combo box show null value by default? (I tried...

Thank you for the reply, it works pretty nicely!

Dear All, I would like to know how it can be done that if there is a "Yes/No" dropdown or an option box and if eg. "Yes" is selected then a number of other fields appear on the form to be filled in Many thanks in advance! ;)

I think now this is the only one, I cant see the other

Dear All, I have a few Access databases where I have certain queries the results of which are displayed in Excel, so I created Pivot tables in Excel with reference to an external data source: my Access database My problem is that it works fine except when there is an NZ function used in the...

Thank you sooo much!!!!! Now I see the logic behind

I see But Query3 shows Adam only without Andrew The aim would be to only see each payer once where the number of assignments (so the CountOfName) is max

I apologize Please find a 2000 version attached below Many thanks!

Query1 shows how many times a Payer is assigned to each individual I would like to create a query that only shows those records where the count is max (so in this example I would like to only see Adam and Andrew and exclude Kathy as she is assigned fewer times to the same Payer as Adam) Query2...

I tried that already but it does not work I created an aggregate query and put the CountOfPayer to Max but nothing happens I got the same results as with Group by

Dear All, I have a query that results in 3 fields: Name, Payer Nr, CountOfName so it shows how many Payer Nrs are assigned to each Name It happens that two or more names are assigned to a Payer In that case I would like to see only the one that has the maximum CountOfName I tried with max...

Can you please tell me how I can use that to display the sum of selected cells on the screen? Many thanks

Dear All, I would have a "strange" question: Is it somehow possible in Access to display the sum, avg...etc of certain selected "cells"? Just like in Excel if you select certain cells it gives you the sum, avg etc down in the Status bar - so is it possible to add a Status bar, or similar...

Hello, What is the benefit of using one frontend per user? I have already tried it and as the tables are linked to the backend, if a user opens the frontend, the backend gets locked as well, I cant do any macro or table design modifications etc.. so the situation is the same as using one...

Everyone uses the same frontend, I deleted the input mask and now it works fine, everybody enters the date in his/her default Windows format! Thx!

Dear All, We are using a database in a multiuser environment where the Regional Settings in Windows is set up differently for different users (and cannot be changed) How is it possible to set a Date field that ONLY mm/dd/yyyy date format is accepted when entering data manually? Your help...

Hello, It is not checked and still I get the message