Re: Find A Date Value In A Subform From Another Subform's Date Field Value

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

A book on which subject?? Access is a humongous topic where
people write books about just parts of it ;-)

There's probably a few years worth of studying in The Access
xx Developer's Handbook by Getz, Litwin and Gunderloy from
SYBEX (where xx is the version of Access). My 2002 edition
is only 3000+ pages in 2 volumes (the desktop volume is
probaly all you'll need for quite a while). This is not a
beginners book, but is generally considered to be one of the
most complete and one that no serious developer of Access
applications should be without.

I also recommend John Viescas' Access 2003 Inside Out, which
includes several complets applications that demonstrate the
topices discussed in the book.

There are several others that are very good, for a couple of
them see Arvin's reply in a thread with this same question
about an hour and a half before you started this thread.

There are also numerous web sites about Access. Be sure to
start with The Access Web at http://www.mvps.org/access/
And before your head explodes with all that information,
check the Resources page that has links to many related
sites.

You should also become familiar with searching the Microsoft
Knowledge Base starting from
http://support.microsoft.com/default.aspx?scid=fh;rid;kbinfo

If you haven't already done so by now, you will want to
create a Favorites folder just for Access stuff.

And don't forget, Google is your friend. It can also search
through 10+ years worth of all the questions and answers in
all the various Access newsgroups. This is a good thing to
do before you post what you think is a new problem in using
Access ;-))
--
Marsh
MVP [MS Access]


Bill (Unique as my name) wrote:
Can you recommend any good books on the subject?
Thanks again, Marshall!

Marshall Barton wrote:
Bill (Unique as my name) wrote:
I have two separate subforms on the same main form. After I
update the date field, "ureturned" in one subform, I want to find
that date in the other subform in the date field, "Hillary".
I've written the code for what I'm going to do after, but I can't
seen to get to that point.


The code is the same as we used in Jakes AfterUpdate event,
except you need to use Parent. in fornt of Arleen and change
Jake to UReturned.

There is definitely a pattern to this kind of thing so you
might want to think about how to generalize it to any
situation. Hint:
http://www.mvps.org/access/forms/frm0031.htm

.

Relevant Pages

  • Re: Find A Date Value In A Subform From Another Subforms Date Field Value
    ... It's a great resource, and its value is due primarily ... You should also become familiar with searching the Microsoft ... that date in the other subform in the date field, ... The code is the same as we used in Jakes AfterUpdate event, ...
    (microsoft.public.access.formscoding)
  • Re: Hey Back People-something new!!!
    ... I haven't had a chance to do any searching or looking., ... It's micro surgery which leaves a scar about a 1.5" long. ... They basically go in the side and remove the bad disk a little bit at a ... Once again it called a D-lift and I only have about 30 seconds worth ...
    (alt.support.chronic-pain)
  • Re: Create a new class on the fly
    ... I accidently left that erroneous snippet in, ... interest by searching for my name e.g. on video.google.com; ... worth my while for me to drop million bucks worth of stock options, ... helping the people who are WORTH helping, ...
    (comp.lang.python)
  • Re: Which Virus Program To Get
    ... The information available through this newsgroup is worth more in a day than ... viruses and other malware. ... I did some searching and found this comment from PC Megazine. ...
    (microsoft.public.security.virus)
  • Re: My son....who is not a collector....
    ... searching them for silver or something to sell on ... I have searched many a roll from the bank, never found anything worth much. ... A little silver but not much and not often. ...
    (rec.collecting.coins)