Search results

Hello I have an access dB that stores meeting minutes as attached documents. This has caused the databas (I think this is why at least) to reach the 2gb limit. Ive moves 50% of the records to a backup dB to hopefully reduce the size. I’ve then tried decompiling and compacting however it makes...

Hi all, So the task in hand is that I need to email an encrypted xlsx sheet to a predefined party from Access. I figure this is not possible to do immediately in access, but I thought it'd at least be possible to export an encrypted file. At the moment, all I can do automatically is export...

Hello I'm wondering if it is possible to create a module to hide the navigation pane and document tabs? I know this is possible via the Access Current Database options however I'd prefer this to be done via an Auto Exec that runs the sub. (i already have it for the ribbon) Also, the code to...

Hello I'm not great with VBA so I've been trying to figure out a way to do with with expressions and welcome your feedback! I have a timesheet database, which has the exact start time and exact end time. I want to ignore this if it is five minutes either side of the half hour, and display...

Hello What I wanted was the ability to input a time on a form, and for a notification to come up at that time basically. I created a query (Callbacks - Duedatetime) that checks the database where this is stored and returns the maximum (MaxofDue Date/Time) of any times within the past 15...

Hello I have several search functions in my db but I fear this one has beaten me. I have a form, which contains a subform, which contains a subform, which contains the form 'Search Call-backs'. Within this form are several fields that the user can enter data into to conduct a search of the...

Hello I have an append query that has a criteria to be regarding a certain employee, however as this employee has no records in this table, I get an error saying 'No records'. Normally this would be fine if it was only one query being ran but I have several queries running one after the...

Hello I have a database with its backend on a network location, and every different user has a front end copied to their desktop. Whenever any user is in the front end, a table (AgentList) is read-only. Its quite a pain as I often want to make changes to the table structure and users are in...

Hello I have a Time Management database which the users keep closing without running a specific query by mistake. In an effort to work around this I added a the query to the 'On-close' event of the main form, however this cannot be used as some times they need to close the db without running...

Hello So, my database is for QA monitoring data. I have created a query that populates the agents average scores and the numbers of calls QA'd. Two of the fields in my query (Total Applicable Criteria & Criteria Sum) are set to the Total 'AVG' to obtain their average of these fields...

Hello I have a database that stores QA data, a percentage score is calculated and I was previously able to obtain an accurate average by agent percentage score. However, now, the average percentages (which are calculated in a query) are completely inaccurate. For example the majority if not...

Hello, Just wanted to get everyones views to see if there is an easier way around this. I have a database that when opened, currently displays the error 'The setting you entered isnt valid for this property.' I havent made any recent changes, but havent opened the database in a long time as...

Hello So I have a form and a report that I wanted to display on the same screen, as such I have used a report with a sub report to display the report, and a subform to display the form. However, I am unable to select a value from the combo box in the subform. I have checked the properties of...

Hello Firstly, apologies for creating yet another thread regarding a search form - you'll be happy to know the majority of my setup is already complete! I have created a search function for an internal knowledgebase ran via Access - at present the criteria parameter for my query is...