Search results

OK, this is really (really) weird. I just took another look at the sample code from "worldbestlearningcenter.com" to see if I could spot an easy fix to the problem with having the action buttons enabled/disabled correctly (based on the population of content in the two list boxes). There is a...

I just wanted to add a brief footnote for anyone tempted to try the sample solution at "worldbestlearningcenter.com", which is that namely there are a series of bugs in the on-screen text... 1. The author mixes the case between cbdData and CboData for the Combo box. 2. The code assumes that the...

Thank you !!! I think it is worth a try!!! Before I posted my original request for help - i.e. first thing this morning - I'd pinged a more experienced friend for his advice. He responded with a link to this page:-...

Hello everyone, sorry for the fact that this is likely a pretty silly question... If I have an Access table and want to have a Form which references the table fields, I can run the Access Form Wizard, which gives me a very elegant little pop-up window including two columns, "Available Fields"...

JDraw, I think my previous reply has caused confusion. I'm not looking to build anything of that scale in Access or VBA, that was just to illustrate that I have a little experience of database logging and journaling on other platforms. Let me try and give you a brief synopsis of what I'm...

Thank you for the detailed response - it is much appreciated. You make lots of valid points. I understand heavy use applications; I won't tell you who I work for [since I'm still employed and would like to stay that way] but our SWIFT gateway processes 5 million+ transactions a day; we have...

Thanks Colin, I appreciate you taking the time to share your thoughts... The Menu system is coded and working perfectly. It's based on a hierarchy similar to i.e. disk file systems [NTFS-like] and I'm happy with it. Authentication of users is working fine [although I'm still only using SHA1 to...

Very helpful, thank you... Obviously I'm not just interested in actual code samples, but actual experiences of people trying to use either of these or other approaches and how they got on. Just in case I'm using VBA-inappropriate terminology, my interpretation of "serialization" is this...

I think I should probably begin this post with a brief apology – whilst what follows will inevitably be influenced by the functionality of VBA, this is more of a generic challenge rather than being platform specific. I am currently writing some modular functionality that I plan to use as...

Minty, Very happy to confirm that your solution works perfectly. Sorry to have to trouble everyone with such a trivial question - clearly I had hit the "can't see the wood for the trees" moment... Thank you

Minty, thanks so much... looks obvious with hind-sight. I will try this and report the results back...

Thank you for the question... I put a break-point in the form_load() method of the called form and I find that it is triggered when I first launch it, but not on the second or subsequent attempts. Looking deeper [please see code posted in this thread] it might be because I am using...

Firstly, thank you everyone who has posted a response to this thread. I very much appreciate your interest, suggestions and support. Secondly, please also understand that I am an inexperienced VBA programmer. Whilst I have worked professionally as a programmer, this was primarily on mainframe...

I have a relatively simple VBA project which includes a simple user authentication form, a simple menu form and then a series of forms which perform different functions. So far, everything has been working exactly as intended. However, during testing today I observed something not previously...

Hello All, Warning: this might be a "barking mad" question... I'm trying to write an application that needs to manage input from both an interactive user [via forms] and bulk insertion via imported tables. I'd like to be able to validate all input effectively. At this stage, rather than ask...

JDraw, Thanks... In terms of the roles it may be a little early to say. However, with the approach that we're taking, this system should lend itself to be extended as required. [ More importantly, if the approach works, we can lift/drop for other similar requirements, since it is intended to...

JDraw, Thanks for responding... I'll do my best to give you some more context... This database/application is basically a combination of "reference library" and "quality control" for a set of very specific technology requirements. Basically it is intended to contain 3 discrete types of...

Spike, Thank you for responding. I am sorry that my initial post was not clear. As jdraw correctly surmised, RBAC = Role-Based Access Control. I like your suggestion of a mock-up, but unfortunately this forum is configured to prohibit me from providing links to images until I have made at...

Hello Everyone, I apologise in advance for the length of this post, especially as this is my first technical post [so please be gentle!]. if I can I'd like to ask for some help and/or advice with respect to building a Form that can be used to render a dynamically-changing menu for a user. This...

Hey everyone, Working as a technologist - but not a programmer - I've just been asked to pull together an application that will be developed in Access with a view to publishing via Sharepoint... and currently feeling very much like I'm in-at-the-deep-end... I have incredibly limited...