Recent content by TonyE

Look at FMS Inc website.... They have detail of how you can use remote connection to a server or cloud based backend DB. Not a simple config, but haven't tried it myself as I use Citrix.

then just install VMBox on your PC ..... this will allow any virtual operating system to be installed and utilised. see https://www.access-programmers.co.uk/forums/threads/windows-update.318143/

FYI I utilise a 3rd party bit of software to auto backup and compact all my databases on a regular basis i.e. overnight. Software is Total Visual Agent which can be found at https://www.fmsinc.com/, works really well .... set it and just check it every so often.

Another way to keep using just MS Access is through Citrix.... You put your compiled MS Access application and it's backend DB's in a shared directory in Citrix server or linked server. Accessing the application through Citrix gives a faster more efficient connection for multiple users. I...

In Rowsourse SQL statement change the field value returned.... ie replace field X with iif(X=false, ""No"", ""Yes"")

Best thing we ever did for our global Access systems is utilise Citrix and put both backends and frontends together on shared drive.

Thanks everyone for the fast response, will finalise my coding ref this issue tomorrow.

Yes I just stumbled across this also ......... didn't expect GLOBAL to work ok since PUBLIC doesn't. Anyway this solves my requirement can now just use a single array rather than many and merging. Thanks for the suggestion had I not already gleaned this, you would have been been the man, cheers.

Never used Collections before ...... looking at examples and yes may well do what I need. You can define Collections as PUBLIC as well. Thanks will give it a go.

All I am doing is saving into an array when an field gets updated from multiple subforms (into an individual arrays) i.e. subformA has arrayA, subformB has arrayB etc ........ want to then accumulate all arrays to say an array arrayAll then use this arrayAll to perform actions in main form on...

I know can copy out to a table then back into array if want to ........ just wondered if a better more direct method

You cannot seem to declare an array PUBLIC so I cannot see how to copy one array from subform into main form array ...... Anyone know if this is possible ?

No its just a stand alone report ...... I have solved my issue as mentioned earlier .... thanks anyway.

Wanting to make selections/filtering within the report to alter its data output ....... don't really want to keep opening then closing it and using a form to make different slections. I have achived this ref below all be it with limited available tasks after Listbox selection(s). I can set...

I have put a list box in a report which as it loads generates a list of Project names. want to select then filter report on a Project. Problem is there is no AFTER events showing and LISTINDEX and LISTBOX.SELECTED just dont seem to work. Anyone found a work around to this issue ?