Search results

@Pat Hartman - Hoping you might have some suggestions. As many of you know, I develop/maintain an Access database for about 30 users. Split single backend, and individual front ends. About half our users are using Windows 11 and Office 365, and half are using Citrix. Citrix was using Server...

I think I probably have this as good as I can get it, but I wanted to ask here first since it isn't working as I expected. I have a simple subform with two columns and several thousand records. I want the subform to have a vertical scrollbar and no horizontal scrollbar. I looked at these...

Hard to describe, but I have a combobox named Status with essentially, sequential values, e.g.: Review 1 Review 1 Complete Review 2 Review 2 Complete Review 3 Review 3 Complete This works fine, but if the status is Review 3 and I want to change it to Review 3 Complete, the drop-down opens at...

I have code to basically only allow my FrontEnd to open from the users desktop. Skeleton code looks like this: Location1 = "c:\users\" & GetUserName & "\desktop" If LCase(CurrentProject.Path) = Location1 Then ' Do nothing Else ' Close Database with message End If Our company is getting...

I have a query that extracts records from a table that match a field in the current record on a form. I use Dcount to tell if the query has any results, like this, and it works fine, but I would prefer to use Ecount: If DCount("EVENT", "qryAuditLog") = 0 Then Ecount works with other queries...

This will be hard to explain and I know the workaround, so I could just live with it. My database forms have a background image. The settings for the image are: The issue is that if I open the Citrix desktop in windowed mode, then open Access, then switch the desktop to full screen mode, the...

I obfuscating a bit, but here are my requirements: If Field1 contains an "X" as part of the field.value, I don't want it to be duplicated. (The field may have a v (version numbers) and some trailing numbers and I want to ignore those.) If the field value exists in the table, I want to display...

I needed this for another forum that I can't post images to. See https://community.adobe.com/t5/indesign-discussions/remove-border-from-selected-item-in-scriptui-dialog/td-p/14715321

This one has me baffled. I created a new status bar/navigation pane in this thread: https://www.access-programmers.co.uk/forums/threads/hide-default-add-new-record-button-only-how.329982/page-3 We've been using it for some time. I was using this code in the Form Open procedure...

I'm going to post this as solved, but I used an odd method and perhaps not the best one ... I'm adding an audit trail to events on a form: https://www.access-programmers.co.uk/forums/threads/audit-update-of-a-field.329588/page-10#post-1909410 I have a command button that displays the audit...

Please see the attached database. This is ultimately pretty minor, but I am having problems getting the datasheet view pop-up form for my audit log results to center properly. I found ten or so threads asking the same types of questions, but nothing that really resolved the issue. Audit Log...

Initially posted at: https://www.access-programmers.co.uk/forums/threads/audit-update-of-a-field.329588/page-10#post-1909410 I'm getting this error when deleting a record using a delete button control: Stepping through the code under the delete button, the record is deleted, the code steps...

I have code in my database autoexec that is supposed to disable the Shift Key Bypass UNLESS the database is opened from my development folder. I am getting ready to release a new update to the database (.accde) file, and I realized that I forgot to set some of the tables to hidden in this view...

Is there any way to keep the standard navigation buttons, but hide the Add New Blank Record button. I know I set Navigation Buttons = No and hide all the buttons, but I would prefer not to do that - it also hides the No Filter and Search buttons, but I could work around that. I have...

In a previous post, I mentioned that I had used to have the FE on a server for users to download and some users would open it from there. Someone replied that two different users opening the same front end was bad news, so I added code to only allow the database to be opened from the local users...

I think this is a simple question, but I'm pretty weak in query design. I have a table called tblChapterNames, it has two fields "ChapterNumber" and "Subject". Some subjects have a value of "N/A" so I want to omit those. I figured out how to make a two-column query, but I would like to use the...

Somewhat Obfuscating, but ... I have a form named "Form A" and another form named "Form B". Both forms have a Field named "REFERENCE". Both Forms have a Private Sub "Reference_AfterUpdate()" which validates the data in the field. That works fine for manual input, but does not work if the field...

Probably a simple question, but I wasn't sure what search terms to use. Currently, our database has date fields for (example) "Subprocess A Completed". Currently, any user can update these fields. My supervisor requested two changes: Restrict the field update to only certain users - probably...

Basically, I have the same question as this thread - https://www.access-programmers.co.uk/forums/threads/auto-size-width-or-label-or-text-box.53796/ - Except in my case, I want the textbox or label to grow vertically and stay fixed width. I somewhat asked here also...

I should know the answers to these, but I wanted to confirm them. I want to add two new tables to the back end of my database. Usually, I would get exclusive access to the BE in order to do this. Is this a firm requirement, or can other users have the back end open, since there is no way for...