searchable forms?

F

Frank

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
 
L

Larry Daugherty

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
 
F

Frank

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
 
L

Larry Daugherty

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
 
J

jeth

Frank,

In one of your posts to this forum I saw that you mentioned that yo
use "Club Connect" at work.

I finally managed to find the "Club Systems Group" site when I wa
searching for documentation about this package. However, from what
found, it doesn't look like they provide any downlodable documentation
and their educational packages are all based on existing custome
accounts.

The reason I am looking for documentation is to see if I cn fin
something that will help my daughter who is starting a job at a clu
that uses this software. Unfortunately, there has been almost
complete turnover of accounting staff there, and the place is a bit o
a shambles.

I don't want to muddy the waters or cause any problems by identifyin
the club, but would like to try and get any softcopy documentation tha
is available to see if it will help her get started.

I did use the contact form at CSG, but didn't get any response yet.
think they might not reply anyway because it appears that individua
support might account for a good portion of their income. That, an
they are now a part of a group in Ontario even though the CSG portio
is still working out of PA.

If you know where I might get soft copy documentation, I'd appreciat
it.

Thanks,
Jo


-
jet
 
Top