Search results

Thanks for your replies. I did notice that the choice was new record or generate the prompt. How to I include a function that indicates no change in the record - me.RecordChange = False?

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

Thanks, CJ - especially regarding performance. This is not a compiled application so we are using accdb files for front and back ends. These answers will be good references for others - I did an initial search and didn't find anything.

A very thorough and informative response. Thanks.

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

Yes - each of the nav items is a tab. Perhaps it was an assumption that if a tab was rendered not visible, the subtabs would be as well. I'll try having the subtabs not visible as well by default. You're right about the navigation forms - Thanks.

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

Thanks for the suggestions. I am an offsite administrator for the database but the server administrator checked and said all users have full rights. I may have the solution, but the server administrator did suggest in the meantime to have each user restart their computer before leaving which...

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

Changing from Group By to First did the trick. Thanks!

Here you go. The fields are from the larger table on the right and are blackened below.

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!

Actually, sorry for the confusion. I found a much simpler way of getting what i want. Thanks for replying.

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

Thanks, I got it to work.

Thanks - the source field actually comes from another table and won't be updating it. I was hoping to use it for this form. I can do a dlookup and use that for the calculation. thanks.

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

Thanks - I know about the wizards. The trouble is that the wizard will not start for me and I've researched and tried things that I found but none of them are working. It seems to be a configuration between Access 2016 and Windows 10. Others seem to have the same problem and I found one...

That didn't work either. I actually just opened an old mdb file through Access 2016 and the control wizard worked. I also repaired Office 2016. Still can't get the wizard to work.

What I think is happening is when i click on Use Control Wizards button, the drop down list collapses so I don't see if the pressing took. When I reopen the drop down list , the Use Control Wizards button still looks like it wasn't pressed.