Re: close table restore form

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

Jeff,

Fair enough! In this case however, a lot of back and forth could have been
avoided if I heard that 1. do not allow the user to see table use forms
(which is what you did offer) and 2. one cannot close a table and open a form
(which is what I was trying to do incorrectly because of my inaccurate
understanding of Access).

I value very much the advice that I receive in these groups and use them to
better my product and my understanding of Access. In fact, I get more from
these groups than I do using the Help or Access 2007 Inside Out (I hope I
did not offend anyone but it is true).

Anyway, NHNF (no harm no foul) and thanks for your advice!
--
javablood


"Jeff Boyce" wrote:

I can only speak for myself and my approach...

Often I will deliberately NOT answer the question as asked, as it seems to
reflect a mind already made up, or inaccurate understanding of Access or
lack of clarity (i.e., I don't understand), or ...

I'll ask for information if I don't understand.

I'll offer ideas about effective use of the tools Access offers.

I'll point out potential issues with approaches.

I'll point out potential issues with learning to use Access & creating
applications.

(and if none of those seem applicable, I'll offer a solution).

JOPO (just one person's opinion)

Regards

Jeff Boyce
Microsoft Office/Access MVP


"javablood" <javablood@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0B188234-5FBD-4DA7-A31E-28A32FC0A263@xxxxxxxxxxxxxxxx
Stuart,

That is exactly what I did as indicated in my last post. I was trying
lighthearted sarcasm and added the smile, which was evidently lost.
However,
it would be helpful in the future if the question is answered in the first
place as you did in your post when you stated "This is something you can't
do
with tables, anyway. " I am learning from you all but sometimes I find
that
direct answers are not always forthcoming. I agree that using the form to
display the data is the better way to go for so many reasons and I thank
you
all for pointing that out to me. I am not a 'professional' Access
developer
but with the likes of you all I am least learning. NHNF!
--
javablood


"Stuart McCall" wrote:

"javablood" <javablood@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F25650E-B82F-4074-B0C4-F66C0DAF8511@xxxxxxxxxxxxxxxx
Jeff,

Thank you. So if I open the data in form to preview will you then tell
me
if there is a way to close a table and then shift focus back to the
form?
:-)
--
javablood
<snip>

Jeff's giving you some great advice but you don't seem to be listening. A
professionally created Access application will *never* show a Table to
the
user. Tables are for designing and storing data, period.

Try this:

Select the table in question in the database window (or better still,
create
a Query which draws data from the table). From the Insert menu, select
'AutoForm'. When Access is done creating the form for you, open the form
to
make sure you can see the correct data (well one record of it). Now go to
the 'View' menu and select 'Datasheet". Notice that this looks like a
table
but is really a form. Now that you've got a form you can address your
problem by putting this code:

DoCmd.Restore

in the form's Close event.

This is something you can't do with tables, anyway. Tables and Queries
cannot contain code, but forms and reports can.






.

Relevant Pages

  • Re: Why dont we have a stong AI by now? (To Curt Welch and other)
    ... used (e.g., learning, natural language understanding, etc.) are at too ... Chess playing once was seen as intelligent, in the meantime it is not ... limited domain task that only a human could perform, without any real care ...
    (comp.ai.philosophy)
  • Re: Robotics, AI, and Ethics
    ... weights in the network. ... your agent which shows it's a REALLY BAD learning system. ... I'm glad you think that's how the brain works. ... It's like trying to design an airplane without first understanding the ...
    (comp.ai.philosophy)
  • Re: Standing-Wave Current vs Traveling-Wave Current
    ... Keith Dysart wrote: ... The comments mostly apply to a single poster who has ... In most learning environments, the information is ... understanding than one who has just been ...
    (rec.radio.amateur.antenna)
  • Re: Mathematical concepts
    ... better with the cumulative nature of learning mathematics. ... since conceptual understanding needs some time to ripen. ... written exams are quite ...
    (sci.math)
  • Re: OT:voice software
    ...  I seem to have developed RSI in my left hand (strange as I ... software to my voice. ... intuitive and was not especially ordered about learning the different ... So, before you invest, you may need advice on this ...
    (uk.media.radio.archers)