Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chris5g

    Databse Design - Same one to many used twice in a table?

    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 _______________________________________
  2. chris5g

    Databse Design - Same one to many used twice in a table?

    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 _______________________________________
  3. chris5g

    Databse Design - Same one to many used twice in a table?

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

    Timecard Management Doesn't Track Time

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

    Time Tracking template

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

    Timecard Management Doesn't Track Time

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

    SELECT permission denied

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

    SELECT permission denied

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

    SELECT permission denied

    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 _______________________________________
  10. chris5g

    SELECT permission denied

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

    SELECT permission denied

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

    SELECT permission denied

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

    Upgraded Power Supply Problem

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

    Upgraded Power Supply Problem

    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?
  15. chris5g

    array layout and getrows()

    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)
  16. chris5g

    array layout and getrows()

    I'm a little confused about the layout of an array returned by getrows(). It is my understanding that when you create a multidimensional array, myArray(10,3) the first number, 10, is the rows and the second, 3, is the columns. However, when I pulled the data with getrows, this seems to be...
  17. chris5g

    cint("0") error

    I tried the Ctype("0",Integer) and it works with no errors - Thanks! I am getting the same problem when I try to use the IsNumeric("0") funtion. Well, I get False back, not a crash. my program asks user for integers and I was using isnumeric to test and then cint() to change type. The only...
  18. chris5g

    cint("0") error

    I am trying to convert string input to an integer using the cint() function. I am running into a problem when I try to convert the string "0" to get integer 0. Any solutions for this? Thanks!
  19. chris5g

    Write Permission IIS5

    Yes it works now that I changed the permissions for the file in the security tab. -chris ________________________________________ ....my other programs are better .. i promise
  20. chris5g

    Write Permission IIS5

    If you have a missing Security tab for file properties in WIN XP PRO you will have to go to: Windows Explorer Choose Tools > Folder Options... Go to the View tab Uncheck Use simple file sharing at the very bottom Found this in the Windows XP Pro forum. Thanks guys...

Part and Inventory Search

Back
Top