Search results

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

Hi, can you elaborate here please..? The application displays the Switchboard as startup form. Those that need to use the booking panel are comparatively few in number... Ideally, am i able to stipulate a different Startup form for different groups of users?... Could i do this with a 'Sub...

The Switchboard is my Startup form...

I have a Switchboard panel/form , set as 'Popup' this is the primary panel for my DB application. ....this has been fine for many years, however I am implementing a new panel for time bookings for our workshop where operators of machine tools will likely have oily hands and I want to mimise...

Hmm... weird... So I took a copy of the database with the erroneous Report ... and gradually started removing controls and trying to preview each time.. no joy.. Eventually, there were no controls left... even then.. it still wouldnt preview! So, as a somewhat last resort I decided to try this...

I'm not sure of the distinction in what you suggest.. its called using: docmd openform (acdialog?) But the relevant form property is set to popup also..