Search results for query: *

'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

tbclbd What method are you using to 'export' this data. Please post your code (don't forget to format it). ATB, Darrylle

OK, getting desperate enough to drop this one in (then continue to try to resolve it, until some wit highlights my schoolboy mistake). I have been a member for 17 years though! I have a function that basically returns a list of files found in any directory (folder). It worked fine whilst using...

You "switched to FileSystemObject and CopyFile method". Did that work? If not, what's the problem now? And FYI, you are not alone: Link Darrylle

Checked: MS Access 2007 is supported by Windows 10. However, it sounds like you have jumped from Vista straight to Windows 10 (a lot of major versions since). Is that correct? Not sure how much VBA code is involved, but have you re-compiled that application code? If not - try it: Open the DB ->...

puforee This forum is for the benefit of everyone - not just for YOUR individual problem. You raising a question, then saying "I fixed it" - doesn't help anyone. If I search for "Update Main Form from Button on sub-form", YOUR post comes up in the results. I drill into it, and the solution...