Search results

  1. H

    Relationship or Table problem, where am i going wrong ?

    Hi all, I have attached a sample copy of database as trying to get back in to access again and a bit rusty ! Can someone help with this, i am sure its simple but i am missing something and if you could explain lol So if you look at goods inward this is fine ! The problem is i am trying to...
  2. H

    Working with order numbers both in and out for multiple items - new project

    Hi all, I will keep this as simple as i can so not to confuse anyone i hope lol I am trying to create a database to log all stock items coming in and going out to and from carriers or couriers as currently this is all done manually. When goods come in this can be 1 item or 20 items and they...
  3. H

    get results for previous 3 months VAT reasons

    Hi all, I have a query and report that shows invoices with invoice date obviously ? My accountant wants data from the last 3 months records ? March,April and May invoices and next time June, July and August i want the criteria so code will simply show the last from months only and...
  4. H

    matching 2 item codes from 2 tables ??

    Access 2010 Hi all, We have a list of unique numbers on our database and then someone comes to do audit with what should be the same as ours so looking for a way that when we import their list it looks at ours and shows any queries for missing or extra items ? The code is the unique number...
  5. H

    Help and advise on simple stock in and out database

    Hi all, I am creating a simple database to keep records of stock movements. We have parts that come in and out of our warehouse all which will be scanned at time of movement. I am thing I will need a few tables and relationships for this and this is the main advise that I will be...
  6. H

    how do i change first characters on a text field ?

    Hi all, I have a form with a field called PartNumber these are entered from a barcode scanner by scanning barcodes on a box. My problem is this: When we scan a part number the barcodes actual part numbers are shown like this: PN321-ab55 but the actual part number we use is 321-ab55...
  7. H

    Question Looking for simple orders database that i can build learn from ??

    Hi all, Looking for download of something like attached picture to learn and build on? Thanks for reply ? Simon
  8. H

    How do i show picture on report if control is true ??

    Hi all, I have a report called "orders" and on this is records for orders of the day inputted. On this report I have a control called "urgent" and a picture called "UrgentPicture" with the picture set to visible.false ? If any of the controls for Urgent is True then this will show my...
  9. H

    Get part value from Postcode to create a cost

    Hi all, I have a form which has a number of fields and 2 of them are called [Postcode] and [Cost]. The cost field is defaulted to "£75.00" What I am trying to is after the user enters the postcode it looks at the first and second value and if they enter a postcode in Scotland like...
  10. H

    Access 2013 me.[field]= "something" not working???

    Hi all, Just upgraded to Access 2013, has something changed ? When I create a button to change a fields contents, nothing happens? for example L1 being the field I am working with me.L1 = "Hello World" When I click button nothing is entered in the field, done this a...
  11. H

    Question How to create Relationship with duplicate records ?

    Hi all, Please see attached picture where I am stuck at? I have a table that holds UK Postcodes and a customer table that holds customers. I am trying to create a relationship between the 2 so when I enter a postcode in the customer table this is then related to the postcode table...
  12. H

    How to link customer to postcode table

    Hi all, I am using access 2010 and have the following question? I have 2 tables, 1 called UKFile and the other Customers with the following fields [UKFILE] THIS IS WHERE ADDRESS DETAILS ARE STORED POSTCODEID POSTCODE STREET TOWN [CUSTOMERS] CUSTOMERNAME POSTCODE STREET...
  13. H

    New Parts and Supplier Database

    Hi all, using access 2010. I am trying to setup a parts and supplier database that is currently done using a spread sheet. Each part may have upto say 5 suppliers with its own price. I then view the prices and use the lowest quote. Prices are checked and updated on a monthly basis. What...
  14. H

    how to click on subform to view or add another record!!??

    Hi all, I will try and explain this as best as i can, please go easy on me as i am fairly new to access. I have a form called "invoice" and has a subform called "JobsSubform" The subform is in Datasheet view with only a few fields on it. When i click on the record of the subform this then...
  15. H

    Advise on Structure and Relationships

    Hi all, I have created the attached database to show you what sort of thing I am trying to acheive. A customer will call us each day with 1 to say 10 bookings, these bookings are then allocated to an Invoice and Invoiced at the end of each month. The invoice consists of many bookings for a...
  16. H

    Advice please on simple invoice database for deliveries and collections

    Hi all, I am creating a new database to input my customers deliveries and collections on a daily basis. Then when all data has been added over a number of weeks we then print out an invoice for these and send to customer. Am I heading in the right direction or can you recommend any changes to...
  17. H

    Advice on Contacts and Telephone Table and Relationships???

    I starting a new project and need a bit of advice. I have 3 tables as follows: TblCustomers TblContacts TblWarehouse TblCustomer has all the head office details entered. TblContacts has contact names and telephone numbers as there is sometime more than one contact person and telephone...
  18. H

    UK Postcode Address Database Table

    I all, I have a database with all uk address's on it as layed out below which is great for queries etc.. There are 1754968 records on here in total covering the whole of the UK and Ireland from around 2007 I can supply this on CD for a small charge if anybody would find this useful...
  19. H

    Help Cannot add record on form

    Hi all, I have uploaded database to show where i am at. Please look at bookings form for error. When I try to add another record to an invoice i get error message: "The object doesn't contain the Automation object 'invoice' " What i am trying to do is when a customer requests a new...
  20. H

    Urgent Pleas! How Do I Create A Form To Add Further Records To An Invoice

    Hi all, I am using Access 2010 I have uploaded database to show where i am at, but I am now stuck on the following: As you will see I have a form called Main which dispays all active ( uninvoiced ) customers which has a list box that when selected show the Invoice. What I want is when the...
Top Bottom