Re: How can I search a form without using FilterbyForm?

On Wed, 30 Mar 2005 17:47:02 -0800, "Merlinar"
<Merlinar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I am trying to port a database from LotusApproach to Access.

As I'm sure you're aware by now, these are VERY different programs
with very different structures and programming styles. Attempting to
use Access as if it were a flawed implementation of Approach will get
you into no end of trouble. Access can do everything that Approach
can... *but it does it differently*.

>One of the
>features of Lotus is that one can click find, is given a blank form (much
>like filter by form) and can fill in any field with any criteria seperated by
>commas (for multiple instances). Access seems to have a lot of problems
>doing this. I am trying to find a way to do this programmatically and haven't
>had much luck. Does anybody know what I'm talking about and have any ideas
>about setting something like that up? Any help would be greatly appriciated.

Is it OBLIGATORY that this be the exact user interface?

If so, then you can do it; you'ld use an unbound Form, and write VBA
code to massage the entered values into the SQL of a query, which you
would then use as the recordsource for a form or report. But this is
not a builtin Access methodology; you'll need to program it yourself!

Just to get started, you might have code like:

Dim strSQL As String
strSQL = "SELECT thisfield, thatfield, theotherfield FROM tablename" _
& " WHERE True"
If Not IsNull(Me!txtLastnameCrit) Then
strSQL = strSQL & " AND LastName IN(" & Me!txtLastnameCrit & ")"
End If
If Not IsNull(Me!txtFirstnameCrit Then
strSQL = strSQL & " AND FirstName IN(" & Me!txtFirstnameCrit & ")"
End If
<and so on>


John W. Vinson[MVP]
.

Relevant Pages

  • Re: publishing on the web with filemaker pro via a local network
    ... i would like publish on the web a filemaker pro database which is on a given computer on my local network ... but neither "no database available" nor the list of available databases, neither with icab nor with safari, when i connect via apache, ... Also in your config section for filemaker on the database concerned you need to turn on sharing and stipulate port 591. ...
    (comp.databases.filemaker)
  • Re: MySQL communication around a firewall
    ... Allowing outside connection to a database server is not ... idea of communicating through another port. ... The normal solution to this problem is to use a servlet acting as a proxy. ... web client talks to the servlet, the servlet in turn talks to the database. ...
    (comp.lang.java.programmer)
  • DB Fault Tolerance - network connections
    ... a Perl server which talks to a PostgreSQL database on a different phys. ... block the port on the DB server, ... Note that I'm using iptables on the box that is running the Postgresql ...
    (perl.dbi.users)
  • Re: cvs commit: ports/multimedia/xine Makefile
    ... It is not a policy document. ... One could say that the VuXML document *is* the collection of issued ... It's a bit harder for users' to ignore it when a port is marked ... What is the meaning of an entry in the VuXML database? ...
    (FreeBSD-Security)
  • Re: Oracle Designer: Connect string
    ... If you config your tnsnames.ora properly, ... Then stick the ABC or the database field as the connect string. ... Frank van Bortel wrote: ... string" for Designer must be composed of host IP, port, and SID. ...
    (comp.databases.oracle.misc)