Recent content by sin1965

hi i have tried your code and it works ok for me! the form closes on button click without validation! The only difference was that i set the button.causesValidation property in the property page and put End in the button.click handler. you may have some other code that is causing the problem...

you shouldn't have a sub main in a public class unless it is the start of an application. maybe you should change it to a constructor with the 'sub New'. Also you do not need an AddHandler if you have declared withevents. hth sin1965

hi you need to declare Qtimer 'withevents' or add an event handler using the 'addHandler' method hth sin1965

hi is it possible to play sounds simultaneously using the .net 2.0 soundplayer class. i have tried instantiating 2 objects of the soundplayer class. yet the second one halts play in the first one when it starts! any ideas? sin 1965

hi is it possible to cast a vb.net 2005 audio wav file embedded as a resource from type IO.UnmanagedMemoryStream to IWMPMedia interface so that I can play resource audio in windows media player? any help would be appreciated sin1965

HI From the original issue I never stated that a M:N relationship between any tables exists. P and S would have been a M:N but is broken by PS. This is a 1:M on the other tables. Even having a 1:1 between tables P & S doesn't stop a student working on 2 projects at once. It only means they have...

Hi Yes the PK in P with endDate null will not work as you say. But having unique constraint on PS(projID, studID) doesn't stop me putting a student on any number of projects! It is the PK anyway!

hi The schema is as such, scaled down to the essentials table P projID endDate PK (projID, endDate) table S studID PK table PS projID studID FK on S endDate PK (projID, studID) FK (projID, endDate) on P [on update cascade]???? UNQ (studID, endDate) Yet Oracle doesn't have a cascading...

Hi all Say for instance I have a student table S, a project table P and StudentProjectMatch table PS. The relationships are 1:m from both P -> PS and S -> PS and optional at the 1 ends. How can I constrain a student from starting a new project until the one they are working on is finished. Using...

Hi My initial enquiry was just to confirm that queries cannot be used in constraints. you have answered my ? Thank you for you replies. steve

hi all is it possible to use an SQL query in a column or table constraint. I haven't been able to find any info for this. It seems that only logical evaluation of simple expressions is allowed. If that is so, then I assume that I will need to use a stored procedure acting on updates inserts and...

have a look at com interop in the .net help at msdn online hth steve

in the query on which your report is based set the criteria field of the date or dates to the textbox on the form, thus: =Forms![yourformname]![yourtextboxname].value hth steve

cheers ds regards steve

what application are you using to program in?