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!

  • 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: Trudye
  • Content: Threads
  • Order by date
  1. Trudye

    SQl Syntax error on Case ()

    I am trying to convert this query from Oracle to Access. I am getting an error Syntax Error 'Missing Operator" in query expression 'Case When...' Does anyone have any idea what is wrong with the syntax in this query? Thanx, Trudye SELECT R.RETAIL_CNTR_NUM, I.VIN_NUM , I.LEASE_ACCT_NUM...
  2. Trudye

    VB Programmer with an Oracle SQ question

    I have inherited this (sub) query from a Guy who coveted his work. I have figured out everything else except I cannot figure out what the (+) is for. Because of the field values he could not have been adding the fields. Does anyone have any idea what (+) means and how it would translate to...
  3. Trudye

    Send command via RUN

    Hi Guys, does anyone know the format for sending messages to another PC usng RUN (on the Start menu). I cannot for the life of me remember the command which is embarassing because I do remember it is a very simple command. Thanx Trudye
  4. Trudye

    On Behalf Of problem

    I thought I had set everything up right but.... I went into Tools; Options; Delegates, I added my name to the Delegates list. Shouldn't I then be able to send emails with "on behalf of" in the FROM box? Is there something special I have to do when I enter the From. Note: The mailbox I'm...
  5. Trudye

    CDO - Return Receipt

    Hi Guys, I have a question about CDO. For some strange reason CDO is causing Outlook to produce a 'Request a Read Receipt' from each recipient. Does anyone know how to turn this off, or how we got outselves into this mess? Everything else is working fine not errors, no messages, everyone is...
  6. Trudye

    Can't get rid of decimals places

    Hi Guys I can't seem to get rid of decimal places on my report. Two decimal places show up on the report the output should not show decimal points. In the table the field(s) are defined as Single; general; zero decimal places. On the ouptut report the fields are defined as general, zero...
  7. Trudye

    Crosstab Query Question

    Hey Guys, I have a question. I have a table that has two fields that need to be summed in a Crosstab query. Is there a way to accomplish that?
  8. Trudye

    CSTR function not working

    I have a User that receives a *.CSV file daily. When the file is opened (in Excel) some of the values become invalid. There are alpha values in a numeric field (ie. 0907C). I wrote the code below to change all the values in that column to string/text but it is not working. The original format...
  9. Trudye

    First page of Report is Blank?

    Hi Guys, I have what should be a no brainer. Only my page header prints on the first page of my report. There is not Force Page setting anywhere in the report. Can anyone think of a reason why this is happening? Thanx much
  10. Trudye

    Syntax error (comma) in query expression

    I am receiving the msg: Syntax error (comma) in query expression. I am sure it's a Stevie Wonder error but I can't see it. The error denotes it is in the Where statement. Curr_Rgn is defined as a string expression. strSQL = "SELECT Left([NMAC DIST],2) AS Rgn_cd, EOLDLR.NMAC_SLS_DIST_CD...
  11. Trudye

    Creating Reports for Different Regions

    Hi Guys, I'm not sure if I am in the right forum, but here goes. I produce a report that prints every region in the company. The report is being output using PDF. Unfortunately PDF will not get me append a region number to the report name. I thought of creating a report for every region but I...
  12. Trudye

    Totaling a Crosstab

    Hi everyone I'm having a problem with generating totals in a report based on a crosstab query. The report I am trying to generate must have Division and National totals. I created another crosstab to generate the totals and tried to use it as a subreport. I was able to link it but when I tried...
  13. Trudye

    Date criteria not inclusive

    I added the following criteria to a date field within a query. I am getting all of the dates I requested except for the last day. Rpt_start_date = 09/01/2005 enddate = 03/31/2006 I am getting all recs up to and including 03/30/2006. Any ideas why I am not getting 03/31/2006 and how I can fix...
  14. Trudye

    Adding Cols - Excel

    I am trying to add two cols (C/D) and place the sum in col G for an variable number of rows. I tried running a macro but the code it rendered was not useful (or at least it made no sense to me). I ck'd FAQ but most of the hits were for Access. Can anyone point me to a useful thread?
  15. Trudye

    Importing an XML file Into Excel 2003

    I finally figured it out. This is one way to pull an XML file into Excel, you must be running MS Office 2003. I am sure there are better ways but here is what I did. ActiveWorkbook.XmlImport URL:="X:\Pre-Sale Inspections\outgoing\" & TodaysFile, ImportMap _ :=Nothing...
  16. Trudye

    Error msg on ODBC import

    Hi Guys, I have asked this question in another forum but did not receive and answer. I also ck'd FAQ, found the question from 3 differnt subscribers but not answers. And since I always get GREAT answers here I thought what the heck it can't hurt to ask. I am receiving 2 error msgs: Data file...
  17. Trudye

    Import error Msg

    I am receiving 2 error msgs: 1. Data file 'X:\Pre-Sale Inspections\outgoing\AT_20060320_042005.XML' not found would like to connect to 'X:\Pre-Sale Inspections\outgoing\AT_20060320_042005.XML' instead? Weather I click yes/no a second msg appears. Dialog box 'Pls Enter MS JET OLE DB...
  18. Trudye

    Deleting in Excel

    Hi Guys, I am trying to delete all the rows preceeding the row that has 'o1cr' in the first 4 bytes of col 'A'. However it seems to be deleting every other row (all even number rows). The first row is a hdr row and as you can see I skip that one by ck'ing for the literal "AccountNumber". Any...
  19. Trudye

    From XML tp Access

    I have a client that receives an XML file, that contains two files. I need to seperate the file(s) and read them into Access. Has anyone been successful doing this in the past? Can you please tell me how you accomplished this? I am not an XML programmer I am a Access/VBA, with a limited...
  20. Trudye

    File Copy - Variable name

    I would like to copy a file from one folder to anoher one, I have done it before using .bat. However this time the filename changes daily. Is there a way to do it in VBA? Thanx, Trudye

Part and Inventory Search

Back
Top