Search results

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'll think you'll find Putin escalated tensions by invading another country. Trump is assisting Putin by blatantly obviously putting Ukraine in a weaker position than it was, and then doing a "great deal" by trying to leverage rights to Ukraine's natural resources (one of things Russia wants)...

This is Elon's AI bot though, Shirley it can't be wrong? Joking apart, the Russians definitely have something sizeable on Trump. There's no way he should be trying to "deal" with Putin, he's simply not clever enough, and his usual bullying tactics won't work, as Putin is a far bigger and uglier...

If it's anything like our Government, 90% of them are only there to line their own pockets or their buddy's. They are all complicit in not dealing with things and having a short term view (say about 3-4 years...#shockhorro#) on everything. They never take a long term apolitical stance on...

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()

The public IP will be shared by anything going through the same router, unless there is a VPN involved r some clever DNS Setting being used? However sharing on the same internal network doesn't have anything to do with the Outward facing public IP address ?

Trump and Vance demonstrated a total lack of understanding about the situation both politically and the wide international perspective. Vance makes Trump almost look intelligent. Which might be why he is there. This sums it up about a well as anything.

I suspect Colins excellent application can assist you: https://isladogs.co.uk/email-tester/index.html

The removal of statues has happened recently in the UK. Most famously by a mob in Bristol, because the statue was of a man who had profited from the slave trade. History should not be re-written. Trump changed the local name of the Gulf of Mexico, not for any altruistic reasons, but because he...

I think in most of the cases mentioned above there has been a public debate about the prospective change and a consensus of opinion. You know, like adults...