Search results

It's getting there but when i scan SU out it doesnt populate the part fields etc. ive attached if you could have a look please lol I have attached database now and also a pdf that maybe explains it better hopefully lol

here is were i am at, the goods in works fine and it is now just when we are sending the parts out as getting duplicate error ? we need the same as goods in for goods out but when we scan the su number this then pulls data in from the goods inward for part number and serial...ive tried...

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

sorry i maybe should have mentioned but wanted to keep as simple as possible actually there are no invoices or charges involved and stock simply gets delivered and collected all stock is owned by another company and we simply store and ship for them. all these are is for our records only

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

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