Recent content by GUIDO22

Yeah, I had considered using a numerical value. Thanks for your input, much appreciated

Thanks - that works well...! Only thing I need to cover now is the situation where the calculation suggests INFINITE... which is text... So any ideas how I could encode this in the same cell formula...? Currently I am using .. =MAXIFS(C34:I34,C35:I35, ">=1000")

Hello I have a calculation tool that displays some life cycling figures... I need to return the block 'value' for which both the upper and lower figures are the same ie. dont contain FAIL So in the picture attached - I want to return the value representing the highest pair of values ie...

Thanks... based on your subquery.. I have managed to return as required.. Nice one!

Apologies... [WeekIn] is not in the CUSTOMERS table, it is in the ORDERS table.... my bad...

I store Sterling / currency exchange rates in my DB which apply between a date range (given as Start / End dates in the currency table : ie. an exchange rate 'period') So for any one currency type (Euro/Swiss Franc etc.) - there can be many records in the EXCHANGE RATE table, each record...

Yes, works fine..

I came up with this ... (Month(Now())=MONTH(SaleDate) AND Year(Now())=YEAR(SaleDate))

I wish to use a recordset call with SQL to return all records for the current month/year... can you advise on the parameters to Format to achieve this please..?

I need to generate an Excel report but NOT using the shortcut menu and Wizard in access... From report preview... I want to be able to use vba to run the access report and automatically save the excel report to a designated folder on disk. (I have another routine i can use to then email the...

I did , thanks.. Just considering all the options

Thanks!

I have the Autoexec macro defined and a SubMacro within to Runcode, which calls : db_Startup() I have the Sub db_Startup() defined in a standard module named : 'Module1'.. But when I run the Autoexec, it errors (error code #2425): expression entered has a function name that cant be found...

In the DB project options you can select the form you want as the startup form... Mine is set to the Switchboard....

As initially stated, have already tried that... Figured having it the open() event may have been the issue so moved the relevant code to Activate(), Gotfocus() etc. But same result each time... Switchboard remained visible and in view..