Search results for query: *

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

Kulrom - You are awsome! Thanks you so much, that works beautifully. :D

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

No, it is still stored as a datetime datatype and will only take date formatted strings but I have this code for the text boxes to trim and input the strings with ' ' and the date needed that too. Public Function preparestr(ByVal strvalue As String) As String If strvalue.Trim() = "" Then...

Fixed It!!!! Doh! It didn't need #, but it did need ' ' like a string. Thanks for all your help

Yes, I've even tried to change it from datetime to smalldatetime - it just doesn't care what I put in there.

nope, that doesn't matter (i did try it though) the database is getting the entry with the right account number and clinic name, but recieving a date of 1/1/1900. The wierdest part is, I have date of birth entered on the next form and it takes the date just fine. Thanks.

the # didn't work changed code to: Dim str AsString = "insert demographic(quest_date, accnum, clinic) values (" & _ "#" & textdate.Text & "#" & "," & _ acc & "," & _ preparestr(textclinic.Text) & ")" When I put in today's date, I get the error: "The name '#4' is not permitted in this context...

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) =...

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

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

mycommand.dispose() Yes it is a new class for the questionnaire Dim q As New quest - i finally got it to give me a more specific error but it just points to my line that says mycommand.dispose(), which is just the SQL command being disposed

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

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