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: *

  1. DarenNM

    OpenDatabase problem

    I think you will find that the database engine needs write access even if you don't. I've encountered this problem before, and we had to copy from the CD to a harddrive and take off the read-only flag (as nicsin said). I don't know if anyone knows of a workaround? Different database drivers...
  2. DarenNM

    need help creating reset button

    Have a look at "Unload", and "Show" in the help. You might want to have the timer-reset functionality on a separate form to the one you want to re-initialise. Hope this helps Regards Daren Must think of a witty signature
  3. DarenNM

    declaration of global array

    Hi cjac I don't think this is the case. If your array is declared globally and you change the dimensions and populate it, the data will be there for all procedures. I'll just try this to make sure.... Yes, I declared an array in a module and used a subroutine in a form to resize it and fill...
  4. DarenNM

    problem with an english article

    From specters,if a wish for thing and a thing passed hoping for should come to a man. Will he not welcome it the more. Therefore it is more welcomed to meat and gold. At less beer brings back my desire of old." A change in punctuation and some extra letters might help here: "From...
  5. DarenNM

    Building and XML Document

    I don't know about a "best" way, but I used Microsoft's XML SDK to write an application which creates XML documents in a specific format. It took a little while to get my head around first the XML concepts, and then Microsoft's objects and methods, but it was worth it (for me). You...
  6. DarenNM

    Sending email using MSOUTL9 library with Office SP3 causes error

    Hi Check out faq222-2392 Getting around Outlook Security Patch Hope it helps. Regards Daren Must think of a witty signature
  7. DarenNM

    Read envrionment variable

    You're welcome ! Must think of a witty signature
  8. DarenNM

    Read envrionment variable

    You can use Environ$("EnironmentVariableName") e.g. strPath = Environ$("Temp") Regards Daren Must think of a witty signature
  9. DarenNM

    How do I find out which Form Is Open?

    Screen.ActiveForm should give you the form that currently has the focus e.g. Screen.ActiveForm.Text1.SetFocus Hope that's what you are looking for Regards Daren Must think of a witty signature
  10. DarenNM

    XML from AS/400 into ADO recordset?

    The book I bought was "Beginning XML 2nd Edition" by Hunter, Cagle and a few others, published by Wrox. It has a chapter on the DOM as well as an appendix which lists the DOM interfaces. I found it very useful for this, and if I need to go deeper into XML there is a lot more in the...
  11. DarenNM

    Open an Explorer Window and Wait for it to close

    Check out "ShellExecuteEx" and "WaitForSingleObject" API calls. There are plenty of examples on the web and probably on TT too. Hope that helps Regards Daren Must think of a witty signature
  12. DarenNM

    XML from AS/400 into ADO recordset?

    Hi Brad As part of my current project I did this the other way around - I extracted data from a database and wrote it to an XML file. I got a book on XML (although there are plenty of sources on the web - I just prefer books :-)) and used some code examples from the web to create a basic XML...
  13. DarenNM

    What happens to DLLs when you install a program?

    I believe that the DLLs do get over-written. It could cause problems with other applications that can't use more recent versions of the DLL - it depends on whether the DLL has been written to be backwards-compatible I suppose. I think the various versions of Windows have different strategies for...
  14. DarenNM

    How to create XML Document

    I think vb5prgrmr was right - it was the usual VB " problem. What you did should have worked fine once the quote-marks were sorted out. I have used the same method as you, I just used single quotes as delimiters: [/code] Set xpProcIns = .createProcessingInstruction("xml&quot...
  15. DarenNM

    XML from AS/400 into ADO recordset?

    From what I have read, the XML file needs to have a specific format for it to be opened via ADO. Do you absolutely have to open it in this way or could you open it via the XML DOM and parse the contents into a database? Daren...
  16. DarenNM

    Sorting db table

    You should be able to sort using the crystal report's sorting options. If you've based the report on a query (or view) you should be able to have the query perform the sort for you. Hope that helps. Daren Must think of a...
  17. DarenNM

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    It is easy to add Win32 API functions to VB. You need to find the declarations for the functions you want and add them your project. Look up "Accessing the Microsoft Windows API" in the help. An excellent book on the subject is Dan Appleman's "Visual Basic Programmer's Guide to...
  18. DarenNM

    Learn to write viruses to protect against them?

    If one of your neighbours was studying explosives and booby traps, would you believe this was a legitimate interest? If he was part of a Royal Engineers mine-clearing team I would. I think you could apply some of the arguments here to many jobs e.g should we train people to be locksmiths in...
  19. DarenNM

    Decimal Problem

    BradB It helps if you indent code when it is inside &quot;If...Then&quot;, and align each &quot;End If&quot; with its &quot;If Then&quot; as it makes the code easier to read: If txtAmountOfTime.Text = &quot;&quot; Then txtAmountOfTime = 1 Else num2.Text = txtAmountOfTime If num1 And num2 <>...
  20. DarenNM

    Application deployment

    When you say 'run from the server' do you mean you will store your application on the server and users will execute it from there? If that is the case then you don't need to make any changes, just place the latest version on the server and make sure all of the users' short-cuts point to it. If...

Part and Inventory Search

Back
Top