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

  • Users: djwatts
  • Content: Threads
  • Order by date
  1. djwatts

    Export to Excel

    Hello, I need to find the best way to export a selection of data to excel. Using the docmd.transferspreadsheet command doesn't seem to be an option as I need to export filtered results. At the moment this data can be viewed on screen using a form in data sheet view. This is important as I...
  2. djwatts

    Outlook object library

    Hi, I've got a database that uses the outlook object to add calendar entries and send automated e-mails. This works fine in Access/Outlook 2003, however I need it to support Access/Outlook 2000 aswell. In the project references I have the Microsoft Outlook 11.0 Object Library Microsoft CDO...
  3. djwatts

    A different OWA problem

    Hello, Bit of a wierd one here, OWA stopped working shortly after it was installed. Haven't had time 'till now to get it sorted out. I've been through so many articles online and none seem to have my specific problem. We are part of a larger exchange organisation, we are a sub domain inside...
  4. djwatts

    Save Comments

    Hi All, I'm an experianced VB & Java programmer but until now haven't really applied this to web pages. For a charity event I want to put a comment box on our site for feedback. Only to capture Name & Comment fields > preferably to store the info in a text file. Is CGI the right route to be...
    • djwatts
    • Thread
    • Replies: 4
    • Forum: CGI
  5. djwatts

    LDAP Query "OR"

    Hi, I'm normally ok writing SQL queries and whatnot but LDAP seems to have a bit more to it (i guess because its lightweight). I'm trying to query AD to return two users from a domain by their names. I can't seem to get the OR function to work using the pipe | operator. Is this right or am I...
  6. djwatts

    Fixed Width File Editor

    Hi guys, I'm getting loads of txt files in fixed width format, many of which need positions modifying slightly prior to loading. Anyone know of a small app that can easily edit these files? Thought I would post in the VB forum as us developers always have handy little apps to help us with our...
  7. djwatts

    Dynamic Distribution List Members

    Hello, Does anyone know of a way that users can check the members of dynamic distribution lists through outlook??? Thanks for any help!
  8. djwatts

    Send From Dynamic Distribution Group

    Hello All, We have an OU for our income recovery department, based on the users in this OU we have a dynamic distribution list so people can mail to income.recovery@xyz.co.uk, however the people on this list need to be able to reply from this address so any replies they send will come from...
  9. djwatts

    Select Distinct - Most Recent

    Hello all, I am doing a data migration from an odbc data source, so it's not my design. I have two tables (well about 200 in total). Called 'PERSON' and 'TENANCY' for simplicity 'PERSON' [PrimaryKey - 'PERSON_REF'] contains details on the tenant and inherently 'TENANCY' [PrimaryKey -...
  10. djwatts

    Renaming AD accounts

    Hi, Our finance manager has left the company and his replacement has been here for a while, when he joined to get him working quickly we renamed the old managers accounts. This seems to have changed most references to the name, except i.e if he has a spreadsheet open and someone else tries to...
  11. djwatts

    Access "Exclusive" Command Line???

    Hi all, just wondering if anyone knows the command line to add on the end of a shortcut path to open a database exlusively? I tried /exclusive but that didn't work Thanks
  12. djwatts

    C++ noob

    Hi All, This is the first time i have had to leave the comfort of visual basic and tackle a c++ project using VC++ .NET I am pretty good with VB and the windows enviroment, but I'm getting a bit stuck with .h and .lib files I'm trying to link my program to include the powrprof.h header file...
  13. djwatts

    Non-Duplicate Records

    Hi All, I have a progress database that I'm having to export into fixed width text files for data conversion to a new system. So Im using access. I have a table that has many duplicate values in one of the reference fields. I need to pull all of the records that only have one occurrance in...
  14. djwatts

    SQL - Pull two records into one

    Hi, I need to be able to pull data from two rows of the same table into one row i.e. CONTRACT_NO;PERSON_NO 100;12345 100;12346 101;65432 101;65431 into CONTRACT_NO;PERSON1_NO;PERSON2_NO 100;12345;12346 101;65432;65431 I know it goes against everything relational databases stand for but we...
  15. djwatts

    Windows ACPM API

    Hi, Does anyone have any experience of using the windows Advanced Configuration and Power Interface APIs. Can't seem to find much on the web on this topic, except in Delphi (which im not that familiar with). Thanks for any help or links DW
  16. djwatts

    Exchange System Manager - Error

    I receive the following error message when trying to expand the Public Folder tree in the Exchange System Manager. "an existing connection was forcibly closed by the remote host" Facility: Win32 ID no: c0072746 Exchange System Manager This results in the Public Folder not being viewable within...
  17. djwatts

    Start Remote Process

    Hi, Does anyone know how to start a process on a remote machine, I have a vb script that can achieve this using wmi. Are there any API calls that can do the same??? Regards
  18. djwatts

    VB Controls - Background Transparent

    Hi Does anyone know how to make the background of a control transparent so you can see the form's picture??? Thanks
  19. djwatts

    RemoteRegistry Set Value

    Hi All, I have written some code to connect to remote registry's, enumerate keys from HKEY_USERS and modify a value in all the user profiles. All the API calls are returning success but when I check the registry, the values havn't changed. Any one experianced this??? Public Function...
  20. djwatts

    Determine if PC online

    Hi, does anyone know the best way to determine if a pc is switched on. Some sort of ping, is there a quick way to do this???

Part and Inventory Search

Back
Top