Search results for query: *

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

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

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

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

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

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

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?

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

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

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

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

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

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

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?

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

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

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

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

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

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