Search results for query: *

The xp_readmail is for reading Emails in SQL inbox. I have Exchange Server handling the emails, not the SQL server. I would think that it should be some kind of sp or an API call to the Active Directory.

I have an Intranet site for IT Help Desk in classic ASP with a back end in SQL 2000. I also have an email account Helpdesk for external users to send requests and problems. What I am trying to do, is read all incoming emails from the Helpdesk email account and insert the Subject, Body...

I greatly appreciate your help, GMMASTROS! It worked like a magic! Thank you very much!

I tried it with just single quotes and still getting the same runtime error, "Line1: Incorrect syntax near '='". Any other suggestions? conn.Open "Provider=sqloledb; Data Source=acmedc1; Initial Catalog=OrderChecking; Integrated Security=SSPI;" sql = "SELECT tblHeader.PO...

CaptainD, Yes I tried it. When you put ' (single quote) in front like this "'XS'" VB comments everything after the quote out. But you are right it has something to do with SQL only liking single quotes and not double quotes. But the question is for is the right syntax to write it in VB? Vika

When executing the following SQL statment in VB6 I get Runtime Error Line1: Incorrect syntax near '=' I am using SQL 2000 as back end. Can somebody tell me what am I doing wrong? conn.Open "Provider=sqloledb; Data Source=acmedc1; Initial Catalog=OrderChecking; Integrated Security=SSPI;"...

Use common dialog control to print.

I need to know what version of the MS Access user has installed, and if user has more that one version installed, where is each version located. Does anybody know if I can get this information from the System Registry or if there a function I can use in VB? I will appreciate any suggestions!

I am using wininet functions to do FTP calls. The connection is working just fine, but when I am trying to use FTPGetCurrentDirectory Function to get Directory Name, the function returns False. Now that I got error, I am trying to figure out what error I got by using GetLastError() Function...

When you create an executable file it doesn't necessarily means that all the libraries are included. The error you are getting says that you are missing one of the libraries on the server. What you need to do is find out which library it is and register it on the server. I hope it helps.

I need to do an FTP call from local machine to the Unix Box. Does anybody have any sample code? or Know how to do it? I'll appreciate any suggestions.

Are you runnin report just by clicking on Print Preview or from a Command Button on the Form DateRange?

You need to add common dialog control on your form. On Click event do next: CommonDialog1.HelpCommand = cdlHelpForceFile ' Specify the Help file. CommonDialog1.HelpFile = "C:\Program Files\FebSoft\Oasis SE\DCS.HLP" ' Display the Windows Help engine...

Most likely your problem is in the Combo box data settings. What you need to do in this case is go in to the properties of the combo box. Go into the Data Tab, and change Bound Column property. This property sets which column from the combo box to save if you have more than one column shown...

In this case In means any of the following. The formula reads: If Month([CycleYearly_tbl]![Date])+1 equals any of the following then ... Does it makes more sense?

You don't need to create another text box to get the current date, like kerrigirrl says. You get the date with the Date() function at the same time as you copy the object. The only thing you might want to do is Format you current date, in case you don't know the system regional settings...

This is what you want to do 1) Create a Form with a text box (txtTable) where user can type in Table Name he wants to copy 2) Put a command button on the form 3) On Click event of thye Command Button put this code DoCmd.CopyObject , date, acTable, txtTable That should do it. Good luck!

I don't know if I understood you right. I guess what you want to do is create a form that will allow user to type in the start and the end date for your query. If so, then this is what you need to do. 1) Create a Form with two text boxes and a Command button. 2) Your query should look like...

You're very welcome! I hope I helped.

You should put your query into the ListBox.RecordSource property.