Search results

Hi All Trying to get the zoom function to work so that my team can expand a notes field to read the full detail. i am using the Shift + F2 function and the moment but will implement the VBA once it works. so some screen shots. This is the split view form that i use (i have redacted the...

Hi All so i have what i believe to be a complicated and probably an impossible thing to try and impliment. Background I have a job progress tracker that is updated by multiple users in multiple sites. it controls access through a log in feature. There is a split form view datasheet that pre...

Hi Everyone. Need some more advise please. I have tblA which has a filed for NPS. There are 3 possible entries to that field, Promotor, Passive and Detractor. These are inputted by the user. i now need to calculate what the NPS score would be and display it in the split view form. I would...

Hi All I have a db with a front end that user log into. Is there a way of measuring inactivity time and running a log out code after a specified time frame?

Ok so this is a complicated one so i will do my best to explain So i have a table called tblDaySheet This is all my master data that spans data from 6 different sites. This table has 2 fields that i want to reference, WIPNumber and Site i also have 6 other tables labelled tblRB51, tblRB52...

Hi All Need some help again! i have a form that displays all the users in my system called frmUserList (form created from the tblUsers) I also have an edit user form called frmEditUsers I have set the on click event on the fields in the frmUserList to open the frmEditUsers but cant seem to...

Hi All I have a DB that has a user login page. There is a table holding all the usernames and passwords. My issue is that it is not case sensitive. For example, my user name is Mark.Dooler but i can log in as mark.dooler I want to restrict this so i have to use the capitals. the code for my...

Hi All Me again. So todays issue is around why i cant get the bloomin cobo box to work So, i have a table with a list of users for various sites (tblUsers) I have a tempvar set to a specific site. I have a query on the tblUsers that uses the tempvar to filter a list of users just for that...

Hi All The below code is coming up with a compile error as screen shot below Access 2016 is being used. Any ideas? Code: Private Sub btnLogin_Click() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tblUsers", dbOpenSnapshot, dbReadOnly) rs.FindFirst...

Hi All I have a union query that displays data as a dataset in a form. When someone updates the data you have to refresh the query for the updates to show in the dataset. When you use the 2 individual queries indipendantly and display the data as a dataset it updates automatically when a...

Hi All I have a DB running in 6 of my sites. They are all set up identically. I have one front end that is linked to the back end. Each user has the front end and it is set to connect to the correct file location for their site. I also have some multi site user that have to unlink and...

Hi Everyone. Need some help again. So the setup. I have a table (Day Sheet) of jobs and each job has an owner in the form of their initials. there is a field in this table called Serviceadvisor. I have a query (Sadaysheetqry) set to display the data and it has a criteria of [Please enter...

Hi ALl I have converted a spreadsheet i use to be a database as it is growing large and unmanageable in spreadsheet form. The issue i have is some of the functionality i get from the spreadsheet i cant seem to replicate in the database. This is probably largely down to my lack of knowledge in...