Recent content by chriscook

  1. C

    Split Database, Macro to Open Form, Stop Error Message

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

    Split Database, Macro to Open Form, Stop Error Message

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

    Split Database, Macro to Open Form, Stop Error Message

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

    Split Database, Macro to Open Form, Stop Error Message

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

    Backend Security

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

    Backend Security

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

    Customer Contacts Database

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

    Customer Contacts Database

    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!
  9. C

    Customer Contacts Database

    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?
  10. C

    Customer Contacts Database

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

    Calculated Field pop up

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

    Calculated Field pop up

    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?
  13. C

    Calculated Field pop up

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

    Calculating Sum in Query

    All Working Now!! Thank you very much for your help!!!!
  15. C

    Calculating Sum in Query

    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...
Back
Top Bottom