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!

  • Congratulations strongm 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: *

  • Users: RussOSU
  • Order by date
  1. RussOSU

    Using Access to calculate sum loop

    I just threw 50 out there sorry. Using the example if 5 is the max number scheduled and we can only build 4. When I run this again for a different shift/day I need it to start where it stopped (#5) and then go to the next day which would be #1 on the new day. Just taking the code you have and...
  2. RussOSU

    Using Access to calculate sum loop

    Won't your query 1 always be true as you are referencing the same tables in each? a.prod_# is populated by prod_#? The other issue I have is that the sequence numbers do reset back to 1. If it just happens that say one day we build 51 and the next day we build 50 it would return a 1 for the...
  3. RussOSU

    Using Access to calculate sum loop

    for explaination I will put a table (that does not exist) but maybe raw data could help. Area employ work_min avail_min 1 34 44 1496 2 30 44 1320 3 5 40 200 4 25 44 1100 Area 1 prod_# std_prod 1 321.1 2...
  4. RussOSU

    Using Access to calculate sum loop

    I am not really a programmer so I am not sure if this is as easy as it seems in my head. Here is the background; We have a highly variable attendance rate which leads many days to us building subpar products due to guys not having enough time to finish all the work. Our management has finally...
  5. RussOSU

    SATA HDD now IDE HDD doesn't show at bios

    The bios I have is the most up-to-date and worked previously. Drawing out a timeline a little better I think this issue started when I had issues of bad airflow design on my old case and it kept locking up due to temp. I changed cases and everything is back as it was except for this issue...
  6. RussOSU

    SATA HDD now IDE HDD doesn't show at bios

    I installed a WD SATA HDD, booted this up and my IDE w/ bios disappeared. Reset it went into the bios changed from enhanced to legacy. Rebooted back to bios and my IDE showed but not sata (I know it should). Changed back to enhanced and rebooted to bios and both showed up. Thought the...
  7. RussOSU

    Selecting Distinct Value of multiple criteria

    My issue here is the way our data is stored and retrieved in our system yet making it do what I want. Currently we have a serial number that has many options. These options each populate a table with the serial number and a single option per row. What I am wanting to do is to filter the...
  8. RussOSU

    clearing a value and assigning a new value

    Ok here is my issue, I have a database that was created back in 1995/96 and I am trying to add a bandaid fix to it while I recreate it. I am an intermediate Access/VB programmer normally however it has been 5 years (thanks job market) since I have used it so my knowledge is rusty and very...
  9. RussOSU

    Possible ACad Project

    Hey Guys, Quick question for everyone, I am trying to find a way to fix a problem we are having at work. Currently we are having a problem with our facility layout drawings. Currently our plants are responsible for updating the plant layouts however we have a problem with high turn over due...
  10. RussOSU

    Excel Search/Lookup

    Thanks Skip!! PHV - No Excel isn't the way to go. However I need to have a fix in place before I can go in and design the database application to correct this problem. My ideal fix is going to be creating a server database with a .asp or .php application to allow for data insertion and...
  11. RussOSU

    Excel Search/Lookup

    I know the easiest ways would be single sheets or a db however I am trying to simplify the current process (which includes sorting through the worksheets to find the one you want then doing a find to find the dc you want). In the long run I will be trying to redo the process all together...
  12. RussOSU

    Excel Search/Lookup

    This may or may not be possible I am hoping the prior. I am trying to create a search/lookup "application" in an excel workbook. Here is the background: I have a workbook which has multiple worksheets in it. Each one is named after the model in which the data refers to. The data is not...
  13. RussOSU

    Dynamic pages w/o server-side

    I am trying to create a page that displays a list of data with some information attached (class name, location, date, time etc.) I have a long list and instead of creating 100 pages I want to create as few as possible by filtering the data based on a link that redirected the user to the page...
  14. RussOSU

    Dynamic tables/xhtml/xml/css

    I am still a very entry level beginning web programmer. I know how to do .html and have a very beginning concept of xml and am trying to use this to create an .xhtml page. This is where the headache and alcoholic tendencies begin for me. A little background of what I am trying to do so you can...
  15. RussOSU

    Third Master Hard Disk Error?!?!?!?!

    Ok I got my system working and I am even more confused now then I was before. I turned the machine off and sat waiting for responses. Came back tried for like a 5th time to get it to boot from the cd. It did this time right away. So I ran the winxp repair and wrote a new boot sector to the...
  16. RussOSU

    Third Master Hard Disk Error?!?!?!?!

    My comp has been running properly and fine for just over a month now. This is the first time I have gotten this problem so I am not sure what the problem is. On the right side of my screen I have a 0085 (assuming this might be the error code). When I enter the bios setup and go to my drives...
  17. RussOSU

    Third Master Hard Disk Error?!?!?!?!

    I rebooted my system. As I was shutting down it hung up mouse froze and everything. I hit the reset button (probably not my smartest move ever). As it was booting back up it froze when trying to post my hard drive. Eventually (1-2mins) it times out and postes my zip drive and my cd-roms, and...
  18. RussOSU

    vsftp setup

    sleipnir214 no I don't have anonymous write up. I am not going to allow for anonymous users however I needed to check and make sure it was running so I just left it at default files. thedaver who do I create the group users and local users you are talking? Russ
  19. RussOSU

    vsftp setup

    I have read through every post I could find on vsftp over the last 2 days. I have my ftp server up and running for anonymous users. So I know the ports are open and working. I am running this ftp for a couple people who are working with me on some webpage development. So they will really...
  20. RussOSU

    User defined Object Error

    So since I am used to programming and using DAO objects I need to put the DAO. infront of ALL the objects I use in order to make sure that I don't have any problems like these? Thank you for ALL your help Russ

Part and Inventory Search

Back
Top