Search results for query: *

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

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

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

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!

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!

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

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!

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

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!

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

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

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

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

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!

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!

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!

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

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

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!

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!