Re: parameter

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)
  • 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: 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)
  • Re: Syslog server
    ... oops ok nevermind. ... I guess that didn't fix anything then. ... Subject: Syslog server ...
    (Ubuntu)
  • Re: How walk recset in DAO, do AddNew & return to CurRec B4 AddNew?
    ... Oops. ... well as appending a record to the underlying table. ... I was walking the recordset looking for records whose ... This not only added a record to the underlying table, ...
    (comp.databases.ms-access)