Recent content by MickCun1

Thank you NauticalGent!! It is literally one of the most infuriating things ever knowing the code is done but the program itself is too slow.

Yes NauticalGent! Do you have any idea why my db is so slow?

Hi ridders, Apologies!! The file is located in the H: drive under CorpData, as we are all on the one server here. In this folder on the K: drive the users can open a portal that allows them to access the db on the remote server. I hope this better clears things up??

Hi Mark_, Thanks for the response. To answer your questions; Is the Front End on the users local machine or are they all sharing ONE copy on the server? Yes everyone has a remoteApp they log in too on their C: drive, and access it through the one server. However I am the only one accessing it...

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

The tables are alot more complex than simply that but for this particular inquiry, I have made it as simple as possible.

For the purposes of a data explanation, here it is: tblJobs - Contains Job Capital figure tblJobCosts - Contains the JobID (PK of tblJobs) along with all expenses (rates, drawings, heating etc.) Capital - total expenses = profit, which is done on a form. I want to see this profit, along with...

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

Wow, guys thanks a million for the responses!!! Yes @Mark_ I will code indent in future. Apologies!! And @Ranman256 I tried to use all in the one report but because some of my reports are portrait and some are landscape, it does not format correctly. And @Galaxiom, yes I will maybe place...

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 Ranman, Yes compact and repair was run manually but now I want to remove it to close the database quickly. There is no code in the unload event form the db. What do you think the issue could be? Regards, Michael :)

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

I dont have it split. I was just going to place it on the server and allow employees to log in?

Yea I am looking into coding the admin now. Im thinking maybe the best would be to reset the tempVar after every time someone logs in? Then if the value is null (its the admin as every other employee has an ID). What do you think of that method of doing things? Michael :)