Search results for query: *

Hi everyone,I have a Parameter Query that I am running to pull records from an Access database. The user is entering the last four of the Social Security Number to retrieve records with a Message Dialog Box. I need Access to give a message, "No Records Found" in an unbound field on the form...

Hi everyone, I have a Parameter Query that I am running to pull records from an Access database. The user is entering the last four of the Social Security Number to retrieve records with a Message Dialog Box. I need Access to give a message, "No Records Found" in an unbound field on the form...

I have a Work Order Number field that is called Workorder_TextBox. This Workorder_ Textbox field can be left blank and the record can save, but when something is entered in the Workorder_textbox field, I want it to give a message that only numbers are allowed. If some user comes in and puts...

Hi, I have a question about adding records to the SQL Server 2005 database. I have an ID field that automatically increments. When I first add records to the table, it is placing a "0" in this field. Why doesn't the field start at 1 in lieu of 0? Other people have added records to the...

Hello everybody, I am trying to put an invalid password message in red by the UserName and Password textboxes when an incorrect UserName is used or Password is used. How can the Text Changed event be used here to do this. I know I can click on the UserName and Password Textbox and go to...

Where do I write the Update Triggers? I have the SQL management Studio. Do I write the Triggers like stored procedures under programmability? Also, How does the trigger run whben updates are performed?

I am having a problem getting my computer to know what is an update or save. My application is saving a record to the datebase and letting me update a record, but I want the computer to indicate the DateTimeModified as the current date of the change. I am using a Sequel Server 2005 database...

Riverguy, I'm not sure I understand all of that. YourCommandObject.Commandtext = Select Statement. I understand what your Select statement is doing, but the other parts I do not. Can you explain a little more clearly. I am new to this. Thanks dcTechuser

I'm in a learning phase of Vb, and I am trying to develop a Login form that will look in the sequel server database and pull the UserName and Password along with role. I have setup a User table in the Sequel Server 2005 database. The fields are: Username, Password, and Admin. I have created...