Search results

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

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.

A plus one for @Mike Krailo option. Personally, I wouldn't get into the habit of trying to reference calculated fields in the query by their alias in the query they are created in. Other RDBMS don't let you do it, so if you ever try and use the same query structure it will fail. I've had to...

I've experienced a slow down with repeated calls to Excel, despite lots of efforts to force it to "tidy up" I can't honestly say I've tried to create 300 workbooks in one hit though. I do produce time sheets for up to about 100 staff in one app, and that gradually slows down to a snails pace...

Similar to MajP thoughts, you can't use a recordset clone and then add to it, think about it, you need to add to table. You can use that recordset to Drive an Insert statement or probably more simply use an insert saved Query based around the source filtered record set.

You can't set focus to a form, only a Control on a form, (Unless the form has no controls, which would be unusual)

I'm sure this has been mentioned before but I thought it had been addressed, or we had a workaround. When importing data using SSMA that includes Boolean (Yes/No) fields, if you accepted the default mapping of Byte datatype then SSMA swapped all your lovely -1 data to +1's. Which meant that if...

I think we need to remember that Ukraine was a significant Nuclear power and was persuaded to completely disarm billions of dollars worth of Nuclear weapons, based on protection to be provided primarily by the US, and the UK and France at the time. This happened when the USSR collapsed and only...

That will only work if your numbers don't rise above 99. If there are always two spaces after the period the safer way is to search for that using Instr()