Search results for query: *

  • Users: osani
  • Content: Threads
  • Order by date
  1. O

    Insert ID into 2 linked tables

    HI, I am very clumsy with vb.net and sql server, but I am trying to insert an id number into 2 tables that are linked. when I insert into one, it says I violated the foriegn key relationship with the other. How do I insert into both tables simultaneously using a sub routine in vb.net?:confused...
  2. O

    Returning identity value when inserting new data

    Hi all, My database is set up to assign a bigInt identity data type to the record when a new person is entered. The identity starts at 11000 and is incremented by 1. I have 4 tables that are relationally joined so when a new record is entered into the main table a record with the same...
  3. O

    Getting a date from a textfield to sql server

    Hi I am trying to get a date from a textfield in vb.net to sql server 2000. The data type is datetime. The problem is no matter what I enter or how I enter it, the entry goes in to the db as 1/1/1900. I've included pieces of relevant code. Please help. Thanks If IsDate(textdate.Text) =...
  4. O

    incorrect date entered from vb.net to sql server 2000

    Hi I'm not sure if this is a VB question or an SQL server question but here goes... I have a db created in SQL Server 2000 with a VB.net interface and I am tring to input a date. The datatype is datetime and I have code that corrects a typo if the date is not valid. I even put in msgbox to...
  5. O

    Adding color to the tab index pages tabs

    Hi, This may be a dumb question, but I created an 8 page form using a tab pane and I can't seem to figure out how to color the tabs at the top of the pane. It looks terrible to leave them gray. Changing the bakckcolor property only changes the frame's color. Does anyone know the property that...
    • osani
    • Thread
    • Replies: 4
    • Forum: GUI
  7. O

    Clinical database design question

    Ok, I am creating a database for a clinical trial and there are 2 forms. The first is the main form which contains, demographics, pain descriptors, and various other clinical information. The second is a follow up questionnaire with similar questions to the first to base improvement analysis...
  8. O

    Error - "Object reference not set to an instance of an object"

    Hi all, I am trying to create a clinical trial database with attached forms for data entry. I keep getting the error "object reference not set to an instance of an object" and i know this means something is null or not initialized but I am pulling my hair out. I have no fancy methods or...
Back
Top