Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. C

    Calculating Sum in Query

    Hi All, I have been working on a stock database for my company. It needs to hold stock data, Any adjustments in the storesperson may do (QtyIn or Out). And allow Customer PO's to be raised (just to show prices and quantites sold to customers) I have 4 Tables: tblStockList PartNumber (Primary...
  6. C

    Merging two Queries?

    Hi, I am in the process of setting up a stock database. The database will be used by two people. The stores person who will adjust stock in once goods have been delivered, and occasionaly adjust stock out. The other user will load PO's with various different Part numbers and will issue the...
  7. C

    Updating Stock Quantites

    I am relatively new to Access and am having to learn a lot on the job. I have been asked to Create a "Stock Database" This will be used by primarly 2 people, the storesperson and a sales person. We need to to show Part number, description, quantity in stock, latest stock check (which i...
  8. C

    Prevent duplicate entries of a field on an input form

    Hi All, I have recently started working for a new company and have inherited a nightmare of a system! I have basic knowledge of Access and have been asked to stop duplicate entries under the same PO Number. I have tried using DLookups by looking at other posts on the forum with no success...
Back
Top Bottom