SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 MS Access
 Starting Month
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

saidev
Posting Yak Master

101 Posts

Posted - 09/25/2006 :  13:56:23  Show Profile  Reply with Quote
Solved

Edited by - saidev on 09/27/2006 11:22:58

jsmith8858
Dr. Cross Join

USA
7423 Posts

Posted - 09/25/2006 :  19:01:38  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
The code you are showing has nothing to do with creating a sql statement, generating a report, or grouping or sorting or formatting on a report. It is simply setting start date and end date variables with some values.

(strEndDateVar and strStartDateVar! Great names! Hungarian prefixes AND suffixes!)

- Jeff
Go to Top of Page

saidev
Posting Yak Master

101 Posts

Posted - 09/25/2006 :  19:11:27  Show Profile  Reply with Quote
t

Edited by - saidev on 09/27/2006 11:23:43
Go to Top of Page

jsmith8858
Dr. Cross Join

USA
7423 Posts

Posted - 09/25/2006 :  20:08:19  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
Again, why is the sql being constructed like this? Why is it all being concatenated together in a big, long ugly and hard to read set of VB statements? You should create a regular query using MS Access, add parameters if needed, test it, save it, and then base the report on the query. This way you can troubleshoot and/or edit the query iself visually and be sure that it all works, test out the joins and criteria and grouping and you have MS Access's query designer to help you,and you can do it all without code and separate from the report. Then, Once the query is returning the data that you need, then you can focus on formatting the report just the way you need it. Doing this like the way they are being done now just makes a big huge mess of code that is hard to read and manage. I'm sure that you've discovered this by now.

Is this code that you've written or inherited? Have you read any introductionary books on MS Access and/or SQL Server?

Time to educate yourself, read up on the fundamentals of the technoliges you are working with, and to use and implement best practices to start cleaning up some of these messes.

- Jeff
Go to Top of Page

saidev
Posting Yak Master

101 Posts

Posted - 09/25/2006 :  21:19:13  Show Profile  Reply with Quote
t

Edited by - saidev on 09/27/2006 11:23:26
Go to Top of Page

jsmith8858
Dr. Cross Join

USA
7423 Posts

Posted - 09/27/2006 :  12:54:58  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
Why are you deleting your posts? Others can learn from these threads, that's the whole point of these forums; it's not as a place people can come and get free, private individual advice ... if that were the case we'd be emailing each other back and forth .... It's considered pretty rude to go back and delete everything that you wrote.

- Jeff

Edited by - jsmith8858 on 09/27/2006 12:58:32
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 09/27/2006 :  13:19:25  Show Profile  Reply with Quote
google didn't cache the pages either..

should we have a blacklist?



-ec
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22761 Posts

Posted - 09/27/2006 :  20:40:13  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
quote:
Originally posted by saidev

Solved


Why did you edit the question?
If you solved the problem, you should have posted as new reply
It seems you edited your other replies also


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22761 Posts

Posted - 09/27/2006 :  20:41:32  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
quote:
Originally posted by saidev

t



What is t?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

timmy
Flowing Fount of Yak Knowledge

Australia
1242 Posts

Posted - 09/27/2006 :  22:55:41  Show Profile  Visit timmy's Homepage  Reply with Quote
I think some people are now scared of being included on the twit list.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000