Recent content by chriscook

Your code worked brilliantly. Thank you very much for your help!

The likelihood is that he won't have the front end. But, if a user who has the front end passes it onto them, they will then know the location of the back end (and could pass this onto users who have access, but do not know the location) My apologies, I did not see the code you have provided...

Sorry, I don't think I have explained myself correctly. My problem is if a front end is copied to another user who doesn't have access to the back end (who we do not want to give access to). When they load the front end, it will give the location of the Back end file. I want to hide the...

Hello All, Apologies if this has been dealt with in other posts but I could not find any information on this. Our company has been using a database for a number of years, but I am in the process of updating the security of all the databases. I have split the database, put the Back...

Thank you for your quick response. I thought this would be the case. Thank you though.

Good Morning All, I have recently created a contacts database which i have split into a front end and back end. The front ends will be kept on the users PC's, with the back end being kept on a folder on the server. (It will only have permissions for those who require access to it) The issue...

Thank you very much! I have got this to work.

Hi, Thank you for your suggestion. I have used subforms in previous databases. I understand that this would resolve my issue. Ideally i would like to keep it as 2 seperate forms, as per my attached database. Is there anyway of doing this? If not i will have to use subforms. Thanks!

Hi, Thanks for your quick response. It is currently on another form. Is it not possible to do it this way? Or does it need to be on a subform?

Good Afternoon All, I am trying to create a Contacts Database for my Work. However I am having some slight issues linking the required fields. I currently have a Customers form which will show all customers, but when you double click on the ID, it will take you a list of the branches of...

Hello again, Please accept my apologies for the late response, other projects have taken priority. I am now back to trying to resolve this issue (hopefully with your help) Please see below link to my database with some sample data in it...

Hi, Sorry i have just been told I cannot provide database due to security reasons. Sorry. I can provide screenshots of the forms/queries if that helps?

Hi All, I am quite new to Access and hope I have put this in the right section in the forum. I have created a Stock Database for my company. It records all stock items, any stock adjustments (in or out) and the sales of items. I have a query (FreeStockCalculation) which calculates the...

All Working Now!! Thank you very much for your help!!!!

Hi, Thanks for your suggestions, i will now work at encorporating them into my database. We don't need a free stock field as the purpose of this database is just to record any movements in and out. The reason why i have an adjustment and a customer PO table is, the person who will be...