Re: searchable forms?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Larry Daugherty (Larry.NoSpam.Daugherty_at_verizon.net)
Date: 07/25/04 

Date: Sat, 24 Jul 2004 21:35:36 -0700

Hi Frank,

You may have read only access to the foreign tables - you didn't mention
where they are in PC or network terms nor what kind of tables they are. All
useful information.

It would seem that your goal is, initially at least, to learn about forms.
I recommend that you make a copy of your current query into a Make Table
query and copy the whole table into your application. Then try your form on
that. If your initial form doesn't work then do as I suggested before.

Post back if you have troubles. But if you do, please include lots of
specific information..

HTH 

-- 
-Larry-
--
"Frank" <stratster68@IHATESPAMworldnet.att.net> wrote in message
news:Owyi4SecEHA.1652@TK2MSFTNGP09.phx.gbl...
> Hi Larry,
> I think I left out an important fact. The table is in an accounting
program
> called Club Connect that we use at the Club I work at. While I can run
> queries, export info to excel, etc to for mailing list, labels, and
reports,
> I cannot search. Of course, If I use the forms built into the accounting
> program I can search, etc. Could this be the reason?
> Thanks,
> Frank
> "Larry Daugherty" <Larry.NoSpam.Daugherty@verizon.net> wrote in message
> news:OiSrPVacEHA.4092@TK2MSFTNGP10.phx.gbl...
> > Hi Frank,
> >
> > Without playing 20 Questions, try the following:
> >
> > In the Query window select the query in question.  Click the Autoform
icon
> > and let Access design a form for you.  Once the design is complete open
> the
> > new form.  If you are able to enter data and edit old data then check
out
> > the differences in the properties between the form you designed and the
> one
> > the wizard designed.  If  you cant make changes and additions then the
> > problem is in the query.
> >
> > HTH
> > -- 
> > -Larry-
> > --
> >
> > "Frank" <stratster68@IHATESPAMworldnet.att.net> wrote in message
> > news:OBeezwEcEHA.2504@TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > > Have Access 97 at work and access2000 at home. At work , I have gotten
a
> > > descent workable knowledge of queries and reports. Today I started on
> > forms.
> > > I created a form based on a query of one large table. I cannot search
,
> > > edit, etc in the form, I can only scroll and view. What basic step(s)
am
> I
> > > missing? A website with this info would be fine.
> > >  Thanks
> > > Frank L
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: searchable forms?
    ... In the Query window select the query in question. ... and let Access design a form for you. ... If you are able to enter data and edit old data then check out ... "Frank" wrote in message ...
    (microsoft.public.access.gettingstarted)
  • Re: Form view vs Design View
    ... > open it in datasheet view and see whether you can edit data in the query. ... > It's possible that the design of your query has caused it to be read-only. ... > Summary queries, crosstab queries, union queries ...
    (microsoft.public.access.forms)
  • Re: Multiple Records
    ... Try opening the query in design view; view its Properties; and set the ... Or, equivalently, edit the SQL so the ...
    (microsoft.public.access.queries)
  • Re: why cant i edit my form?
    ... form design abit. ... state table is just for a lookup and i do have a combobox ... on my form for it (if the user wants to edit it).. ... >for Users and a subform for the rest of the query. ...
    (microsoft.public.access.forms)
  • RE: Multiply qty of filtered records
    ... If you should want to try doing this with a query (which is probably the more ... etc in the bottom part of the design view. ... I do know how to get this information in a Report, ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)