Recent content by Darrylles

'Code not working'. Wonderful term to enable people searching for a 'filter another form' solution - to find this particular issue. *sigh* Come on Moss - THINK ABOUT IT! ;-) How about "Can't filter form from another form"? ATB, Darrylle

Kim, Please report back here, when you achieve your solution. You have no need to follow advice, these things can be done many different ways, but, it's always nice to see how things panned out. ;-) Darrylle

Andrzejek, ;-) ATB, Darrylle

Andrzejek, Of course, but I'd do far more than that to 'polish' this, however, this is a complete change to the solution 'architecture'; it's only a 'framework' of how to not use 'check-boxes'. I haven't even implied how the user should be guided etc. - that's up to the developer (and trivial...

Kim, I would list each of your permission 'types' (Division, Unit, Shift, Rank) in multi-select list boxes (not individual checkboxes, which are cumbersome to process). The list box entries for 'Rank' would be the actual 'Rank' values. Multi-select means that zero, 1 or many can be selected at...

Imagine a remote system where there are a large number of MS Access database apps (a lot created by 'laymen'), many poorly defined / designed / produced. (You may find this easy to do). Some are having problems with exceeding the 2gb max database size, which in turn creates issues of locked...

Hi torq, I've uploaded a small app that contains 2 forms only: 1 is the calendar form, 1 is a small example calling form. All code is documented. I've had problems with command buttons not being raised (3d); I think it's a local installation problem - hopefully it's fine on yours (although for...

I got sick of depending on library controls (and having to redesign every time there was a change), and, I also couldn't depend on said controls being available in secure environments, so I built my own form that emulates the usual calendar control functionality. What you would assume to be a...

If I understand you correctly: You can't pull the value to be edited from the report, you must first edit the value, then pass it to the report. So, what is the report data source? Intercept the data source, and amend that. ATB, Darrylle

Your link table should have 2, distinct foreign key fields: FID_fk and TID_fk. Now you can join tblForm.FID on tblLink.FID_fk and tblTransaction.TID on tblLink.TID_fk, rather than concatenating them. P.S. This should be in the MS Access {Tables} or {Queries} forum. ATB, Darrylle

Did you resolve this? ATB, Darrylle

This is not 'solved', however; I replaced the function with a procedure with a parameter of a collection passed ByVal (by default), where the collection was defined by the calling procedure (not the called function). It seems strange that I can pass an array variable back to a calling sub -...

combo ListFilesInDir is a function. Can you 'Set' a function return value? ATB, Darrylle

OK, I changed the function to a sub, and passed a collection 'byref' (newly defined in the calling sub). Testing that now - but it does at least compile ok. Doesn't sound right having to do that though. Any info. appreciated. ATB, Darrylle

GShen, Did you see this?....... https://access-programmers.co.uk/forums/showthread.php?t=249509 ATB, Darrylle