Search results

I have a full working and adapted version of Aleksanders work. I have also emailed him several times with issues I have had with some of the code and he has helped me for free. Some of his code is in Polish and some in English. He has helped me change it for free where I have been stuck. If the...

Hi Colin, I don't suppose you have an example at all please? I have been on this since yesterday afternoon and just cannot make it work. I have a field that details the financial year/month start and year/month end, but when I try to do a running sum, I just cannot figure it out. An example...

Hi forum brains. I am after a little help on a cumulative running total query. I want this for our financial year, which runs Aug - Jul. I have managed to find a working method but only for Jan - Dec (see link https://mskb.pkisolutions.com/kb/208714) Would anyone have anything they have maybe...

That will work with 3 of the charts I have, but one of the is a Cumulative one, and I can't figure out how to get this one to work for the months that haven't happened yet in our work financial year. I'll have a tinker and see what I can come up with. ~Matt

Thanks Colin, I found your page very informative for what I was aiming to do. What I was wondering is, can you base a chart on a crosstab query directly to save the TRANSFORM part? I am designing a sales dashboard and our company owner wants the graph to display all months in our financial...

Apologies. The Basics of this is that the chart sort order is the last field in the axis, not the first. So to sort by month number, I have to have this after the month name in the query. Quite why MS decided this I have no idea, but the 2nd video on the link from Colin said this, so I tried...

Figured this out from https://isladogs.co.uk/modern-charts-code, Thanks Colin :) ~Matt

If I do this, it sorts alphabetically, and not in the correct order :( ~Matt

Hi All, I am trying to do a modern chart and want to specify the sort order of the month. But Access in all it's wisdom keeps sorting the months alphabetically, not by number. When I edit the Transformed Row Source, I get an error message stating "You can't assign a value to this object" I...

Thanks DBguy. The solution offered by MajP worked and was so simple. Just created a list box and based it on a query of that field showing just that part of the attachment field and it worked perfectly. ~Matt

Good shout. I shall give this a go. Update: Tried and this works fine. So simple. I feel dumb for not trying this first. Now, can I open the file from here now on a double click? ~Matt

Yes, this does work. But I wanted it just shown on the form itself.

Hi all, I have been looking but cannot find a work thread for what I am after. Nice and simple, be able to display the list of filenames in an attachment field on a form. I can get it to display the first attachment, but it won't show anything after that. Hoping that it is something simple...

Hi all, Had a look at the attached and it is great. But I was wondering if anyone could point me in the direction of adding half days to the calendar? I think I can edit it to everything else I would like it to do, but half days I cannot figure out. ~Matt

I tried this approach but it didn't work. Loading the form with the filter wasn't the main issue, it was creating a reset. But I now have a working solution :) ~Matt

Thank you, this worked. I had to edit it for the reset button as below, but it works. Me.Form.Filter = "Format([AppointmentDate], 'wwyy') = Format(Date(), 'wwyy')" ~Matt

I just filtered the form and then saved it. It then added it to the filter field in the form properties. ~Matt

I wouldn't either, this is just the filter that access generated when I filtered it using my command buttons. But pasting this into VBA to load/reset doesn't work. ~Matt

I am trying to filter by the current week as default, adding the ""ww"" does not work though, I have tried this and get the "Expected list separator" error. ~Matt

I wouldn't either, that is the filter the Access generated for me, but it doesn't work Yes, I want the continuous form to display the current week every time it is opened, or if the reset button is clicked default back to this. ~Matt