Search results

Hi all, we use a scanner to scan part barcodes when booking in to stock example of part number on label PWR-C5-600WAC= actual scan inputs in field as 1PPWR-C5-600WAC= so as you can see it add 1P which is what we need to remove same as serial ART2509D1S9 actual scan SART2509D1S9 so need to...

Hi all, a bit rusty as not used access in a while but decided to create new database so getting back to grips lol anyway i have form called goodsinward and subform goodsinwarddetails how do i move from field in form (after update) to field in subform ? Ive tried these but getting error...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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