Recent content by mistermarty

Hi all. I have a customer database, where some of the customers have recorded an email address and some haven't. The customers fall into 20 different groups within the DB. My question is, can I create a button on an existing form, whereby when it is clicked it asks for me to input which group...

Cheers, I will have a look at your article 👍

Thanks for your reply. It looks like this one works straight away, as the shift key is disabled if I hit the "Disable" command button, log out of the DB and then try to go back in with the shift key pressed. I'm guessing (and kind of hoping) that to re-enable the shift bypass externally as you...

Thanks!! Worked perfectly. I can't believe it was that simple, I was obviously over thinking it in my own head. Cheers M (y) :)

Evening all. I have a module in my DB to disable and enable the shift startup override function. At the moment, I have to type apDisableShift or apEnableShift into the immediate window to turn the function on and off. I have placed an "on" and "off" command button on a form that only I have...

Thanks for your reply, Pat. The code starts with either M or H, and some have a number in brackets after, and some don't, e.g. H01, H07, M05(1), M20(7) and so on. I think that Minty's solution should work in my case. Cheers M🙂

Perfect! Thanks so much for your help. Marty (y) (y):)(y)(y)

Hi. I have a query set up so as when it runs it asks the user for an input, and the results are sorted depending on that input. So, if the user wants to see records that come under the code M05(1) or M06(2), they will type in that code and the records that come up are those allocated to M05(1)...

Thanks for your speedy replies and suggestions. I have decided to change the "IsHyperlink" property of the text box to yes, which makes it just as easy to display the location in Google Maps. Thanks again :)

Hi all. I have a database containing customer details with delivery addresses that are sometimes quite remote. A post code may cover a vast area, so we generally use Google maps to find the building prior to going out on the road etc. To help drivers find the exact location for where they need...

Hi. Just another quick question about the Modified_PasswordLogin_RC4_v5.3_mistermarty you sent me the other day... are the options for forcing users to reset their passwords (ChangePWD and ExpireDays) active? I have tried ticking the box for one of the users and set the ExpireDays to 1 for...

That's fab, thanks. I hid the 4 buttons because I thought that's what you meant in your previous message yesterday ("Set all 4 controls to be hidden by default in the form design..."). Anyhow, I'm glad (and grateful) that you spotted my mistake. Thanks also for the recommendations. I've been...

Here it is. It's really just the DB you recommended I try a couple of weeks ago, with the extra switchboard form added to help me understand how things should work. I have removed the existing users that you had on your version and added 3 users with their own access level (which is where I want...

The VBA immediate results were what I expected, so it looks like it's something to do with the form. I'm not sure what you mean by the built in Access switchboard though. I created the frmSwitchboard the way I always create forms - Create... Form Design... then add the command buttons etc. Is...

Nope, still no joy. I have set up 3 new users, each with their own access level (1, 2 and 3), but it doesn't matter which one I log in as, the switchboard form is still blank even though the frmSessions shows the user as still logged in.