A
Alec M1BNK
Hi All
I wonder if someone can assist me. I've got an inherited access database
which for the most part uses bound forms (about 40 of them) to an access
back-end. Database is in continuous use by around 10 clients. I am not very
experienced with databases, but with a big pile of books I am learning.
We have a need to make some of the data accessible to customers outside, so
on the advise of various in the know people I have upsized to an Access
Project which will allegedly make things more reliable, and make presenting
data by internet easier, as well as coping with an expected surge in data
volume.
The crux of my problem is that I had used the following on-click event, or a
very similar one, in most of my forms to search the database
DoCmd.ApplyFilter "",
"[t_MainData]![nAmk_ID]=[Forms]![frmPreInsp]![SearchDetails]"
This doesn't work and gives me an error "Run-time error '30100'; Cannot
apply Filter on one or more fields specified in the Filter property."
I have searched these forums, all my books, google, microsoft.com etc
without success.
Can anyone help point me in the right direction?
I wonder if someone can assist me. I've got an inherited access database
which for the most part uses bound forms (about 40 of them) to an access
back-end. Database is in continuous use by around 10 clients. I am not very
experienced with databases, but with a big pile of books I am learning.
We have a need to make some of the data accessible to customers outside, so
on the advise of various in the know people I have upsized to an Access
Project which will allegedly make things more reliable, and make presenting
data by internet easier, as well as coping with an expected surge in data
volume.
The crux of my problem is that I had used the following on-click event, or a
very similar one, in most of my forms to search the database
DoCmd.ApplyFilter "",
"[t_MainData]![nAmk_ID]=[Forms]![frmPreInsp]![SearchDetails]"
This doesn't work and gives me an error "Run-time error '30100'; Cannot
apply Filter on one or more fields specified in the Filter property."
I have searched these forums, all my books, google, microsoft.com etc
without success.
Can anyone help point me in the right direction?