Re: Filtering problem - reposted, still need help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Access MDB will not work for 10 users

instead of spending all your time linking and refresing and writing
connections strings-- stick around with ADP

and use WHERE clauses, not filters

ONLY LOAD THE RECORDS YOU NEED







On Apr 2, 3:43 am, "alecwood via AccessMonster.com" <u32921@uwe>
wrote:
Hi All

I've been asking this on lots of forums but noone answers :(

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, but now my Access frontend (.adp) is broken

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?

--
Message posted viahttp://www.accessmonster.com


.

Relevant Pages

  • Re: Filtering problem - reposted, still need help
    ... Arvin should not be trusted; he believes that the only appropriate use ... Then you add that this is an ADP. ... Database is in continuous use by around 10 clients. ... apply Filter on one or more fields specified in the Filter property." ...
    (microsoft.public.access.forms)
  • Re: SQL Backend, Access Frontend - Filtering problem - plz help
    ... Sylvain Lafontaine, ing. ... Personnally, I don't use filter or server filter, so I cannot help you ... Database is in continuous use by around 10 clients. ... This doesn't work and gives me an error "Run-time error '30100'; ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Filtering problem - reposted, still need help
    ... back-end. ... Then you add that this is an ADP. ... Database is in continuous use by around 10 clients. ... apply Filter on one or more fields specified in the Filter property." ...
    (microsoft.public.access.forms)
  • Re: Filtering problem - reposted, still need help
    ... Make a query that selects the data you want and set it as recordsource on a ... Database is in continuous use by around 10 clients. ... This doesn't work and gives me an error "Run-time error '30100'; ... apply Filter on one or more fields specified in the Filter property." ...
    (microsoft.public.access.forms)
  • Re: Filters in Access Projects
    ... I've got an inherited access database which for the most part uses bound forms to an access back-end. ... 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. ...
    (microsoft.public.access.modulesdaovba)