Search results

I'm going to try so set all the nulls in my pivot table to zero. Maybe that will preserve my formatting.

Something else that may be of note. I run many charts like this, columnar charts don't suffer from this at all. Just the line graph I described above. -Thanks edit: Actually there is a similar error here as well. If I run the filter and there is a zero, or null in any of the fields...

I think you mean: CurrentDb.Execute "UPDATE [TableName] SET [NewFieldName] = 'Near Miss' WHERE [ExistingFieldName] = 'Near Miss';" CurrentDb.Execute "UPDATE [TableName] SET [NewFieldName] = 'Actual Event' WHERE [ExistingFieldName] <> 'Near Miss';" But I got the picture :) THanks!

What's a form? lol

Unfortunately I won't be able to do this as this query is ultimately based off of a table that is full of personal info. Maybe I can describe the problem better? I create a form that defaults to pivotchart view, and pull in relavant fields in form view. I use a pivot chart view to pull...

Where do I put the command button?

Bump. This is so frustrating

No I haven't And I dont plan on deleting the old field, just removing the option to select "Near Miss"

No, I want to remove "Near Miss" as a selection on the entry form under that field and have a new field for it. Near Miss is currently buried in a combobox where it doesnt belong.

Hi all, I want to create a new field that draws from another field in the same table. One possibility is "Near Miss" in the existing field. For every record where "Near Miss" is in the existing field, I want to have "Near Miss" in my new field. In all other cases I want "Actual Event"...

Hi all, I have a subform based off a query that displays data in a pivot chart. In the pivot table view, I have it set up to give me the count of records per months over time for several categories, displaying in a line graph per month. The first time I use it, it works perfectly. But...

Sorry to repost, but Im not sure where it belongs. Hi there, I have a form that filters a subform based on a query. The subform's default view is pivot table and allows me to produce charts that I want to export as picture files and eventually add into .ppt presentations. I get a type...

Hi there, I have a form that filters a subform based on a query. The subform's default view is pivot table and allows me to produce charts that I want to export as picture files and eventually add into .ppt presentations. I get a type Mismatch error when I hit my export button and I'm...

How did the list get in alphabetical order in the first place? Right now it's correct except this one entry. Could I just delete and remake it?

This list is in it's own table, and is only one field. Sorted alphabetically.

I don't understand that question, but I don;t think I can use rowsource, since that field is dependent on the previous combobox. Sorry if I'm a doofus.

Hi there. I have a cascading combo box based on a table of specific types of incidents. So: If you enter x into combobox A, you get list 1. Enter y into combobox A, you get list 2 and so forth. I want to update list 2, adding in a new selection. It is based on a table on the backend...

I built a database acouple years ago, but having had to convert it from a series of excel files to an access database. Almost all of the information is stored in a single table. Is there a simple way for me to pull apart this table into different categories? Would this help speed up the...

THis code seems to open to a blank page. Its the correct form and shows up in design view, but the page is blank when you look at it in form view. hmm. -Z

This seems to bring me to a completely blank form. It's the correct form when you switch to design view, but in form view is completely blank. Can't see any labels or controls or anything. -Z