Search results for query: *

I am trying to use Microsoft CDO For Windows 2000 Library (cdosys.dll, version 6.6.6001.18000) for sending email from an Access 2007 application. Here is my code, somewhat altered for readability etc: Dim oCDOMessage As New CDO.Message Dim oCDOConfig As New CDO.Configuration...

In a .NET 2.0 Forms application, I want to open a Reporting Services report using the default viewer application for the report content type, e.g. MSExcel. I start a process using the System.Diagnostics namespace, specifying the report http address as file name. Internet Explorer starts up and...

Hi, I have a form which I use as an MDI child. When the menu in the child has merged with that of the MDI parent the merged menu something like this: --File [from MDI parent] | --CurrentObject [from MDI child] | -- Undo (Ctrl+U) When i try to use the shortcut key (e.g. Ctrl+U) assigned...

Hi! After my form has been opened I need to check whether or not it was opened using Show() or ShowDialog(). Does anyone know if this can be checked using a built-in property or if I have to shadow ShowDialog() and remember myself that the form is modal, as in: public shadows sub ShowDialog()...

I'm using Crystal Reports .NET in Visual Studio 2003. In order to load a picture into each detail section of one of my reports, I read that I need to handle the Section Format event. I have found code that shows how this is done. The question is simply: How/where do I write an event handler...

I'm using Crystal Reports .NET in Visual Studio 2003. In order to load a picture into each detail section of a report, I need to handle the Detail Format event of one of my reports. Question is simple: How/where do I write an event handler for the report events?

On an invoice, I need to use an OCR-b font (which is fixed width). So I went and purchased a font and it looks great in design and also in other apps like MS Word. The problem is that when I run the report, it seems to "forget" that the font is fixed width. It of course needs to be...

I'm new at .NET and building my first site, so I'm wondering if there's a nice way of using resource dll:s for data display in, for example, a server side DropDownList control. Here's what I would like to do: I store some product category data in a database and want to let the user choose items...

I'm trying to create a new db, specifying the FILENAME. This works great, except i need to do it through osql. When I do, SQL Server seems to ignore the FILENAME and creates the db in the default data folder. Does anyone have any ideas? SET @sSql = 'CREATE DATABASE ' + + @sDB_Namn + '...

Hi! I need to pass the name of the DB as a parameter from a stored proc to another, but for some reason I can't get it to work. When I run the code below, the string 'db_name' is passed, not the database name. It seems SQL server converts db_name to 'db_name'. Any ideas? EXEC dbo.usp_Logout...

I use the Internet Transfer Control in an Excel form and can't get the Execute method to work properly. With OpenURL everything works fine, but I have to use Execute in order to be able to send an HTTP header (user-agent). Anyway, my problem is this: The StateChanged event of the control never...

Hi! I have an NT4 domain server and win9x clients. Until today I've used an ISDN router for DHCP and web access. All these devices have been connected to a hub and everything has worked fine. Today I replaced the ISDN router with an ADSL router. Now the win98 clients can't access the NT4...

Hi! I have an NT4 domain server and win9x clients. Until today I've used an ISDN router for web access. All these devices have been connected to a hub and everything has worked fine. Today I replaced the ISDN router with an ADSL router. Now the win98 clients can't access the NT4 server, but the...

Hi! I have an NT4 domain server and win9x clients. Until today I've used an ISDN router for web access. All these devices have been connected to a hub and everything has worked fine. Today I replaced the ISDN router with an ADSL router. Now the win98 clients can't access the NT4 server, but the...

I have four tables; ES, ED, RC and CA. I need to make the following joins in a query: ED -- ES ES -- RC CA -> ES I.e. I always want all records from CA returned. I know i can make the inner joins first as a separate query, but does anyone know if there is a way to construct this as a single...

I´m new to sql server so maybe this is a really easy one... I´m developing a VB app and have a server on which I need to dynamically create multiple databases. This is not a problem, I can do that in Transact-SQL. The problem is that I need to create a set of sp:s, tables and views in the new...

I writing an app in which i will create large ascii files. These files are then to be put on cd:s. Since I dont want to make the (not so comp experienced) users do the file-copying manually using for example DirectCD, I would like to record to the CD from code. Does anyone know a good way of...

I have a class module in Access, whose objects hold a connection to an SQL7 database. I have one database per object plus a database for administering the other ones. When I want to delete an object permanently, I close that object´s connection to its db, set the object to nothing and then use...

I have a class module in Access, whose objects hold a connection to an SQL7 database. I have one database per object plus a database for administering the other ones. When I want to delete an object permanently, I close that object´s connection to its db, set the object to nothing and then use...

Why won´t this work? I´m trying to add a new record in an sp and return the new ID to an asp page. On the row with the Execute-command in the asp code I get the following error message: Microsoft OLE DB Provider for SQL Server (0x80040E07) Error converting data type varchar to int Heres the...