Search results for query: *

Hi, I've seen and used code here that allows me to conditionally set formats for values in a worksheet. (Thanks to all who posted code.) Currently I use VBA to create a pivot table and change the color of cells (outside of the pivot table) based on its value. Example: Cell G5, which is...

Using MS Access 2003 - I want to add a new field to a "linked" table and then populate the field with data. Why am I doing this? Another department drops a database onto my server each week. I want to add new fields to this database so developers can use them. I can't put any code in the...

I've seen several sample of code that aligns columns, but they all use 'unbroken' lists. Currently this is done manually. By cutting and pasteing L/M to a matched I value. Insert a row where there is an L value and no I value. etc. Very error prone. Note: I can't copy this data, sort it, and...

I need code that will read thru a directory and convert all the .csv files to .xls (Excel2003) right back into the same directory. I don't need any interaction with the user except to provide the path to the csv files. (If the xls file exists it should be overwritten.) Appreciate any help...

I've looked for the answer to this but couldn't find anything (I may not be looking for the correct keywords.) This is a two-part question Using Access 97: 1) When I run this in a form I get a caption that does not match what is going on in the database. (i.e., Caption is lagging execution of...

re archived thread705-1042294 Added a test for Null values. Public Function ReplaceinString(strSearch As Variant, strFind As String, strReplace As String) As Variant 'Description - Finds and replaces a string in a string by another string 'Author - Neil Gummow ' Modified - Mike Adel...

I've read dozens of posts in several Access forums but can't find an answer to this one. (Probably not using the correct descriptors.) Please read this entire post before responding. In another life I could write something like this: Select Max(Field1) WITH Field2, Field3, Field4 group by...

All, I'm trying to write a function to convert a YYYYMMDD date field to a real date. I would like to call the function and have it return a particular field as a date. I already have a generic function that works (see below). I want this one to be very specific and don't want to pass the...

Hi All, I'm using Crystal 10 to create a bar chart with monthly data for the year. (So I never have more than 12 months worth.) Everything was fine last year (I started in June). I just produced my first chart for 2005. Yikes! I got one bar, for January, that is 7-inches wide. How can I...

In a previous post (under data access) synapsevampire said: "I agree with Witchita, but I'd add to this that you're probably better served to create the Query in the Access database that retrieves the required data, and then base the report on the MS Access Query." This works fine when I run a...

In a previous post synapsevampire said: "I agree with Witchita, but I'd add to this that you're probably better served to create the Query in the Access database that retrieves the required data, and then base the report on the MS Access Query." This works fine when I run a report 'manually'...

I have the following situation: Access 97 linked via ODBC to Oracle db (not sure of version - don't think it matters). Dates are stored as character in format "yyyymmdd" (not my design). I wrote my first Access function as follows :) Function convertYYYYMMDD2Date(strDateField As String) As...

I'm using CR 9.2.0.448 against a MS Access database via a query. The query appears to work properly in Access. When I run my report CR opens the preview with 1 of 3 and displays the drill down on the left of the report. When I click the right arrow to go to page 2 is show 2 of 3 but then...