Search results for query: *

I have a start time and end time on a call log database (and of course a bunch of other information). Anyway, I need to display the time lapse in different views, and allow them to enter a date range. The time lapse needs to be hh:mm:ss I can get the detail to show correctly, but it says that...

I have a table for security. The format is Unique ID, Network ID, and Dept ID. On loading the switchboard, I have the user id stored in variable txtUserID using the environ("username"). I created query qryDeptSecurity that prompts txtUserID. In the combo box properties, I have row source...

I have a table that I want to load with DTS. The problem is that the key is GUID. It fails on this field. How do I get around this and still be able to load the table. I am using GUID in hopes that I can use the Department number as a foreign key to other fields. Am I way off base, and...

I have written a program that allows people to evaluate themselves based on 10 criteria and raters to also rate them. There are many comment fields that I need to store. What is the best way to store these comments. I have one person storing 2500 characters in comments. Any suggestions would...

I am attempting to copy a database from my test notebook to a production server. This is the first time I have attempted to do this with a copy database wizard. I am getting the following error message: Your SQL Server Service is running under the local system account. You need to change...

I have a SQL table that I need to read the records and allow changes or items to be added and then update the table. Since I need to use other tables as drop down items, I decided to do a read, allow the changes, and as new items are added I would do a RS.AddNew. The SQL Statement reads...

I had a class for SQL over a year ago. Now I am trying to install my first SQL server box. I remember something about now using the windows authentication for the password in Service Settings (I think). The book shows that they entered a user created in Active Directory, but didn't say what...

I need to increase the size of a field in one of my Tables. If I make this change, will I risk corrupting the data in the table.

I have four drop down boxes I need to fill in: Category, Engine Family, Bore, and Finish. Depending on the category, only certain engine families will be available, and then depending on the Family chosen, only certain Bores will be avaiable and the Finish depends on the bore. Anyway...I am...

I have a Word document that has VB code behind it. It started out where a person could type in a part number and press a button, it would read the part number and mail merge the information from a SQL database along with our companies logo. The part information would be printed to all 30 cells...