Wrox Programmer Forums
|
BOOK: Beginning Access VBA
This is the forum to discuss the Wrox book Beginning Access 2002 VBA by Robert Smith, Dave Sussman, Ian Blackburn, John Colby, Mark Horner, Martin Reid, Paul Turley, Helmut Watson; ISBN: 9780764544026
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Access VBA 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 April 6th, 2005, 08:02 AM
Authorized User
 
Join Date: Oct 2004
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data report & date problem

I am getting a problem when i passing the parameter of command(in dataenvironment connection) as date.
i wants to send date as param to sql command. i grouped some feilds in command using the grouping method in command in dataenvironment.
my calling statements are as follows
when i call this it is giving the error
'runtime error -2147467259 (80004005)
unspecified error'

statements

DataEnvironment1.cmdDailyFullRpt_Grouping CDate(DTPick.Value)
DailyFullReport.Show 1
DataEnvironment1.rscmdDailyFullRpt_Grouping.Close

please help to solve this problem

Software proffesional from Bangalore,INDIA
__________________
Tell me what you need and i will tell you how to get along without it.
-----------------------------------------------------------------
Ratheesh
Bangalore, INDIA
[email protected]





Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with oracle & crystal report with Vb abhijhegde Beginning VB 6 1 May 3rd, 2007 12:03 PM
Problem with Date in Crystal Report denishrt Crystal Reports 0 September 26th, 2006 10:46 PM
Data updating in Table & reflecting in report anukagni Access 5 May 31st, 2006 03:57 AM
* where date >= '"& dateVar &"' order by date wrofox Classic ASP Databases 5 February 24th, 2005 10:11 AM
Getting Problem in DATE/TIME Data type in MS Acces selam70 Classic ASP Databases 2 September 4th, 2004 02:31 PM





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