Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sin1965

    Validating form fields

    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...
  2. sin1965

    vb.NET Timer not firing Elapsed time event

    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
  3. sin1965

    vb.NET Timer not firing Elapsed time event

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

    vb.net 2005 multiple soundplayers

    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
  5. sin1965

    .net audio resource file to play in media player

    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
  6. sin1965

    Constraint question

    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...
  7. sin1965

    Constraint question

    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!
  8. sin1965

    Constraint question

    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...
  9. sin1965

    Constraint question

    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...
  10. sin1965

    Can I use an SQL query in a column/table constraint

    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
  11. sin1965

    Can I use an SQL query in a column/table constraint

    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...
  12. sin1965

    Is it possible to use VB.NET modules in Access 97?

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

    makro automation of forms.

    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
  14. sin1965

    Set Decimal

    cheers ds regards steve
  15. sin1965

    Class Modules

    what application are you using to program in?
  16. sin1965

    Set Decimal

    hi DS What you need to do on the form is this. 1. Create a textbox and make the backstyle and borderstyle transparent. also make the forecolor white. This will be named txtHidden. 2. Create a label and make it look like a textbox by setting backcolor to white and specialeffect to sunken. This...
  17. sin1965

    MultiSelect List boxes values

    why have you got the listbox in multiselect mode? your afterupdate event is just selecting the last item clicked? why not turn off multiselect! hth steve
  18. sin1965

    Kill process in Windows

    this will involve the Win32API's regarding threads and processes. Check out the KB and MSDN at Microsoft. hth steve
  19. sin1965

    File dialog Box for Graphics with view option

    There will be a far amount of coding involved. Try this link to find out more about the FSO http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vaobjfilesystemobject.asp hth steve
  20. sin1965

    Set Decimal

    Say u have a TextBox called txtDecimal. enter the following code. Private Sub txtDecimal_AfterUpdate() Dim strX As String strX = Left(txtDecimal.Value, Len(Trim _(txtDecimal.Value)) - 2) & "." & Right(txtDecimal.Value, 2) txtDecimal.Value = Format(strX, "$0.00") End Sub hth steve

Part and Inventory Search

Back
Top