Search results

Its for a dashboard designed to show the last 12months with no interaction.

Hi, I'm trying to get a formula in my query that full pull the last 12 full months + month to date. I've been using... DateAdd("m",-12,Date()) And Date() But this doesn't give a full month for April 2020 (which is the 12 month cut off) Cheers

This looks really promising. Really appreciate both replies. I'll keep you posted on progress.

Hi, On my report, I'm looking for what id presume a simple formula that gives me % increase / Decrease of the month on month figures as per the example below… Jan 100 0.00% Increase Feb 120 20.00% Increase Mar 150 25.00% Increase Apr 90 -40.00% Decrease May 105 16.67% Increase Jun...

Hi Mark, The temp table is shared.

Hi, I'm looking for a VBScript I can run with the windows scheduler that will... Open a Access DB with an mdw file AND... which has a database password So far I have... "C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.EXE" "C:\Dir\DATABASE.mdb" /wrkgrp "C:\Dir\MDWFILE.mdw" /user...

Hi, This is turning out to be very difficult. I simply want a button that when clicked will compact and repair the current opened database but without using sendkeys. Thats it, but all the code I can find appears very complex.

Hi Adam, I delete the full data set and refresh with new every 5minutes. Its made a form that previously had a 3-4 second delay when navigating through records (due to subform lag), now instant.

Hi, I have a form that certain fields are returned from a temporary table (that the contents are firstly deleted and then refreshed every 5 minutes). this causes the 3 fields to show #Deleted until a timer then refreshes the forms query. The form does work really well and is 10x quicker than...

Guys, this is brilliant and works perfectly. I cant thank you enough. Kind Regards Steve

Hi, I have a crosstab report that returns the last 3 months data and works perfectly. The issue is that time old problem where my column heading are year/month and move each month i.e July19, Aug19, Sep19 to Aug19, Sep19, Oct19 (when run in October). How can I dynamically create these? Cheers

Hi arnelgp, Sorry for the delayed response. Thats fab, ill be trying it this week. Much appreciated.

Hi, I'm trying to return the last 3 full months of data up to current date, so if today is 24/10 the return would be between 01/07 to 24/10 i.e the criteria will always give me the full 3 months and the current month to date. Thanks in advance

Hi, I have a form which gives me my outstanding ledger to which I can make payments against and creates a payment basket (which has a unique reference) in a temp table prior to posting. What I want to do is run an append query that appends an exact copy of all records relating to that basket...

Anyone care to script the same for a 2007+ .accdb?

Thanks Gasman / isladogs. Im going to play about with these options tomorrow. What if I wanted to run more than one macro? I also think this is a great post for other users!

---Update--- As per below.... With a massive thanks to Daniel Pineault I have managed to open a DB and use the /User and /pwd switches to pass a variable automatically!! Note: I slightly edited it to include the /pwd switch What I now DON'T know how to do, is run a macro after the DB is...

Hi, I have managed to create a task using windows scheduler which opens Access and runs a macro. The macro runs if I manually enter the Logon Password (which is set under "Manage Users & Permissions" > User and Group Accounts) under Access 2016. Is there a way to set this password in the...

Hi All, So I have a simple query that returns various data (including a Long Text field), except the field cuts off at 249 characters. Anyone come across this? Is there a solution for this? I'm using Access 2016 Thanks in advance Steve

Hi All, I'm really struggling here with Null values! I have a query (outstanding amounts) which feeds a subform and in turn a main form. This works well and the values are presented as they should. My issue is however when the query returns null i.e there is no outstanding values for a given...