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 Mike Lewis 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. PaulDalyTT

    Using Impersonation in VB.NET 2008

    hmm, after some more reasearch and tring various other things it seems that it may not be possible to launch processes under alternate credentials from the Local System account. I have even tried shell out to a VBS script to execute Windows runAs command, but none of it works. I can't get the...
  2. PaulDalyTT

    Register DLL in the registry

    ok I think I understand now... You added the DLLs to your .NET build environment. Are these standard .NET DLLs or are you registering customised DLLs? Assuming they are standard .NET DLLs, then you dont need to register them on the client machine. Once the correct version of .NET framework is...
  3. PaulDalyTT

    Register DLL in the registry

    I'm sorry, i'm getting a little confused now. I thought your code already checks if the DLLs are registered? If they are not registered and you need to register them, you should be able to do that by passing the DLL file path to regsvr32 using the code above. I dont know what the path is for...
  4. PaulDalyTT

    Register DLL in the registry

    Yeah I think you are on the right track... So, 1. you program starts autmatically on bootup. 2. Your program checks if a DLL is registed. 3. If its not registered then it registers the DLL using the code above. To do this, all you need is the path to the DLL on the client machine. I can't...
  5. PaulDalyTT

    Register DLL in the registry

    I dont think it matters... you could just put DLL in your own application path and register it there....
  6. PaulDalyTT

    Register DLL in the registry

    Actually you could try run a Process rather than start a shell.... either should work. Process example below. (I think this is now the preferred method of starting external processes from VB) Note that the executing user must have permission to register DLLs. You dont need to worry about...
  7. PaulDalyTT

    Register DLL in the registry

    I know it's not exactly what you asked, but you could just shell out to regsvr32 to register the DLL.... cheers, Paul.
  8. PaulDalyTT

    Using Impersonation in VB.NET 2008

    Hi folks, Has anyone any experience in using impersonation in VB.NET? I have developed my own task scheuler which runs as a service under 'Local System' account on my laptop. The scheduler works fine and I can get the tasks to start as and when I need them. However, I would like to be able to...
  9. PaulDalyTT

    Code to extract data into spreadsheet not working

    I think the problem is with your connection string.. Not 100% sure what you need to set it to, but this example below works with Exel & Access 2003. note sure of Excel/Access 2007. It may be easier to use the query builder in excel to generate the quiery for you. You can then either refresh it...
  10. PaulDalyTT

    ProgressBar in Access...

    Eureka!! i commented out the DoCmd.echo lines in my functions and the form and bar now display perfectly. Thanks for all the help with this one guys. Tek-tips strikes again!! cheers, Paul.
  11. PaulDalyTT

    ProgressBar in Access...

    HI folks, Thanks very much for your help so far in trying to get this working. Much appreciated! In follow up to some of earlier questions (back at work now so can look at the app rather than try to remember!) application.echo is not set anywhere in my code. Should I be using it? I do have...
  12. PaulDalyTT

    ProgressBar in Access...

    Hi folks, Thanks for the replys... CautionMP: 1. PBMax is anywhere from 3 to about 80... so increment by one should be enough. I have allowed the app to run thru to completion so should have seen some update! 2. I dont believe I have changed application.echo anywhere, but will need to double...
  13. PaulDalyTT

    Appending an access table with linked excel document

    I do something similar in my own app, but I use the following docmd options to run the query... DoCmd.OpenQuery "APPEND_FINAL_01-TLF_TO_WEEKLY_FINAL", acViewNormal, acEdit Mabye give these a shot? I cant access imageshack from work so cant see your query, but if the query itself does...
  14. PaulDalyTT

    ProgressBar in Access...

    hi PHV, thanks for your response. I have tried adding DoEvents at the end of each of the 2 functions (init + increment) but its doesnt seem to do anything differently... The process still runs thru, but no update is visiable on the form... any other ideas? is putting DoEvents at the end of...
  15. PaulDalyTT

    ProgressBar in Access...

    Hi folks, First post on this forum. I finally hit a problem that an existing post here doesn’t seem to explain and help solve! Can anyone help me ProgressBar in Access? I have an Access 2003 application which does several steps 1. FTP files 2. Load files 3. Run ~100 queries on data 4. Produce...

Part and Inventory Search

Back
Top