Search results

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

Really hard to explain, but this works in Windows10 with Access M365 and does not work in Citrix with Access 2016 - although it used to work. I somewhat understand where the error comes into play. I'm using a variation of https://btabdevelopment.com/free-access-tools/ front end auto update tool...

This will be hard to explain, but it used to work and now it does not - both in Office 2016 and Office M365. I am generating E-mails from my Database. The E-mail body is in an external table .(so that I can change the text of the link addresses without releasing an updated database). Inside...

Hopefully this will take longer to explain than to solve ... I have a field on my form named "Status" The form has drop-down values and the values are locked. So for example, on of the values is "Complete" and if someone types something like "AY" there is a message that than is not on the list...

This code was derived from https://www.access-programmers.co.uk/forums/threads/f11-disable-or-not.328822/ The code works flawlessly if I step through it line by line. I'm looking at the lines in red: Private Sub btnACCDE_Click() '...

At first I thought this was a crazy question, but perhaps not ... I would like to call this color picker from a button on my form: That is from Excel, but I noticed the same color picker is available in Access if I open a form in design view and change the fore color of a text box, for...

Okay - obfuscating, but let's say I have three employee's in my group: Marshall Brooks, Tom Baker, and Joe Smith. I have these people in a table named tblEmployees in a field called Names. I have a combobox on a data form and I was using RowSourceType = Value List. and RowSource = "Marshall...

I think my database is fairly secure now, and I have an idea how I want to proceed but I thought I should "Ask the Experts" also. The issue: If a user presses F11, they can open the Visual Basic Editor. If they have access to the full .accdb version of my database (they don't), they could...

Somewhat hard to explain and I don't remember this happening before. By default, I have code in my database that closes all other forms except a hidden form, the switchboard, or the current form. Multiform is a public Boolean variable. So if I call the current form FrmA, the code looks like...

I have a simple table in my front end - 1 record, two fields. Used for the version date. I can read the values via: strFE = Nz(ELookup("[fe_version_number]", "[tbl-fe_version]", "[ID] =1"), "") & "" How can I write to the field. I saw: https://www.automateexcel.com/vba/access/tables/ and...