Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the 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
Showing results 1 to 11 of 11
Search took 0.01 seconds.
Search: Posts Made By: nokia_helper
Forum: Access VBA June 7th, 2006, 09:14 AM
Replies: 7
Views: 3,364
Posted By nokia_helper
Why are you trying to convert the data in the...

Why are you trying to convert the data in the textbox with CDate? Can't just use the data from the textbox?

"Where Scheduled_Appointment.App_Date = '" & Me.Text1.Value & "'"
Forum: Access VBA June 5th, 2006, 09:32 AM
Replies: 7
Views: 3,364
Posted By nokia_helper
What data type is Scheduled_Appointment.App_Date?...

What data type is Scheduled_Appointment.App_Date?

Is it a string or is it date/time?
Forum: SQL Language May 31st, 2006, 09:11 AM
Replies: 7
Views: 770
Posted By nokia_helper
You can set up a loop structure to loop through...

You can set up a loop structure to loop through the site ID's and then pass each ID to the SP.

EXEC sp_ParticipantsPerSite @VariableSiteID = 1;
Forum: SQL Language May 31st, 2006, 04:30 AM
Replies: 2
Views: 891
Posted By nokia_helper
This query will look for records that have: ...

This query will look for records that have:

reportComments.lastEdited earlier than Feb 22
AND
reportComments.lastEdited later than May 22

The date value in that field cannot fill both of...
Forum: SQL Language May 30th, 2006, 08:53 AM
Replies: 7
Views: 770
Posted By nokia_helper
Are you using an MS SQL Server? If so you...

Are you using an MS SQL Server?

If so you could for example create a Stored Procedure and then pass the SiteID to the SP as a variable.

CREATE procedure sp_SiteSummary
@VariableSiteID int
AS...
Forum: SQL Language May 30th, 2006, 08:20 AM
Replies: 7
Views: 770
Posted By nokia_helper
I don't have access to a DB right now, so I'm...

I don't have access to a DB right now, so I'm sorry if the syntax is a little off. Let me know if this is what you are looking for.

SELECT [Site ID], COUNT(ProgramParticipantID)
FROM [Program...
Forum: SQL Language May 30th, 2006, 06:50 AM
Replies: 7
Views: 770
Posted By nokia_helper
How about something like this SELECT...

How about something like this
SELECT COUNT(ProgramParticipantID) FROM [Program Participants] Where ProgramID =4
Forum: Pro VB.NET 2002/2003 May 30th, 2006, 06:05 AM
Replies: 1
Views: 1,762
Posted By nokia_helper
What is your data source for the combobox? ...

What is your data source for the combobox?

You could leave a dataset open in the background with the data
the dataset could containg two columns, abbreviation and text
AL, ALABAMA
AK, ALASKA...
Forum: VB.NET 2002/2003 Basics May 23rd, 2006, 04:31 AM
Replies: 1
Views: 801
Posted By nokia_helper
Maybe I have misunderstood your post. Do you...

Maybe I have misunderstood your post. Do you mean that you cannot open the other tab pages in design mode?
Forum: VB.NET 2002/2003 Basics May 22nd, 2006, 10:09 AM
Replies: 1
Views: 3,621
Posted By nokia_helper
Have you taken a look at ther System.IO...

Have you taken a look at ther System.IO Namespace?

Especially the Filestream class.

That probably has the info you are looking for.
Forum: VB.NET 2002/2003 Basics May 22nd, 2006, 09:44 AM
Replies: 2
Views: 1,716
Posted By nokia_helper
Perhaps you have changed your compilation...

Perhaps you have changed your compilation settings? That is to say from Debug to Release?
Showing results 1 to 11 of 11

 




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