Recent content by pholt33

Hello, I have a navigation form that has a navigation subform and then forms within that subform. I have figured out how to hide the main tab control based on user access but the subform tabs are still visible. In the AdminHidden pic I attached, the Admin tab is hidden but the Reps...

I think I got it figured out after much trial and error! lManagerRole As String lManagerRole = DLookup("[role]", "[Employees]", "[E-mail Address]='" & Trim$(Me.txtName.Value) & "' and [Password]='" & Trim$(Me.txtPassword.Value) & "'") And then in the Open event, I used: If lManagerRole Like...

After doing some more testing, "lManagement" in the existing code won't work for the level of access desired. lManagement is set on the login form using: lManagement = DLookup("[ManagementTeam]", "[Employees]", "[E-mail Address]='" & Trim$(Me.txtName.Value) & "' and [Password]='" &...

That didnt initially work, presumably because the button is on the subform, but once I opened the subform as an individual form and put that code on the OnOpen event, it works! Thanks for your help!

There are name/password fields set up and are used for restricting which forms people can see, etc. I didnt build it so Im not exactly sure how it works. When someone logs in, the login form is still open but the employee dashboard is active. On the Employees table, each employee has an ID...

Solved: Visible/invisible control based on user access? My company has a new database that we will use to track PTO (paid time off/vacation), including the submission/approval process. Not everyone should have access to the approval dashboard as that should be restricted to only managers...

I think I figured out the problem. VBA --> Tool --> Options --> General --> Compile The "Compile on Demand" boxes were unchecked. Once I checked those, the database opened normally and without any problem!

When I open a database I get the error message "The expression On Load you entered as the event property setting produced the following error: Argument not optional." This error occurs only on my computer but not on anyone else's in the office when opening the same database, so I suspect it is...

There was a hidden field that seemed to be causing a problem. I deleted that field from the form and now the form loads normally and the active field highlighting works. The required fields pink highlighting is not working yet but there is no error message. Edit: I think I may have figured...

When the form loads, I get the error I highlighted above. No, I havent renamed or changed any of the code. Here is the full code: Option Compare Database Option Explicit 'Purpose: Call this in any form to: ' (i) highlight required fields, or ' (ii) highlight...

Yes, that works the way I would expect. I moved the module from the original DB into mine and then on my form's On Load, I put =SetupForm([Form]). Where exactly would I put that?

I found a block of code online (allenbrowne.com/highlight.html) that highlights form fields. Upon opening my form, I get a message box with Error 3265. The error occurs on the red line below. What can I do to fix this? I am using Access 2010. Public Function SetupRequiredFields(frm As...

I have a dashboard and on one tab there is a subform with two grandchild forms. When one of the grandchildren (a data entry form) is updated, I want the other grandchild form to update/requery. Parent: Employee Dashboard Child: Accounts - Finished Grandchildren: Accounts subform, Accounts -...

I have a process where a timestamp is created. Once that timestamp is created, the user has until the end of the next business day (weekday is fine if incorporating holidays is more difficult) to finish a process. If the process isnt completed in time, their approval expires and they need to get...

Hi! Ive been getting lots of useful info from this forum and finally decided to join.