Search results

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

How do you do this ?? thanks

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

i used to use something like this but cant seem to get this to work anymore afterupdate event i think it was [postcode] Like "AB#*" Or [postcode] Like "DD#*" Or [postcode] Like "DG#*" Or [postcode] Like "EH#*" Or [postcode] Like "FK#*" Or [postcode] Like "G#*" Or [postcode] Like "HS#*" Or...

i notice you have used G1, problem there is that there is G1, G2, G3, G4, etc upto G76 ?

how would i use this code and where would i place it etc?? thanks

Hi there, yes the cost field can be changed to any value. Thanks

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

sorted it, seems you have to enable macros on all new forms

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

ooops, forget to add it! here it is, thanks simon

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

sorry, what is join? do I also need to create a query? thanks for your help simon

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

yes, many thanks though! simon

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