Hello everyone,
I'm new to access, so if this is a dumb question I apologize in
advance.
I created a query that requires a "parameter value" to be entered.
I then created a form to display the results of that query.
This worked fine and I am able to scroll throught the results of the
query in my form.
I then created a "command button" on the this form to call up the same
query as before.
The problem is that it displays the correct results, but only in
DATASHEET view.
How can I force it display the results in Form View.
(even a hammer won't work!)
Thanks,
Dave 9 3316
On Thu, 04 Aug 2005 13:08:34 GMT, David White wrote: Hello everyone,
I'm new to access, so if this is a dumb question I apologize in advance.
I created a query that requires a "parameter value" to be entered. I then created a form to display the results of that query.
This worked fine and I am able to scroll throught the results of the query in my form.
I then created a "command button" on the this form to call up the same query as before.
The problem is that it displays the correct results, but only in DATASHEET view.
How can I force it display the results in Form View. (even a hammer won't work!)
Thanks, Dave
Did you set the Default Form View property to either Continuous Form
or Single Form View?
It's on the Form's Property Sheet's Format tab.
What is the command button click event code?
The best way to do this, however, is to set the query as the form's
Record Source. Open the form and the query will prompt for the
parameter. Enter the parameter and the form will automatically display
the query result. There is no need for a separate command button.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
On Thu, 04 Aug 2005 13:08:34 GMT, David White wrote: Hello everyone,
I'm new to access, so if this is a dumb question I apologize in advance.
I created a query that requires a "parameter value" to be entered. I then created a form to display the results of that query.
This worked fine and I am able to scroll throught the results of the query in my form.
I then created a "command button" on the this form to call up the same query as before.
The problem is that it displays the correct results, but only in DATASHEET view.
How can I force it display the results in Form View. (even a hammer won't work!)
Thanks, Dave
Did you set the Default Form View property to either Continuous Form
or Single Form View?
It's on the Form's Property Sheet's Format tab.
What is the command button click event code?
The best way to do this, however, is to set the query as the form's
Record Source. Open the form and the query will prompt for the
parameter. Enter the parameter and the form will automatically display
the query result. There is no need for a separate command button.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
On Thu, 4 Aug 2005 06:56:37 -0700, fredg <fg******@examp le.invalid>
wrote:
I Like your idea about Opening the form and then receive a prompt for
the display.
The query is, however, the form's Record Source
Is the problem caused by the facr that I intially used the Form Wizard
to set up the form using the Query instead of the Underlying table? Did you set the Default Form View property to either Continuous Form or Single Form View? It's on the Form's Property Sheet's Format tab. What is the command button click event code?
The best way to do this, however, is to set the query as the form's Record Source. Open the form and the query will prompt for the parameter. Enter the parameter and the form will automatically display the query result. There is no need for a separate command button.
On Thu, 4 Aug 2005 06:56:37 -0700, fredg <fg******@examp le.invalid>
wrote:
I Like your idea about Opening the form and then receive a prompt for
the display.
The query is, however, the form's Record Source
Is the problem caused by the facr that I intially used the Form Wizard
to set up the form using the Query instead of the Underlying table? Did you set the Default Form View property to either Continuous Form or Single Form View? It's on the Form's Property Sheet's Format tab. What is the command button click event code?
The best way to do this, however, is to set the query as the form's Record Source. Open the form and the query will prompt for the parameter. Enter the parameter and the form will automatically display the query result. There is no need for a separate command button.
"David White" <dj*****@snet.n et> wrote in message
news:te******** *************** *********@4ax.c om... Hello everyone,
I'm new to access, so if this is a dumb question I apologize in advance.
I created a query that requires a "parameter value" to be entered. I then created a form to display the results of that query.
This worked fine and I am able to scroll throught the results of the query in my form.
I then created a "command button" on the this form to call up the same query as before.
The problem is that it displays the correct results, but only in DATASHEET view.
How can I force it display the results in Form View. (even a hammer won't work!)
Thanks, Dave
Dave,
It sounds like the problem is your command button. The "click" event is
likely set to open another query. Queries are always opened in datasheet
view. Try changing your "click" event to change the record source of the
form to the new query (instead of just opening the query).
Fred Zuckerman
"David White" <dj*****@snet.n et> wrote in message
news:te******** *************** *********@4ax.c om... Hello everyone,
I'm new to access, so if this is a dumb question I apologize in advance.
I created a query that requires a "parameter value" to be entered. I then created a form to display the results of that query.
This worked fine and I am able to scroll throught the results of the query in my form.
I then created a "command button" on the this form to call up the same query as before.
The problem is that it displays the correct results, but only in DATASHEET view.
How can I force it display the results in Form View. (even a hammer won't work!)
Thanks, Dave
Dave,
It sounds like the problem is your command button. The "click" event is
likely set to open another query. Queries are always opened in datasheet
view. Try changing your "click" event to change the record source of the
form to the new query (instead of just opening the query).
Fred Zuckerman
On Thu, 04 Aug 2005 14:12:48 GMT, David White wrote: On Thu, 4 Aug 2005 06:56:37 -0700, fredg <fg******@examp le.invalid> wrote:
I Like your idea about Opening the form and then receive a prompt for the display.
The query is, however, the form's Record Source
Is the problem caused by the facr that I intially used the Form Wizard to set up the form using the Query instead of the Underlying table?
Did you set the Default Form View property to either Continuous Form or Single Form View? It's on the Form's Property Sheet's Format tab. What is the command button click event code?
The best way to do this, however, is to set the query as the form's Record Source. Open the form and the query will prompt for the parameter. Enter the parameter and the form will automatically display the query result. There is no need for a separate command button.
If the command button event code is something like:
DoCmd.OpenQuery "QueryName"
that will open the query as a query (in datasheet view).
I believe you are going about this incorrectly. If the Query is the
form's record source, that should be all you need to filter and show
the appropriate records after entering the parameter when prompted.
Why don't you use the built-in Filter-by-Selection or Filter-by-Form
tool buttons to filter within the filter?
No need for a command button.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
On Thu, 04 Aug 2005 14:12:48 GMT, David White wrote: On Thu, 4 Aug 2005 06:56:37 -0700, fredg <fg******@examp le.invalid> wrote:
I Like your idea about Opening the form and then receive a prompt for the display.
The query is, however, the form's Record Source
Is the problem caused by the facr that I intially used the Form Wizard to set up the form using the Query instead of the Underlying table?
Did you set the Default Form View property to either Continuous Form or Single Form View? It's on the Form's Property Sheet's Format tab. What is the command button click event code?
The best way to do this, however, is to set the query as the form's Record Source. Open the form and the query will prompt for the parameter. Enter the parameter and the form will automatically display the query result. There is no need for a separate command button.
If the command button event code is something like:
DoCmd.OpenQuery "QueryName"
that will open the query as a query (in datasheet view).
I believe you are going about this incorrectly. If the Query is the
form's record source, that should be all you need to filter and show
the appropriate records after entering the parameter when prompted.
Why don't you use the built-in Filter-by-Selection or Filter-by-Form
tool buttons to filter within the filter?
No need for a command button.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
On Thu, 4 Aug 2005 09:16:44 -0700, fredg <fg******@examp le.invalid>
wrote:
Thank you both for your input.
I took your suggestion and created a filter by copying and pasting a
part of the Query in "SQL view" to the Form's Property-Filter Record.
I then created a Command button to apply the filter. Works great.
Thanks again,
Dave This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John M |
last post by:
Hello All,
The code below is something I have been working on and just can't get
past. I know it must be very simple but here goes. The Form Method
line text is invisible on browers, but still forcing a space betweem
the graphics and the forms. How do I make the Form Method line
function, but not require space on the page? Code is below, take a
look ans see for yourselves...
I appreciate any help.
|
by: John Baker |
last post by:
Hi:
I have a query which supports a form. Te form is used to edit, update and change records
in the table the query is based on. It all works fine EXCEPT that the "New" record (blank
updatable record) always appears as the end of the form (i.e. the bottom), whereas it
would be very helpful if it appeared at the beginning (the top of the form).
Can anyone suggest a way to make this happen?
Regards
|
by: Stuart McGraw |
last post by:
I haven't been able to figure this out and would
appreciate some help...
I have two tables, both with autonumber primary
keys, and linked in a conventional master-child
relationship. I've created forms for both those
tables, and inserted the child table form into the
master table form as a subform. It works just as
it is supposed to, in that I can create a new master
record, and then add detail records.
|
by: David White |
last post by:
Hello everyone,
I'm new to access, so if this is a dumb question I apologize in
advance.
I created a query that requires a "parameter value" to be entered.
I then created a form to display the results of that query.
This worked fine and I am able to scroll throught the results of the
query in my form.
|
by: Earl Teigrob |
last post by:
I have a page that reads values from an XML file to display to the user. The
page also has a control panel that allows administrators to update the XML
file with new values. When an administrator presses the update button in the
control panel area of the page and the values are written to the XML file, I
want the page to reload with the new values WHILE RETAINING ANY VIEW STATE
VALUES. (that are not rewriten by the new XML values)
I have...
| |
by: steve |
last post by:
SysInternals provides a *FANTASTIC* product called DebugView.
It allows you to snoop User and Kernel traces, eg. You can view
Trace.WriteLine etc
It also timestamps the traces. I deal a lot with proprietary comms
protocols, so these timestamps are valuable.
When I'm running under the VS debugger, Trace output is redirected to the
"Output" window. Unfortunately, it appears that VS intercepts the traces so
that they don't appear in...
|
by: Fabuloussites |
last post by:
Greetings All,
here is my situation. i have a master page that has a login user control
embedded on it. within the user control there is a multiview. in the
default view, the username/passwords fields are there. once the user is
authenticated, the page posts back, and the multiview view changes to another
view where a menu is displayed.
under this set of circumstances, is it possible to use the postback url
propety for the login...
|
by: ATS16805 |
last post by:
Hi. I wonder if it's possible to "force" a browser to "switch to SSR
mode" for any given document. Specifically, I'm looking for a
solution, not to a User Agent issue (i think), but a coding idea; a
programming "what if..?".
i'm not concerned w/ manipulating a browser (i.e. prefs., settings
this URL, always view SSR, save), but rather something i would code
into the document which would request the browser to display in this
mode (i.e....
|
by: Ken Fine |
last post by:
I am using ASP.NET's CreateUserWizard control. I want to force the visitor
to use a username and e-mail address that I am providing in programming, and
I do not want the visitor to be able to edit the forms input.
I am aware that I can roll my own Create User form by using the membership
API, but I am lazy and want to use most of the CreateUserWizard control's
features.
I tried converting the form to a template and setting the UserName...
|
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: 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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |