Re: parameter

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

From: Chris2 (rainofsteel.NOTVALID_at_GETRIDOF.luminousrain.com)
Date: 01/29/05


Date: Sat, 29 Jan 2005 10:41:42 -0800


"Chris2" <rainofsteel.NOTVALID@GETRIDOF.luminousrain.com> wrote in
message news:kpSdnZVGYOzSH2bcRVn-oA@comcast.com...
>
> "al9315" <al9315@discussions.microsoft.com> wrote in message
> news:8398F03F-B83F-4F73-A36B-E86AAEE53B0A@microsoft.com...
> > Typed question earlier - cannot find it on here ???????
> > Query - Record Collection - e.g. "We wish you a Merry Xmas" -
> Parameter
> > Query - type in e.g. Merry Xmas - search ALL track fields (in my
> case - 24

  24 fields? Oops. Nevermind.

  Write a VBA function that accepts a paramets of "AlbumID", opens a
recordset, looks up the row based on the Album ID, checks each of the
24 columns, and returns whatever you need it to when it finds what
it's looking for.

Sincerely,

Chris O.



Relevant Pages

  • Re: Using LIKE in SQL (Repost, still need help)
    ... nevermind. ... >oops, ... But when I run the query in the SQL ... >Any idea why my recordset is blank? ...
    (microsoft.public.access.modulesdaovba)
  • Dave Grohl, Krist Novoselic talk Nirvanas Nevermind 20th anniversary
    ... The album, which included cultural anthems like "Smells ... alt-rock movement of the 1990s and transformed drummer Dave Grohl, ... To commemorate the 20th anniversary of "Nevermind," which has sold ... "Nevermind" mixes that Vig hoarded until the group began planning for ...
    (rec.sport.pro-wrestling)
  • Re: Best sophomore albums?
    ... Nirvana - Nevermind ... Sisters Of Mercy - Floodland ... I like this album, but see it as a HUGE step down from Heartbreaker ...
    (rec.music.artists.springsteen)
  • Re: calligraphies
    ... Oops, I though I could share an unlisted album... ... o proprietário para obter acesso.” ... I presume the above is an “access denied” message. ...
    (sci.lang.japan)
  • Re: Program to scan for changes in directory?
    ... OOPS. ... Nevermind, I figured out where to change that option. ... to figure out how to get the file name/file path of the changed item...... ... but a Google search may turn up something. ...
    (microsoft.public.vb.general.discussion)