Search results

Yes. I selected it via two different paths. I also registered the dao360.dll file and referenced the Microsoft DAO 3.6 library (which wasn't checked) as suggested in further research. Still no wizard.

I am using Access 2016 in Windows 10. I am trying to get the wizard to start for adding controls to a form - a button, to be precise. Using both ways to access the "Use Control Wizard" (from the arrow at the end of the controls list, and entering "Wizard" in What do you want to do and...

Thanks, arnelgp. This is good to have. Turns out the actual answer was a lot simpler - The preview was in pop-up mode, which really isn't necessary for our needs. i just set that to "No" and the ribbon had what was needed. Still interesting that the right-click was deactivated for...

Hi, all - I have a A2013 multi-user application where the security log in process hides the navigation pain and tool bar functions except for the basics. This can be bypassed by the shift key. I got this functionality online and involved changing some settings for the database and creating a...

Hi, all - Is there a way to have a single lookup control box (or some similar functionality) that look up records for subforms in multiple subtabs in a navigation form? I'm needing to break up a tab control from a single form into individual subtabs in the navigation form tab and it would...

Greetings, I have a subform (actually a group of them) in a navigation form. The navigation form has an unbound field that that is populated by the user name after user logs on. I would like to have this value be the default value in a field in each of these subforms. I tried using...

Greetings - I have an Access 2016 multi-user application with the backend stored on a shared location. Each user has their own front end. The front-end application covers many areas with the most active being treatment records of 4 types. The application is a navigation form, with...

That's what I thought. Strange...

It is, yet we are able to access other similar files in the same location without a problem. Would just one file be locked at the server location for the user?

Good morning, I have a split Access 2016 database with the BE housed on a shared server. I have one user who is getting a "Your network access was interrupted. To continue, close the database and then open it again" when opening his front end application. When I went to the mapped...

Thanks for your input. I actually fixed the code he Doc Man hit the nail on the head. I would want the default for the database when opening to be that the bypass key will not work. Only when I turn it on (for myself only) would it be available. Are you saying it really isn't possible...

Greetings, I am wanting to have a log on form that is coded that if a user has a specific user level value he will have a a message box open giving him the option to set the Bypass Key at true or false. However, I want all other users not to have that message box generated so they would just...

Greetings - We are needing to move our back-end Access database to the cloud. We don't, theoretically need to move our front-end application, although we do need for such a configuration to be HIPAA compliant. We currently use Access 2013 and 2016. If I linked the FE database to Azure on...

Thanks to you all. I ended up using an combination of using a pick table and the SQL directly in the query, not supplied by VBA. It works the way I want it.

I got the query to work using the pick table method. Thanks again.

Thanks to you both - I tried adding a spaces and it still isn't working; I realized that some SQL was missing from my original so I inserted plus added the spaces. The idea of a pick table sounds intriguing but for now, if I can get the other to work that would be best for present. thanks.

Hi, all - I am seeking to open a query through VBA which uses a multiselection list box as a parameter. I got the code primarily from searching online. I'm getting the "The Select statement includes a reserved word or an argument name that is misspelled or missing" etc. I'm not finding...

It looks very much like what I'm wanting. Thanks for the link, Paul.

Hi, all - Is there a way to have a combobox, listbox or even a subform to create a multi-choice filter to pull up selected records in a form or report? It's easy to do this for a single record, of course. An example of its use would be to select from a list of staff so only the records...

BMiles13's idea worked for me - and it's simple! Thanks!