Search results for query: *

We're in the same boat. I figured a workaround for the "access denied" problem. Here is how to solve it (XP/2003): In the management console, find the fax service and open it's properties. On the Log On tab, select an administrator account for login. This is better than giving asp.net...

You only have to change your ORDER BY clause of your query. Replace the order by with diffenrent values depending of the choice of the user. Or use different reports to show your data. Hope it helps SC

I also had a problem about a similar situation. I was quite lost and your answer worked fine. I give you a star. Hope it helps SC

We used to have the same problem with french characters. We used to run a Stored proc to fix the problem. It replaced all special characters. Unfortunatly, I no longer have access to the SP. Hope it helps SC

SteveNapper: you can replace IIF with case in a SQL query. Hope it helps SC

Try to join the tables this way: Select A.des, B.df_date, C.nxt_date from A, B, C where A.id= B.id and B.id = C.id and .... (your other criterias) Hope it helps SC

Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long Hope it helps SC

hwnd can be used as: ByVal "variable" As Long You can read about a good api tutorial for VB at www.vbinformation.com/tut-api.htm There's a table for type conversion and API declarations. Hope it helps SC

It is released. You might want to subscribe to the VB.NET forum for further informations. Hope it helps SC

It's been a while since I worked with SQL Server, but the option to create DTS is available since SQL Server 7.0. Open the manager and select import/export wizard. You can select both source and target servers. Follow the on screen instructions. It's quite simple. Hope it helps SC

it's from shell32.dll You must have active desktop IActiveDesktop::SetWallpaper Sets the wallpaper for the Active Desktop. HRESULT SetWallpaper( LPCWSTR pwszWallpaper, DWORD dwReserved ); Parameters pwszWallpaper String value containing the file name of the wallpaper to be set...

when you substract two dates, the result is shown in days. You will have "Noncomplaint" only for 2 days and older.

Hi. I'm having a hard time to figure out what's not working. I need to have some "case... when" statement in a query to import data from an access Database to an Excel spreadsheet. I tried with a IIF statement and it worked great within Access. But the problem is that to import date...