I'm looking for an alternative to this. Something that allows me to, for example, press F3 and the screen will automatically capture the current window/screen and save it to a file on my computer. Pasting into paint is annoying when you have loads of screenshots to do

Just wondering what everyone else uses for capturing screenshots in windows? Theres hundreds of programs on offer but i dont really know which one to pick. Preferably after a free one!

Next time you have a question like "what is the difference between x and y" try searching google for something like "x vs y". Its usually quite effective. try this

it sounds like you have very little programming experience judging by the questions you are asking. why not buy a programming book or get one from you library and have a read. or try wikipedia. i'd recommend learning java if youre wanting something that will run on a variety of operating systems. or if youre just wanting to write programs that run on microsoft windows why not download some of the visual studio express editions and learn from there.

I got the same answer off a guy i work with. I think thats the way to do it. I dont get why the databinding process doesnt just ignore the optional parameter. Thanks for your response!

Hi, I have a class that has a few properties that accepts an optional boolean parameter. For example: Private _venues AS BSVenue Public ReadOnly Property Venues(Optional ByVal forceupdate As Boolean = False) As BSVenue() Get If _venues Is Nothing Or forceupdate Then _venues = BSVenue.GetVenuesByCourse(CourseID) End If Return _venues End Get End Property When i try binding a member of this class to a control it says it cannot find the property. It works fine if the property has no parameters. Whats going on?

i cant believe you bothered to read that!

Why not just use the listbox? is there some reason you dont want to use it?

Thanks for your advice. At the moment my code is pretty inefficient so i can see how the update join may speed things up and make my life a little easier!

i think the real challenge is trying to figure out what your question is.

Ok. It would be nice if you could do it though. how about DELETE JOIN? I'm sure you can do that forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2541925&SiteID=1 (its a little slow today) But for some reason my sql isnt working for that either. ive tried numerous combinations with this being the most sensible i think: DELETE FROM Courses INNER JOIN Deliveries ON Courses.CourseID = Deliveries.CourseID WHERE Courses.CourseID = @CourseID exactly the same error : "Incorrect syntax near 'INNER'"

Hey. I understand that in sql server 2005 you can write statements to update several tables at once using join. Is that correct? I'm trying to this but keep getting an "Incorrect syntax near 'INNER'" error. My SQL is UPDATE Courses INNER JOIN Deliveries ON Courses.CourseID = Deliveries.CourseID SET Courses.IsDeleted=1, Deliveries.IsDeleted=1, Courses.DeletedOn=@DeletedOn, Deliveries.DeletedOn=@DeletedOn WHERE Courses.CourseID=@CourseID Any help would be appreciated

Thanks for your answers. I've decided to get rid on my byref/boolean functions and opted for the first option. I think its the most sensible choice for my application and possibly is the best choice for most apps.

If the first function handled all its exceptions internally it would return nothing when there was database error or there was no course with that ID in the database. The calling method wouldnt be able to tell what really happened. With the second function you could differentiate between when the function failed or whether there just wasnt a course with that id in the database. i dont think the calling method should care about how the function failed, just whether it did or not. Allowing the functions to throw out exceptions in my opinion is a bad idea if you can just handle them internally. Yes or no?

Im not sure of your point. With the second method you also have the option of throwing an exception or returning false (instead of nothing). the calling methods would be something like this (if the functions didnt handle their own exceptions 1. try course = GetCourse(courseid) catch 'error handle end try if course is nothing then ' do something else 'do something else end if 2. try if GetCourse(courseid, course) then ' do something else ' do something else end if catch ' error handle end try theyre essentially the same as far as i can tell

I am currently building a simple database access class. I have a function GetCourse which I want to get a course object from the database. I could specify it like this: public static function GetCourse(byval courseid as integer) as Course An alternative would be: public static function GetCourse(byval courseid as integer, byref course as Course) as Boolean the two methods are only different by how they return the values. the first would return Nothing when it couldnt find a course (throw an exception or return Nothing when a database error occurred). the second function would return false when it couldnt find a course and true when it could (either throwing exceptions or returning false in the case of a db error) and it would assign the course details to the course parameter. The calling method would either check for Nothing in the case of the first function or check for true/false in the case of the second function to indicate that the course could be found. I would like to hear peoples opinions on which function you would prefer and why. Or if there is a better alternative Thanks!

Thanks for replying blue_boy and harini. I used blue_boys solution in the end and it works as i want it. it actually fits into another much longer sql statement.

Hi, I have a table that lists the incomes and expenditures of various organizations. Organization | Report Year | Income | Expenditure Org 1 | 1/4/2008 | £20 | £30 Org 1 | 1/4/2007 | £20 | £30 Org 2 | 1/4/2003 | £20 | £30 Org 2 | 1/4/2002 | £20 | £30 Org 2 | 1/4/2001 | £20 | £30 Org 3 | 1/4/2006 | £20 | £30 Org 4 | 1/4/2002 | £20 | £30 I have been trying to write a query that will return the latest record for each organization. So the result would be Org 1 | 1/4/2008 | £20 | £30 Org 2 | 1/4/2003 | £20 | £30 Org 3 | 1/4/2006 | £20 | £30 Org 4 | 1/4/2002 | £20 | £30 Tried searching but came up with no uselful answers. Can someone help? It needs to be compatible with Microsoft Access X|

Great. Thanks very much!

Hi. I have database structure like this: Organizations(OrganizationID, Name) Members(MemberID, OrganizationID, Name) Courses(CourseID, OrganizationID, Name) I need to return the Organization Name, the number of members of that organization and the number of courses in that organization in one sql statement so I'd have a table like [OrganizationName] [Number of Members] [Number of courses] [Org A] [10] [22] [Org B] [92] [11] ... Is it possible without using a stored procedure? Can anyone help me out? Any help would be much appreciated.