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.Recordsourc e = "'" & Me!MyRecordsour ce.Column(1) & "'" Instead of: Me.Recordsourc e = "'" & Me!MyRecordsour ce & "'"
Steve PC Datasheet
"George Kandaz" <Ge**********@n ospam.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.Recordsourc e = "'" & Me!MyRecordsour ce & "'" >Should be: >Me.Recordsourc e = "'" & Me!MyRecordsour ce.Column(1) & "'" > >Steve >PC Datasheet > >"PC Datasheet" <no****@nospam. spam> wrote in message >news:1x******* *********@newsr ead3.news.atl.e arthlink.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 QryChooseQueryN ame 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 QryChooseQueryN ame >> 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!MyRecordsour ce & "'" >> 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******@pcdata sheet.com >> www.pcdatasheet.com >> >> >> "George Kandaz" <Ge**********@n ospam.net> wrote in message >> news:7v******** *************** *********@4ax.c om... >> > 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 2926
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**********@n ospam.net> wrote in message
news:qb******** *************** *********@4ax.c om... 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.Recordsourc e = "'" & Me!MyRecordsour ce.Column(1) & "'" Instead of: Me.Recordsourc e = "'" & Me!MyRecordsour ce & "'"
Steve PC Datasheet
"George Kandaz" <Ge**********@n ospam.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.Recordsourc e = "'" & Me!MyRecordsour ce & "'" >Should be: >Me.Recordsourc e = "'" & Me!MyRecordsour ce.Column(1) & "'" > >Steve >PC Datasheet > >"PC Datasheet" <no****@nospam. spam> wrote in message >news:1x******* *********@newsr ead3.news.atl.e arthlink.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 QryChooseQueryN ame 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 QryChooseQueryN ame >> 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!MyRecordsour ce & "'" >> 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******@pcdata sheet.com >> www.pcdatasheet.com >> >> >> "George Kandaz" <Ge**********@n ospam.net> wrote in message >> news:7v******** *************** *********@4ax.c om... >> > 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 what I am
looking for is a way <behind a button click event> to dynamically
change the Subform's color scheme so the listing can have color
choices. Is this even possible?
Thanks again to anyone who may be able to help
Wes
|
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. The edocs table also has an
integer field docs_index whose value will be the corresponding docs
index.
Here's a rudimentary layout:
|
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 datasheet mode. However, when I click a button on
another form to display Form1, Form 1 is displayed as single form. I
need it to display Form1 in datasheet mode.
Here is my code in the click event that opens the form:
|
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 grid control.
I tried many grid controls (DBGrid, DataGrid, MSFlexGrid), the ADO
Data Control and everything I can think of, with no success. Here are
the contraints I faced:
(1) Populating any of the grid controls manually is too slow for my...
|
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. I have the
proerties set to "Defaultview=datasheet' and "Views Allowed=datasheet"
-mjm
| |
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 purpose. When I
double click on the form in the database window, it comes up in
datasheet view. But I created a button in my switchboard to bring up
this form, and it shows up with only one record showing, not the whole
table. Is there some kind of...
|
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 they could use the table directly, the datasheet view allows them a
check box to set yes and no for the player in that row. However, I
don't want them to access the table directly.
I can't find a contol that will let me use the datasheet view...
|
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 text
is entered the datasheet does not automatically expand to show all the
text. Is this possible? Obviously, some rows may have 2 lines of text
and some may have 10. I can manually expand the row height but that
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |