Search results

Hi all, I have used this site a few times and found it to be extremely useful. I have created a small enough access database with a few thousand records. It is hosted on a remote server and the size of it is merely 15596KB at the time of writing this. It is linked with SQL Server backend also...

Hi guys, I know I have done some research on this before and I was advised it was not best database practice. However, I have a form that calculates a profit field. It has stored values from tables in my db that do a series of calculations on the form, and the profit box displays the profit...

Hi all, I am literally near tearing my hair out! My problem is this; I have 4 access reports to upload, I have used this code previous to save each one individually as PDF's: Dim fileName As String, fldrPath As String, filePath As String fileName = "FinancialReport.pdf" 'filename for PDF...

Hi guys, I have an access db that once I click close it takes a good 5-10 seconds before it really closes off. The Compact and repair box in options is not checked, I had some vba code for compact and repair that I initially included in the beginning, but I have since removed it and it is still...

Hi all, I am just looking a bit of advice; I have a calculated field in a form, a simple calculation that displays a value. I now want to store that value in a table which is already present in the database. I have created the column and everything in the backend and it is present in the table...

Hi all, I have a created a large access database to be used for multiple users. Each user has an employeeID and I want to filter the data they see when they login, based on the data linked to their employeeID. I know the functionality can be done with this on the login form but I am unsure as...