Search results

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 :)

Vlad, A MILLION THANK YOUS!!!!!! Got the data sorted there depending on the user. Ill just have to edit the code to select * when the admin opens the db. Thank you for helping me resolve the issue!!!!

Yes I close the login form Vlad. So just create a tempvar to store the login and then use this data to filter my list box? But how do I filter this subform when I want it to open to the full frmJobs form??

Yes the DoCmd is called in the click event of the login page. Would I need to call the after_update in the frmSearch?? One question if I call the after update in the frmSearch; - Would I need to do an if else statement as I want all jobs to display when the admin logs in. Sorry for being...

Yes Ridders!! So each user has a userID and when they log in I want to return the job list from frmSearch that corresponds to their user ID. I have the code here but I'm unsure as to where to place this; Me.lstList.RowSource = "SELECT v.JobID, v.JobNumber as [Job #], v.JobDescription as...

Hi Pat and Static, I maybe have not been as informative as I still cannot solve this problem. When a user logs in he/she is directed to a page (frmJobs) which has three subforms, one of which is frmSearch with all the job data in it. I want to filter this frmSearch when a user logs in. This...