query by form - database in network

[WimDC]

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 the same network and using the same accdb-file.

To find a solution, I build a very simple (new) database (ATTACHED) with only one table, one query and one QBF. When I click on the "query by form", I get the data, depending on the choosen option "type". But others get the parameter prompt.

It seems that for my colleagues, the query doesn't find the form or the form-field. And as not everyone has that problem, maybe the network can be the problem? Or a specific setting in Access ? Or ....??...

I know it may be difficult to reproduce, but maybe someone had the same problem and... has a solution.

Is there another way to pass parameters to a query?

I hope someone can help me!

Thanks.

Wim

 

[pr2-eugin]

Hello Wim,

.... because we are all on the same network and using the same accdb-file.

This does not sound right. Normally people Split the Database into a Front end that will have all your Forms, Queries, Macros. The Back end File will normally have all your tables preferably in a Network location (or a shared drive) where all users will have access to. Once it is done a copy of the front end will be distributed to all other users to work from their local desktops. This is how concurrent user accessing the system is achieved in MS Access. So you might want to re structure.

Next coming to your problem, the parameter pop up for a Query can be because of few reasons one it cannot find the Form/Control. Or the Form/Control is misspelled. In your case I think it is because of misspelling. In the Query criteria you have [Formulieren]![frm_selektie]![type_keuze] replace the Formulieren, with the English word 'Forms'. As, [Forms]![frm_selektie]![type_keuze] that should sort it..

 

[WimDC]

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 seems to work for all of my colleagues that have the language set to "Dutch".
The colleagues that have the language set to "English" get (got ) the prompts. So I changed "Formulieren" to "Forms" as you suggested.
And this works for me (English word "Forms" in the Dutch Access-version) ??? Maybe a bug in Access ??

After all, it works. You made my day!

Wim

 

[pr2-eugin]

Glad to help Wim.

It is not an Access bug, might be because your settings call for that. If you change your default language to English it will not be a problem anymore.

Just in case if you are giving a version of your file for someone to look into they might not understand Dutch, setting it to English will help in that case and many errors that may come in future..