Search results

I'm using Access 2003. I need to embed in my macro, a command to export the select query data to an Excel spreadsheet. Is there an action or something I can use to accomplishe that? Thanks, Krazy (Bill) Kasper

Crystal Reports 10.0 - Summing-Grouping Problem Contract # 12345 has four machines (111, 222, 333, and 444) Contract # 67890 has two machines (999 and 888) Each machine has a “base amount” (e.g., Machine 111 has a base amount of 20,000) Each machine has multiple invoices (some have one invoice...

I have a formula in my Crystal Report as follows. It works fine except it doesn't identify records when Sum ({@ExcessUsageAsOfDecember31},{OptimizeIt.LeaseMasterContractId}) is NULL. I tried inserting IS NULL in several places but keep getting syntax errors. I appreciate it anyone can help me...

Using Crystal Reports 10 - I need to use a “formula” to calculate "Average Monthly Usage" for the past 12 months. My ODBC table.fields are: {FootageSummarySerial.FiscalYear} {FootageSummarySerial.FiscalMonth} {FootageSummarySerial.ActualUsage} My code so far is: IF...

UPDATE - Split name field Here's the latest... The structure is lastname, firstname, middleintital. There is not always a middleinitial. The code I'm using (follows) only gives me the middleinitial: local StringVar Array Names1:= Split({OptimizeIt.OrderRepName}, " "); If UBound(Names1)=3...

I'm trying to split a name field in my ODBC table into first name last name and change the case to "proper". The table field {OptimizeIt.OrderRepName} is one field formatted as lastname, mi, firstname I started using the following code which gives me the last name but not sure where to go from...

The Order Rep Names in my ODBC table appear as: Lastname, Firstname OR Lastname, Mi. Firstname I need to change them in my Crystal report to appear as: Firstname Mi. Lastname When I do the same thing in a VBA report my code is: Function ParseFirstComp(OrderRepName) As String ParseFirstComp...

I'm trying to set a formula in my report (Crystal 2003) to show that when a date is greater then or equal to 1/1/2009 OR if the field is NULL to print "LSE" else print "NOT". I'm having trouble with the following formula as it doesn't like the ISNULL: IF {LeaseMaster.LeaseDispositionDate} >=...

Using Crystal Reports 2003 and accessing several database tables (via ODBC) I need to select all of the material ids associated with invoices that contain a specific material id. There are about 15,000 invoices that will contain approximately 70,000 material ids. (There is no restriction on the...

Thanks. I think that will do it. KK

I need to change the EmployeeName field in my report (based on a query) to Proper case and change it from LAST, FIRST or LAST, MI, FIRST (Results should look like:John Q Smith). The name styles in the source table vary as some are LAST, FIRST, MI; others are LAST, FIRST. Also, some are all...

Thanks for your input DCrake. I tried using the code you suggested but I get the Run-time error "Object variable or With block variable not set" and it points to the line qryNew.SQL = SqlFields & SqlSort Can you help me debug it? Here's the actual code: Private Sub...

Thank you all very much for your help. The code is now working well. The solution was quite simple. I created a separate query for each "sort" button and used the following code (with a different query for each button): Private Sub SortOrder1_Click() List10.RowSource =...

I have a Multi-Column List Box named List10 that is populated via a query (qry_OptimizeIt3). I’m looking to create three Buttons, one above each column that will re-sort the list in ascending order based on the specific column. For example: FIRSTNAME LASTNAME AGE John Doe...

Multi-Column List Box - Select Multiple Items Thanks for your help. However, I only partially understand your suggested code. Although I can select multiple reports, it doesn't return just the "selected" reports; it returns all of the reports. Also, it doesn't get the three specific fields...

I have a multi-column (3 columns) list box that works well to select one set of records or all sets of records (based on the first field in the list box). I need it to also select multiple sets of records (Multi-Select = Extended). I modified my code based on code I found on some Internet site...

Access 2003 – Multi-Column List Box – Select Multiple Items I have a multi-column (3 columns) list box that works well to select one set of records or all sets of records (based on the first field in the list box). I need to it also select multiple sets of records (Multi-Select = Extended)...

I am trying to define several categories of product (Parts, Bndl, E1, Ink, and Paper). The following are fields in one of my tables: MaterialId, MaterialDesc, and ProductHierarchy. I have the following VBA case statement that works well in my report. However, when I include two additional...

Almost there (I hope) Thanks for your help. (I couldn't use some of the code as it gave errors.) I am now at the point where I have the field displaying in my report. Here's the latest code. (F.Y.I. - I call the module into my report from the Control Source in an unbound text box named...

Thanks! By "Record Set" I presume you mean the table that houses the field (BillingType)? That being the case, my Record Set is dbo_InvoiceDetail If you mean something else, then how does it know in which table the field is located? Krazy (Bill) Kasper