Search results

Greetings - I am using a method so that if a user changes a record, he/she is prompted to confirm the change ("Do you want to accept the change?"). This prompt comes when the person leaves the record (it is a continuous form). I find that even if no record is changed, if a person enters a...

Greetings. I developed and maintain a Access db through 32-bit Office and it is utilized on a 64-bit Office system offsite. While this has not in itself caused problems (people can access it), I'm wondering: 1. If this would effect the performance of the application (it's a split database...

Greetings, all - I have an Access2016 shared DB with a primary navigation form. I have programmed so that users only see certain tabs depending on their security level (a field in their user record in the db). It seems that the first tab's subtabs are visible (accessible) even if the tab...

Hi, all - We are using Access 2013 for a split shared database. I know this is a common issue but the lccdb file for our shared backend db does not close, even when all users seem to be out of the FE database. I've done research but haven't found a solution. All our users have complete...

I am runing a guery with multiple tables. One table has two long-text fields and when I run the query, they appear as gibberish symbols. They were working OK previous but now I can't get them to display the actual text. Any ideas? See attached image. Thanks!

Hi, all - here's the deal: I have a subform in a main form that is a log. I would like a query that provides a value of the most recent entry to impact the main form. I have a query "qryRefStatus_Max" that basically provides the most recent entry of the log. The trick is pulling the...

Greetings, I want to set a default date value in a form control based on a date value in another control using the dateadd function. I want this default value to be able to be modified if needed. Is this possible? The field remains blank even when there is a value in the source control. I...

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...

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...

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...

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...

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...

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...

Hi, all - I'm an offsite administrator of an Access 2013 database with the backend on a shared server and each user with a front end on his or her hard drive. We this arrangement has worked but has become more complicated with the site using the DB having users working from perhaps more than...

Hi, All, I have a query that produces a recordset with each record having two date fields, a sort of start date and end date. I am interested in creating a query or VBA that would produce a list of dates within a date range with each date having a count of all records in the original...

Greetings - I am thinking of upgrading to Access 2016. I work with others who use Access 2010 and 2013. If I create a database in 2016 will those with earlier accdb versions be able to open it and have it function appropriately? Similarly, if I created a database in 2010 but work on it...