Recent content by Ipem

Hello, I have finally got fed up enough with this problem, so I have made a stripped DB. It contains a single table, still the problem remains. Please direct me towards the solution!

Thank you JHB, for your quick reply. I can't find the event you have referred to. The format event of the detail object of the form has only click, doubleclick, mouseup, mousemove, mousedown and paint events -at least theese what I can see. Is not that a danish event name?

Hello all, I am trying to change dynamically the text of the PivotChart, according to the current filter. This is a user request. The VBA code should run whenever the view is changed to pivotchart. I'm im Access 2007 This is my code so far: Private Sub Form_AfterFinalRender(ByVal drawObject...

Hello all, I would like to share this piece of code with you. When copied in a form's module, it will let you go directly to filtered datasheet view when you doubleclick on a cell in pivot table view (Access 2007), by creating the new filter string, which includes your current filter string...

Sorry guys for the delay, I'm in Europe, so my work hours were over. Uncle Gizmo: Yes B has a Q. To explain, let me use real world names for those fields: I have orders, with several items. All items has a status, like: "cancelled" or "ready for shipping". I want to find those orders of which...

Hello guys, I'm sure there is a common solution for this, but I can't figure it out, and do not even have a clue what to search for I want to find rows in which a value in a field occurs only together with a certain value in an another. For example, in the table below I want to find only A...

Hello, I have managed to create a filter string according to the current selection. (On what cell the user douuble-clilck) Previously I knew nothing about pivot related VBA, but a MSDN example script helped a lot. Here is my subroutine so far: Private Sub Form_DblClick(Cancel As Integer) If Not...

Hello all, I think this should be a quite common request, yet I have find no help on this. I want to "zoom" to the underliyng data from pivot view. When in excel someone doubleclicks a field in a pivot table, it automatically creates a table containing all the lines that field were made up...

Thanks Mihail. So I need to make my own refresh button, and ask the users to use that instead of the bulilt in one. This does not make life simpler, but what can I do? Best wishes, Ipem

Hello all, I think the title of the thread sais it all. I need to run a make table query every time the user opens a specific form, or clicks on the "Refresh" button, to requery it. I have searched the net for 20 minutes, and can't find the answer. The background: The make query updates the...

No, there are no empties nor nulls only dates. An idea: I had problems with date formats in VBA before, since VBA criteria raquire american date formats, so I had to manually format my date constans before use use in criterias. But this should not be a problem now, since I use pure user...

No. My useres would simply like to use the built-in filter tool from the ribbon.

Hello all, I have a date field on one of my continous forms. When I try to apply a date between filter, it gives me an error message saying: "Enter a valid date" I choose the boundary dates from that little calendar. The date after and date before filters are working without problem. The date...

pr2-eugin, Yes, I can see it in design view. I don't think that its update event macro has to do anything with this issue. I have reproduced the behaviour in a single table and form example file, with a textbox without any macro. I have attached that example

I do not have it in the form's record source. It is an unbound texbox I have placed to the header after the underlying query and the rest of the form were created. It also does not show up in tab order dialog.