Att: PC Datasheet - Please readf inside

[George Kandaz]

Steve, I posted a question to your last post almost a week ago, but
never heard from you again. Please read my last message, as follows.

Thanks.

---------------------------------------------------------------------------

Steve:

I have followed your instructions to a "T". However, I continue to
receive the following:

Run-Time error "2580": The record source "AllRecords" specified on
this form or report does not exist.

Where "AllRecords" is the name of one of several queries I created.
The query 'AllRecords" not only exists, but its name is also in the
QueryName field of one of several records on the TblQueries table,
yet, the code in the combobox claims not to be able to find it!!

Could perhaps there be another property of the MyRecordSource combobox
I need to set in a certain way, but that is not mention in your
messages?

Again, thanks for your help.

George

On Wed, 06 Apr 2005 22:34:50 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

Hi George,

You are very close!

<< does the table have just two fields (SortOrder and Queryname)? >>
Yes

<<The Record Source "2" specified on this form or report does not exist.>>

Did you see my correction? The code should be:
Me.Recordsource = "'" & Me!MyRecordsource.Column(1) & "'"
Instead of:
Me.Recordsource = "'" & Me!MyRecordsource & "'"

Steve
PC Datasheet
"George Kandaz" <Ge**********@nospam.net> wrote in message
news:hl********************************@4ax.com.. .

Steve:

Thanks for your help. This is a very elegant and compact solution that
would allow me to have a very large number of sorting/filtering
criteria available a click away. I am having a bit of trouble making
it work, though. My question is:

The table I need to create, (named TblQueries), does it have three
fields? By looking at your original message, I do not know if
"TblQueries" is both the name of the table as well as the name of the
first of three fields (the other two being SortOrder and Queryname),
or else, does the table have just two fields (SortOrder and
Queryname)?

At any rate, I tried it both ways and get similar errors when I make a
choice from my combo box. Something along the following lines:

"The Record Source "2" specified on this form or report does not
exist.

Thanks for all your help.

George

On Wed, 06 Apr 2005 19:23:21 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

>Just noticed ---
>
>This line:
>Me.Recordsource = "'" & Me!MyRecordsource & "'"
>Should be:
>Me.Recordsource = "'" & Me!MyRecordsource.Column(1) & "'"
>
>Steve
>PC Datasheet
>
>"PC Datasheet" <no****@nospam.spam> wrote in message
>news:1x****************@newsread3.news.atl.earthl ink.net...
>> 1. Create all the queries you want. Create a table named TblQueriesthat >> looks like:
>> TblQueries
>> SortOrder (Integer)
>> QueryName
>> 2. Put the name of all your queries in this table with the sortorderyou >> want.
>> 3. Create a query named QryChooseQueryName based on TblQueries and set
>the
>> sort on sortorder ascending.
>> 4. Add an unbound combobox named MyRecordSource to your form. Set its
>> following properties:
>> a) Rowsource QryChooseQueryName
>> b) Bound Column 1
>> c) ColumnCount 2
>> d) Column Widths 0;1.5
>> 5. Put the following code in the combobox's AfterUpdate event:
>> Me.Recordsource = "'" & Me!MyRecordsource & "'"
>> Me.Requery
>>
>> Note: That's a single quote enclosed in double quotes at both places
>above.
>>
>> --
>> PC Datasheet
>> Your Resource For Help With Access, Excel And Word Applications
>> re******@pcdatasheet.com
>> www.pcdatasheet.com
>>
>>
>> "George Kandaz" <Ge**********@nospam.net> wrote in message
>> news:7v********************************@4ax.com...
>> > Have a run-of-the-mill form, displays one record at a time from aflat >> > table (no relations). Would like to create a few command buttons at
>> > the bottom of the form, and, when click on them, each invokes a
>> > different, pre-existing query that becomes the filter through which I
>> > view the data on my form, so with a single click I could change the
>> > order the records are displayed, or see only a subset of the table.
>> > Can anyone shed some light on how to accomplish this, if possible at
>> > all?
>> >
>> > I'm just beginning to use Access (2003), any help would be greatly
>> > appreciated.
>> >
>> > Thanks.
>> >
>> > George
>>
>>
>

[PC Datasheet]

George,

Give me the subject, date and time of your previous post and I will go back
and look at it.

Steve
PC Datasheet

"George Kandaz" <Ge**********@nospam.net> wrote in message
news:qb********************************@4ax.com...

Steve, I posted a question to your last post almost a week ago, but
never heard from you again. Please read my last message, as follows.

Thanks.

-------------------------------------------------------------------------- -
Steve:

I have followed your instructions to a "T". However, I continue to
receive the following:

Run-Time error "2580": The record source "AllRecords" specified on
this form or report does not exist.

Where "AllRecords" is the name of one of several queries I created.
The query 'AllRecords" not only exists, but its name is also in the
QueryName field of one of several records on the TblQueries table,
yet, the code in the combobox claims not to be able to find it!!

Could perhaps there be another property of the MyRecordSource combobox
I need to set in a certain way, but that is not mention in your
messages?

Again, thanks for your help.

George

On Wed, 06 Apr 2005 22:34:50 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

Hi George,

You are very close!

<< does the table have just two fields (SortOrder and Queryname)? >>
Yes

<<The Record Source "2" specified on this form or report does not exist.>>
Did you see my correction? The code should be:
Me.Recordsource = "'" & Me!MyRecordsource.Column(1) & "'"
Instead of:
Me.Recordsource = "'" & Me!MyRecordsource & "'"

Steve
PC Datasheet
"George Kandaz" <Ge**********@nospam.net> wrote in message
news:hl********************************@4ax.com.. .

Steve:

Thanks for your help. This is a very elegant and compact solution that
would allow me to have a very large number of sorting/filtering
criteria available a click away. I am having a bit of trouble making
it work, though. My question is:

The table I need to create, (named TblQueries), does it have three
fields? By looking at your original message, I do not know if
"TblQueries" is both the name of the table as well as the name of the
first of three fields (the other two being SortOrder and Queryname),
or else, does the table have just two fields (SortOrder and
Queryname)?

At any rate, I tried it both ways and get similar errors when I make a
choice from my combo box. Something along the following lines:

"The Record Source "2" specified on this form or report does not
exist.

Thanks for all your help.

George

On Wed, 06 Apr 2005 19:23:21 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

>Just noticed ---
>
>This line:
>Me.Recordsource = "'" & Me!MyRecordsource & "'"
>Should be:
>Me.Recordsource = "'" & Me!MyRecordsource.Column(1) & "'"
>
>Steve
>PC Datasheet
>
>"PC Datasheet" <no****@nospam.spam> wrote in message
>news:1x****************@newsread3.news.atl.earthl ink.net...
>> 1. Create all the queries you want. Create a table named TblQueries

that

>> looks like:
>> TblQueries
>> SortOrder (Integer)
>> QueryName
>> 2. Put the name of all your queries in this table with the sortorder

you

>> want.
>> 3. Create a query named QryChooseQueryName based on TblQueries and

set >the
>> sort on sortorder ascending.
>> 4. Add an unbound combobox named MyRecordSource to your form. Set its >> following properties:
>> a) Rowsource QryChooseQueryName
>> b) Bound Column 1
>> c) ColumnCount 2
>> d) Column Widths 0;1.5
>> 5. Put the following code in the combobox's AfterUpdate event:
>> Me.Recordsource = "'" & Me!MyRecordsource & "'"
>> Me.Requery
>>
>> Note: That's a single quote enclosed in double quotes at both places
>above.
>>
>> --
>> PC Datasheet
>> Your Resource For Help With Access, Excel And Word Applications
>> re******@pcdatasheet.com
>> www.pcdatasheet.com
>>
>>
>> "George Kandaz" <Ge**********@nospam.net> wrote in message
>> news:7v********************************@4ax.com...
>> > Have a run-of-the-mill form, displays one record at a time from a

flat

>> > table (no relations). Would like to create a few command buttons at >> > the bottom of the form, and, when click on them, each invokes a
>> > different, pre-existing query that becomes the filter through which I >> > view the data on my form, so with a single click I could change the >> > order the records are displayed, or see only a subset of the table. >> > Can anyone shed some light on how to accomplish this, if possible at >> > all?
>> >
>> > I'm just beginning to use Access (2003), any help would be greatly
>> > appreciated.
>> >
>> > Thanks.
>> >
>> > George
>>
>>
>