Search results for query: *

Thanks but I have them displayed now. I tried to reference comdlg32.dll but get a message "can't add a reference to the specified file". If I try to register comdlg32.dll I get an error message concerning the DllRegisterServer entry point not being found and that my file may be...

I had comdlg32.ocx loaded. I tried to reference comdlg32.dll (can see it now) but get a message "can't add a reference to the specified file". If I try to register comdlg32.dll I get an error message concerning the DllRegisterServer entry point not being found and that my file may be...

I am browsing files from the References dialog box except .dll files are not being displayed so I can't reference them. There are being displayed in Explorer so the hidden attribute is turned off. Does anyone know how I can force these files to be displayed in the Browse option of References...

Thanks. I've found comdlg32.dll (the extra m was putting me off) but it's not visible in the References Browse file list. I can see it in Explorer as I got rid of it's hidden attribute but still can't see it in References. Quite annoying when I know it's there and still can't reference it.

Yes, I've added the component. My references all seem to be in order too. I've looked into it some more and I think that the problem might be that I am using commdlg.dll instead of commdlg32.dll. Do you know where I can get a copy of commdlg32.dll? My vb setup disks seem to have disappeared...

Does anyone know do the methods associated with a common dialog control differ depending on the version of vb being used? I have an application created with an earlier version of VB and when I try to compile it using v5 or 6, the common dialog methods in the code aren't recognised. Examples are...

Hi, I want to insert into a table on AS/400 using a sql statement embedded in Visual Basic. I am connecting to the database using ODBC. Could someone please tell me if the following statement will work. I'm presuming that regular sql syntax is fine but can someone let me know if I'm wrong (do...

Hi, I'm trying to open SQL Server and can't because the tempdb has been marked as SUSPECT. Does anyone know how I can repair the tempdb? Thanks in advance, Gillian

Hi all, Is there any way I can edit a DTS file? My problem is that I have an asterix in my source table pathname and I need to remove it or the transfer doesn't work. There are reasons why I can't create a new file and edit the path there. Has anyone any ideas? Thanks, Gillian

Hi again, I don't think my last post was explained properly. My problem is I'm connecting to a DB2 database via ODBC from VB. I think what the problem might be, is that the database doesn't have a logical name and so my connection string contains the path to the database. The path however...

Hi all, I have set up a ODBC DSN pointing at a DB2 database using the Client Access driver. When I run my VB application, it can't see the DSN (getting that message "data source name not found - no default driver specified...). I'm not at all familiar with AS/400/DB2. Are there any...

Mission accomplished! You people are great - thanks :-)

Thanks guys, Simon - I've looked at the Outlook object model and have actually figured out out to send a mail(!). I'm having problems though with the Attachment property. What syntax should I be using? The following code gives me an error message when I get to Attachments..... With oMail...

Hi all, Can someone tell me how to send a text file from within VB? Thanks, Gillian

I've never used the Profiler before so thanks for the tip Cal. The DTS option sounds promising too. Right now though I'm going to leave the dates as text fields. It seems to be working fine. I'll probably go back and look at it some more when I've more time. Thanks for all your help, Gillian

Thanks for the suggestions. Whether the Convert() returns 02/01/2000 or 01/02/2000 shouldn't matter though as there are records in the database for both. I know what you're getting at but in this case the problem seems to be something else. I'm sending the query through ODBC btw. I think what...

Surely though, if I have the Convert in quotes as part of the sql statement - then VB won't try to interpret it? It should send everything inside the quotes to SQL Server.

Hi, Can someone please help. I am running the following sql from the query analyzer and vb: select * from DWCSYPER where convert(datetime,CPFDAT) < '02/01/2000' Where CPFDAT is a field with datatype char. When run from vb, I get no records - when run from the Analyzer, I get one record...

Hi, Can someone please help. I am running the following sql from the query analyzer and vb: select * from DWCSYPER where convert(datetime,CPFDAT) < '02/01/2000' Where CPFDAT is a field with datatype char. When run from vb, I get no records - when run from the Analyzer, I get one record...

Here are some examples: CPFDAT CPTDAT 27/12/1998 23/01/1999 24/01/1999 20/02/1999 21/02/1999 27/03/1999 28/03/1999 24/04/1999 25/04/1999 22/05/1999 23/05/1999...