Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Vika
  • Order by date
  1. Vika

    Retrieve Email details from Exchange 2003 and insert into SQL

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

    Retrieve Email details from Exchange 2003 and insert into SQL

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

    Line 1: Incorrect syntax near '='.

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

    Line 1: Incorrect syntax near '='.

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

    Line 1: Incorrect syntax near '='.

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

    Line 1: Incorrect syntax near '='.

    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;"...
  7. Vika

    Print to File

    Use common dialog control to print.
  8. Vika

    How to find Access version in Visual Basic?

    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!
  9. Vika

    wininet calls problem

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

    RUN TIME ERROR 91...

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

    FTP Call

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

    report referring to a form and #name?

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

    Calling Help File from the MDI forms menu item.

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

    Report Data Problem

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

    formula question

    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?
  16. Vika

    Renaming a file

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

    Renaming a file

    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!
  18. Vika

    Displaying query results on a form/report

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

    Export to excel, Multiple listbox --> multiple worksheets

    You're very welcome! I hope I helped.
  20. Vika

    add records to a listbox

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

Part and Inventory Search

Back
Top