Search results for query: *

Thanks bunches for all your help!

tblCallHeader contains the following fields:CallNbr, NetworkID, CallDate, StartTime, EndTime, CustomerNbr, CallerNotes, OperatorNotes, and CallType. What I am attempting with a query - Column - CallType Row - NetworkID Data - Sum([tblCallHeader!EndTime]-[tblCallHeader!StartTime]) The problem...

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

The problem I am having is that I can click and highlight the selection, but the drop down doesn't close and the selected information doesn't show in the box above. It is a combo box. Sorry it took so long to get back to you. I was on vacation. Thanks again...

I removed the query from the control, and moved it to the Form_Open and assigned the sql statement at that time. Is that what you are talking about? With this way the box is loaded with the options again, but I still can't select an option and get it to show as selected.

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 just got it. I was trying to use GUID as an ID, because I couldn't get the foreign key to work and didn't know if it was because it was a primary key. Come to find out, it erroring out was because there was data in the other tables. I was able to remove the GUID, get the relationships, and...

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

SQL with a VB 6 interface.

Since I have them currently stored as a vaarchar, is there a way I can successfully convert these fields over to memo fields? (Sorting and grouping is not an issue, because they are truly just employee comments). And also, if I am writing from a VB6 program to the memo field in the SQL...

Please forgive my ignorance....I thought I had a problem with my SQL database recordsize being too big after it reached over 8000 characters. Am I missing something?

Is there still a limit on how big the memoComment can be? Sorry it took so long to get back, been crazy here. I appreciate any help that can be given.

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

Denny, I appreciate the quick response. Will try this as soon as I can get a chance. Thanks again. Dmm

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

Sorry about that, I did a search in the SQL forum (I thought). I will repost. Thanks for your quick response.

I am doing something very similar in VB6. However, I have a date already in there and I need to be able to clear the date. Even setting it to nothing, I am getting a data mismatch. The field in the SQL table is date time and it is marked as nullable. Any suggestions? and TIA

SQLSister, Thanks for the help. I had a second, very small database with 1 table that I exported the table to for a second backup, removed the ability for anyone to access the table, and the update went beautifully.