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 >> >> > 1 2911
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
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 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 >> >> > This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: codemonkey |
last post by:
TIA! I would like to know if there is a way to dynamically change the
colors of Subform items? I have already set in place Conditional
Formatting so each row has an alernating color scheme, but...
|
by: Peter Kleiner |
last post by:
Greetings all,
I have a database with two tables: docs and edocs. For each record in
docs there can be zero to unlimited records in edocs. Both tables have
an integer primary key named index. ...
|
by: RLN |
last post by:
Re: Access 2000
I have a form (Form1) where the default view in the properties is set
to "Datasheet".
When I click on the Form1 object from the container to display it, it
displays fine in...
|
by: Aladdin |
last post by:
I have an MS Access form on which I have a listbox listing tables in
that database. I want to be able to click on any of those tables and
view its contents on the same form using subforms or any...
|
by: michael montagne |
last post by:
I can't seem to get my form to show datasheet bt default. If I run it
from the databse window, it works just fine. But called from a button
on a different form, and it goes to form view instead. ...
|
by: danit58 |
last post by:
Is it possible format the backcolor of rows, depending the value in a field
of the the rekords, in datasheet mode??
Can you help me???
|
by: davegb |
last post by:
I learned recently that I should never allow end users access to my
tables, that if I want them to see that data in that format I should
show them a datasheet form. I created a form for this...
|
by: Newbie |
last post by:
I would like to display certain columns from a table on a form.
One of my columns that I want to show is a Yes/No field so that my
users can pick their players for a fantasy football week.
If...
|
by: Lynx101 |
last post by:
Hi, hope anyone can help with this query.
Background:
Subform datasheet link to a form to store updates on projects.
Query:
I have a datasheet where one of the field is a memo field. When...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |