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

    Calulating Sums with Date issue

    Still having issues with making this more dynamic. This is all from excel in formulas and so this thread really needs to be moved as well. Not sure how to accomplish that. So here is an examples and the expected results. Everything except the birth month needs to be dynamic. Birth Month = 1 JAN...
  2. etrain

    Calulating Sums with Date issue

    Thanks this got me in the right direction. Remember the Past, Plan for the Future, yet Live in the Present for tomorrow may never come. -etrain
  3. etrain

    Calulating Sums with Date issue

    I need to calulate hours logged on a semi-annual basis based on a persons birth month. For example employee Jim has a birth month of October. I need to calulate his hours logged from Nov to Apr (1st Semi) and again from Apr to Nov (2nd Semi). It needs to be done on a adhoc basis through out the...
  4. etrain

    How to calculate Elapsed Off Time

    I am sure it has been answered so I apologize up front. I did search but did not come up with what I needed. I have a table that logs duty start and end times. I needed to calculate amount of time ON duty and that I was able to do. I now need to know how much time individuals have been OFF...
  5. etrain

    Limit Web Access Per User

    I have a single PC at home with XP Pro. I also have a daughter who loves the internet and I want to restrict her to certain webpages and be able to add more once I have checked them out. It is as much for virus protection as it is for the obvious protection. Anyway simply put is I want to...
  6. etrain

    XP Pro without additional options for user accounts

    I know this is an old post and it help a little but I have an additional question. I find where there are groups and I can add more groups, assign users to other group etc. Question is though how do define a groups access/restrictions? I added a group just to test and there is no way to define...
  7. etrain

    2 PC Home Network Setup

    Seems simple enough and I used the Network Wizrd to do that but which connection method do I chose? At this point I just want to connect the PCs with no internet access. I only have network cards with one connection. So which one do I chose? I chose the last in the selection list and then I...
  8. etrain

    2 PC Home Network Setup

    I have 2 PCs with XP Pro. I simply want to connect the PCs without spending the money on a router. Can this be done by running a network cable from one to other? At this point all I want to be able to do is share files and printers between the two plus I want to set up so I can play multiplayer...
  9. etrain

    XP Loaded on 2 PCs

    I have an old compaq PC that I thought was dead, something wrong on the motherboard side of the power cable, tried a few different things and could not get it running again. So I moved on and got a Dell with XP pro. The old hard drive I loaded XP Pro using the Reinstall CD that came with the...
  10. etrain

    Fair Royalty and Code Ownership...

    Forgot to add. I also have my current job to consider. I do not want them to have any rights to this product. I know that means keeping my company out of the loop completely but what other steps should I take? What type of details should I keep track of for my home development time? Just time...
  11. etrain

    Fair Royalty and Code Ownership...

    I may have an oppurtunity to work with a friend to develop a software application that he has already noted he would eventually like to sell. I would be the developer and act as a business analyst as well. Working with him to gather requirements and I am sure I will have my own ideas to lend...
  12. etrain

    Automation-Attaching OLE Object to Email Document via forms.

    I found, not sure where now, the code needed to get the document location. You are right it does not work for embedded but it does generate a location for the embedded ones but it is not a real location. So I had to make some assumptions with the what the locations might be to avoid any embedded...
  13. etrain

    Automation-Attaching OLE Object to Email Document via forms.

    I have a form where a OLE Object exist. I am wanting to be able to create an email document and attach this document stored as a OLE Object to the email. I can get the email document created just fine and I can even attach things. But how do I attach this document stored in the database. The...
  14. etrain

    Email File As Attachment

    Never mind I answered the question myself. Without the references it does not know what olByValue is so it appears to be defaulting to 'olByReference' which is linking it instead. I changed olByValue to '1' and it works as intended now. I went ahead a created a variable called olByValue and set...
  15. etrain

    Email File As Attachment

    Hi danvlas, This was great for me to come across. I got it working but something interesting is happening. If I use this code below making sure I have the right referernces it works just great: Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem Set objOutlook =...
  16. etrain

    Access 2k BackEnd to Oracle 9i

    I am wanting to move an MS Access 2k backend to Oracle. I want to do this as simply and easily as possible. I do not plan on improving anything, it is a straight do not change anything except make the Front End work with Oracle. I plan on just using ODBC Linked tables, not ADO. The only problem...
  17. etrain

    How to Share Subreport Data with the Main Report

    Ok so when you say "...prior to executing the subreports." What, where or when is prior? I put it in just about every place in the main report possible and nothing works. Maybe I just don't understand the syntax or something. Here is what is on the subreport: Shared stringVar ModName...
  18. etrain

    How to Share Subreport Data with the Main Report

    This Subject may look familar and that is becuase it is the same subject line of something in the Crystal Knowledge Base. It however does not answer the questions to my problem. I have a main with 7 subreports. There is grouping done on the main report and via the subreport links my detail from...
  19. etrain

    Number of Concurrent Users

    I will try that. Thanks. It is more of a rhetorical question but why wouldn't there be a place on the Enterprise Management Console to set this timeout? Remember the Past, Plan for the Future, yet Live in the Present for tomorrow may never come. -etrain
  20. etrain

    Number of Concurrent Users

    Lanfield said above: "i was able to get a patch that let me reset the default timeout from 20 min to whatever i deemed reasonable. i went with 3 minutes. so any time i had more than 3 min of inactivity the license released" We are having a problem with too many users and the company...

Part and Inventory Search

Back
Top