Re: Filtering problem - reposted, still need help

"Disconnected databases" LOL, sorry I meant recordsets.......



alecwood wrote:
Sorry, I guess I wasn't clear enough

It was Access front end and back end, split database, two .mdb files. In all
cases the forms were bound to tables or queries as very basic access
databases written by noobs tend to be LOL.

Following advice I upscaled, so now I have an ADP front end and the upscaled
tables on an instance of SQL server.

I used the upsizing wizard to do the job, corrected the problems it found and
now I can see and add records, but my previously working search functions
just don't.

I'm just trying to find an alternative to shore it up in the interim. I
appreciate what I want is unbound forms, disconnected databases and good VBA
code running behind them, but I don't want to sit up until midnight every
night with a laptop to get it done, which is what it would take at my level
of knowledge.

If I can shore it up with a temp solution then I can recode properly at
leisure, and hopefully do a better job.

Alec

First, you say that you are running an Access front-end to an Access
back-end. Then you add that this is an ADP. ADP back-ends are SQL-Server,
[quoted text clipped - 6 lines]

Can anyone help point me in the right direction?

--
Message posted via http://www.accessmonster.com

.

Loading