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 Chriss Miller 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. mikemcginty

    Saving Only Selected Outlook Attachments

    The following caode saves all attachments in an email but how do I save only the selected (highlighted) attachments from an email Sub SaveAttachments() Dim myOlapp As Outlook.Application Dim myNameSpace As Outlook.NameSpace Dim myFolder As Outlook.MAPIFolder Dim myItem As...
  2. mikemcginty

    Retrieving Specific Records From 3 Tables

    Is this heading in the right direction (even though there is a syntax error)? SELECT Table1.ID1, Table1.Certificate, Table1.Subject, Table1.OwnerName, Table2.ID2, Table2.Priority, Table2.Complete, Table2.Budget, Table2.Actual, Table2.Forecast, Table3.ID3, Table3.WorkStatus, Table3.ArchiveBox...
  3. mikemcginty

    Retrieving Specific Records From 3 Tables

    I am having great difficulty finding the correct SQL statement to retrieve data from only the following records (ie the maximum ID2 and ID3 records for each ID1) from these three tables. ID1 ID2 ID3 1 4 3 + data 2 2 2 + data 3 3 3 + data 4 3 4 + data...
  4. mikemcginty

    Find the Physical Path of a Mapped Network Drive

    Thanks Hypetia The function only returns \\servername\PFolder1\PFolder2\ but does not show the physical drive (ie J:\PFolder1\PFolder2\) Mike When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!
  5. mikemcginty

    Find the Physical Path of a Mapped Network Drive

    Thanks taupirho I did find similar code elsewhere and tried it but it didn't work. It returns a blank string. When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!
  6. mikemcginty

    Find the Physical Path of a Mapped Network Drive

    Is there any way in Visual Basic of retrieving the physical path of a mapped network drive? I have tried FileSystemObject.GetAbsolutePathName but this only returns the mapped path For example if physical drive J:\PFolder1\PFolder2 is mapped to Q:\. (Note: J:\ does not show in Windows Explorer...
  7. mikemcginty

    Running a VB Application from MS Office Application Menu

    Thanks I wasn't sure if I needed to convert my VB application into a dll or something first. When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!
  8. mikemcginty

    Running a VB Application from MS Office Application Menu

    Is there a way of adding a custom button to the main menu of a MS Office product (eg Outlook, Word etc) which when pressed will activate my VB6 application? I have read about creating an app as a COM add-in but was hoping there is a simple way. Thanks Mike When you call out for help in the...
  9. mikemcginty

    Retrieving Database ID in TSQL

    This may be simple but I just can't find the solution How do I programmatically (via TSQL) retrieve the DBID of the SQL database I am currently connected to? Regards Mike When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!
  10. mikemcginty

    Incorrect Program Menu Paths using P&D Wizard

    I have a problem with the P&D Wizard relating to setting up the Icon Groups on the Start Program Menu. After installation, the menu path of the Help files below is set to $(AppPath) and not $(AppPath)\Help. Also the path of menu item Uninstall is set to $(AppPath) and not $(WinPath). The...
  11. mikemcginty

    Database ID

    How do I retrieve the ID of the SQL database I am currently connected to? I want to use sysprocesses to find out who is connected to the database but need to filter out user_names which are connected to other databases. Regards Mike When you call out for help in the darkness, and you hear a...
  12. mikemcginty

    Problem with IDENTITY_INSERT when setting a Column Identity

    Just in case anyone is interested I read somewhere that IDENTITY_INSERT is only valid for one table per session (I presume this is an SQL session) I resolved this by executing the separate chunks of sql script between and including BEGIN TRANSACTION and COMMIT but removing any GO statements...
  13. mikemcginty

    Problem with IDENTITY_INSERT when setting a Column Identity

    After importing Access tables into SQL the primary keys and identities are not set so I wrote a VB6 program to execute script to create a table with primary keys and identities, copy data then drop the original table (as per Enterprise Manager script). As can be seen below the first table...
  14. mikemcginty

    How to get XP-style controls with VB6

    I had problems with the manifest solution. Check out the free controls at www.innovasys.com Mike When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!
  15. mikemcginty

    Return Last Record in a Table

    If SELECT TOP 1 returns the first record in a table, how do you return the last record in a table? Thanks Mike When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!
  16. mikemcginty

    Problem with SQL Statement (from Access)

    Found the problem It was a small test where I was trying to move around a forward only recordset. Thanks indrahig When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!
  17. mikemcginty

    Problem with SQL Statement (from Access)

    Thanks indrahig I changed the date format and now get the following error message Error (-2147217884) Microsoft OLE DB Provider for SQL Server - Rowset does not support fetching backward. Any ideas? When you call out for help in the darkness, and you hear a voice in return, you're probably...
  18. mikemcginty

    Problem with SQL Statement (from Access)

    I have an sql statement returning records from three linked Access tables based on a date range and priority. I am porting this across to SQL Server. The following returns no records but runs ok in Access. I am new to SQL Server. Can anyone tell me what the problem in the sql statement may be...
  19. mikemcginty

    New Field Padding Problem in Access

    Thanks Peter I will try that Mike When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!
  20. mikemcginty

    How to add a new button to Windows Explorer Toolbar?

    My app actually enhances Windows Explorer therefore to make it integrated would be a big plus Mike When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!

Part and Inventory Search

Back
Top