Recent content by Minty

If you brought all those fields into a Product combo box, (hidden from view) you could simply display them from the hidden column directly, no need to fill out that data separately at all. If the product description doesn't ever change then you don't need to store it on the order, you can...

On SQL Server UPDATE TheTableName SET Selling_Price = Purchase_Price * 1.3 Replace TheTableName with the correct name for the table. EDIT : Actually re-reading your post I think one of us has the calculation wrong? I assumed you just wanted 30% Purchase price + (Purchase price *30%) is a much...

So if she is found guilty, presumably she'll suffer the same fate as Trump then?

Check the battery is seated correctly, charged up, and that any mechanical switches it might act on when in place are working.

Before database work, I had been repairing electronic devices for 20 years for a living (including Toughbook's, and other dedicated specialist portable PC's) and undertook a similar repair on my daughters laptop (An HP with a touch display) a number of years ago. It was a nightmare, they really...

Okay - I'm not sure your data is stored in a sufficiently normalised structure to do this. Currently you only know what courses someone has taken. If you had a new course you wouldn't know it existed as it's an unknown quantity. You really need at least three tables : tblStaff - with the...

Remove the subquery from the criteria in the Staff name. You don't need it anymore.

You want to exclude the staff not the training - so this ((Technical_Training.Legacy)<>-1) Should be ((Stafff.Legacy)<>-1) So you need the join to the Staff with that criteria. If that doesn't work please post up a picture of the relationship window with all the fields names for the two tables.

Just take a year off the current function?

If you can buy a display, battery and a keyboard for £45 (that's roughly the conversion to GBP) then it might be worth it. The laptop looks a reasonable spec, unless you want an excuse to replace it. Be warned that changing the display can be very tricky on some laptops, and it's easy to crack...

Day() , Month() and Year() are inbuilt functions that will extract the numeric values of those parts of a date field. I too am amazed you couldn't find them via Google! https://learn.microsoft.com/en-us/office/vba/access/concepts/criteria-expressions/functions-alphabetical-list

No, it's not, you are taking the value on the form and storing a local calculated value. What if someone else added or took stock of the same item at the same time - you now have two conflicting answers. You need to have a transaction. Stock in or out.

You should really calculate the current stock from the transactions since the last stock take. You can store that as a number with the product code (if it helps other queries), but you should run the calculation again to recalculate it, not try and massage it on the form. If you are using SQL...

A table with the 36 characters cross joined to itself 5 times: select A.CharVal, b.CharVal, c.CharVal, d.CharVal , e.CharVal fROM zzTable_Source A CROSS JOIN (select CharVal fROM zzTable_Source B ) B CROSS JOIN ( select CharVal fROM zzTable_Source c) c CROSS JOIN ( select CharVal fROM...

@Pat Hartman - I think you have this the wrong way around. SQL Server doesn't allow it, which is why I don't bother to do it in Access, which does if you write it in the correct order.