Search results

It looks like we are in different parts of the world, so pardon my delay. The user clicks the filter on the pivot chart, located on the subform. Background: I have a subform where the user inputs a date range and clicks "go", which runs a query that then formulates the pivot chart for the...

I have created a database that tracks production by individuals. I have also created a report which includes a pivot chart to give the user a chart view of production. In the pivot filter of the chart I have associate names, where the user can click all, or individual associates, to see...

Put this code in the OnError event of the main nav subform. Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = -25357 Then Response = acDataErrContinue End If End Sub

Worked beautifully. I didn't even use your middle code there as I was using a PivotChart that dynamically changed based on a query. Did you turn the warnings back to True on form close event?

This brings up another question of mine: Is the different versions of Access the only thing that would make that error/corruption appear? It's all I have noticed when researching, but just had a colleague of mine try it (who has a different access version (14.0.6123.5001 (32-bit) to my...

I need a form to be on a server so multiple users (11) can access it. Earlier, I ran in to the SP1 issue where my VBA was corrupted, but I was able to recover the DB. I know I obviously need to split the DB in order to secure future data if something happens again (thankfully this was a...

Bump Bump.

I would like to know the same. I have date range boxes which dynamically change the design of a pivot chart in a form (and thus also the query the chart runs off of). I would like to disable or (preferably) automatically NOT save design changes before move to another tab, or clicking the...

I'm using the criteria quoted above (Well, the fixed version with the correct names) for the Date section of my query, and linking it to the two date range boxes on the form for its parameter. When the user changes the date ranges and populates the Pivot Chart, it changes the design of the...

Yeah I figured it out a couple mins after I posted this, that's exactly the issue. I do have another question, though. I use these Date Range boxes to populate a pivot chart (ran from a query)on the subform, so obviously the design of the query changes accordingly. Therefore, when I click the...

Hi All- I have researched this and understand I need to change my query critera to account for the subform, but it is still asking for parameter values after this update.. Summary: I have two Date Picker Boxes on the sub form which tells the query the date ranges which populates a pivot...

Yep, either worked pefectly. Thanks!

Your attached file worked beautifully on my form, with one slight flaw which I am unsure is fixable.. I noticed for the save button to become enabled, you must first click away from description. Is there a way to enable the save button immediately after data is entered in to Description, not...

Oh, I tried both, neither disabled the button.. But there wasn't an error for yours, it just didn't quite work.

So I put the first set of code in the forms module? and the second set as well...?

Ok, so I attempted this morning on updating the code steps you posted above and I am getting an error "Complie Error: Invalid Use of Me Keyword" And VB highlights "Function DoIEnable()" in yellow and the ME. in gray in front of Workstream. Secondly, should'nt the second peice of cose you have...

When you say "Controls" do you mean for each of the fields the user has to choose from on the Form? Or do you mean just the specific button I want to enable/disable?

Hi all- New here.. I'm having an issue (I have done some searches but was affraid to update threads over a year old). The idea is to not have the Save Entry button enabled unless all the fields have criteria. There are two fields that auto populate data and are not in the code below, I...