Recent content by chris5g

Only the current owner is important. I think RiverGuy is going in the right direction. It makes sense to have Resource-Owner table and Resouce-Vendor table. then they could refer to the same orgID. Similar to his example with the addresses. -chris _______________________________________

Thanks for the fast reply! A resource is generally a piece of equipment. I want to identify who it belongs to (owner) and who we got it from (vendor). That was the logic when the resource table was setup. -chris _______________________________________

Below is the structure of the tables as it is now. Is it good design to have two table attributes/fields use the same relationship? resOwner and resVendor both refer to orgID it just depends on the orgType. I thought of breaking the Organization table into an Owner and Vendor tables but then...

Here is some more information about the problem: I have a lot of entries in the Work In Progress but none have end times. I'm guessing the Puch Out doesn't work correctly? The only error message I have found is "An error has occured in PunchIn Tracking" which is pretty obvious -chris...

The Timecard Management application from Microsoft has a Time Log when you click on My Calendar that lets you record time. It reads: "Only use the form below to record time worked on a project when you did not punch in / punch out." Timecard Management Link...

I have installed Timecard Management Application Template on my server running Windows SharePoint Services (WSS) 3.0 and it will not save the time spent on a task. I can punch in / punch out but when I look at My Hours Today nothing shows up. Any suggestions? -chris...

Yes, none of those worked anyway. before i had just db_datareader & db_datawriter alone because of what I had read and it still did not work. Only then did i check everything under the sun to make it work. Even still, would a Server Role of sysadmin override all these setting anyway? What...

I take it back, dbcreator alone did not work, had to change back to sysadmin -chris _______________________________________

they are the same... typo When you create a login, you have to assign it a server role or not? I changed mine to dbcreator and was still successful. I've got 2 days w/ SQL Server under my belt -chris _______________________________________

I already was and no go. Under User Mappings for my login, I selected the database I wanted to use 'inventory' and then checked everything: db_accessadmin db_backupoperator db_datareader db_datawriter ... and still did not work until i made the login a sysadmin -chris...

Well, I got it to work only after I made my login a sysadmin under server roles. are there any other options? -chris _______________________________________

SELECT permission denied on object 'tblHardware', database 'hec_inventory', schema 'dbo'. SQL Statement: "SELECT * FROM tblHardware" Here is my problem... I can connect to the DB just fine using a login i created. I have the server setup in SQL & Windows authentication mode. I added the...

Yeah I got that one, it is 4 pin. I think they call it +12 connector or something. I couldn't see your picture. The light will come one but it is amber instead of the usual green. then it shuts off. It is an emachine computer it it matters.

My friends computer wouldn't turn on and I figured it was the power supply. I got a new one that has more watts but when I installed it, the lights will come on but the computer will not boot. I justs shuts off after a few seconds. Do i have to reset the bios or something?

What I want to know is why do i use the first dimension of my array to get the number of columns when using the getrows() method instead of the the 2nd as in numCols = UBound(myArray,2) + 1? Is the myArray(rows,cols) reversed when using the getrows() method as in myArray(cols,rows)