Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 30th, 2007, 03:52 PM
Friend of Wrox
 
Join Date: Apr 2006
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default Query data in form

Hi,

I have a problem I never had before. I have 2 query's in my database on which forms are made.

When I open the query's and input the parameters, I get the results needed. Howerve, when I open the forms (that are based on the same query's) the results are empty. I don't get any value...

How can this happen?

 
Old January 31st, 2007, 10:30 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Need more information. SQL statement from the queries, and the procdure you use that DOES work, and more details about the record source etc of the form that does not work.

mmcdonal
 
Old February 1st, 2007, 10:45 AM
Friend of Wrox
 
Join Date: Apr 2006
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I found the problem myself by now, but thanks for trying to help...






Similar Threads
Thread Thread Starter Forum Replies Last Post
Not Open Form when no data in query mean34dean Access 4 August 21st, 2008 11:46 AM
How to Query XML Data from XSLT Form kwilliams XSLT 1 December 3rd, 2005 06:14 AM
Query from Form vemaju Access 7 September 15th, 2005 10:43 AM
Query data and exporting data from one sheet to an testman Excel VBA 2 April 28th, 2005 02:40 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.