Search results

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...

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 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...

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...

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...

Hello all, All of my threads here became SOLVED on the same day it were posted. Thank you all! Now I have a little question, I could not answer with google. I have a continous form, with a single textbox in the header, which is an advanced search bar with a code in its update event. The...

I have encountered a very strange phenomena, which shocked my confidence in Access, and reminds me very mutch to excel! I have a table with an indexed (No duplicates) text field as primary key. The values are actually numbers, but I have chosen the text format to keep leading zeros. Today I...

Hello all, First, let me explain the task I want to accomplish. In my tables I have a field called first serial. This is the first element of a serial number range associated with each record. Very rarely I have to ask the user to specify a certain serial number in that range. (The serial...

Hello gusy, Can somebody point out the mistake in my function? It is basically a DCount, and it should find records, but returns 0 all the time. My code is: Function cntkit(sftd As Date, sftn As String, typid As Integer, specpaint As Boolean) As Integer 'Counts jobs kitted during shift given...

Hello guys, I am trying to set up a calculated field in one of my form querries, using expression builder. In one of my source tables I have 4 date fields called Inspection date 1 to 4 I need the lowest date among those inspectinos which are in the future (next inspection) If all 4 dates are...

Hello guys, I have started to develope an access database 2 months ago, when it became clear, that the data management system based on multiple excel files which were in use at my workplace (also developed by me) will soon be way over the intentions and capeablilties of Excel. I have...