Search results

Eugene-LS has the answer - you forgot to declare variable sQry

🥵

You don't say which line errors. Where is Parity declared, and also StopBits?

I don't *think* that Access supports ANY (but maybe it does?), but the point is do you actually need to use ANY in the first place?

How about more simply: SELECT s.Customer, Nz(s.Session, 'Morning') AS [When] FROM Subscription s ;

Can you post a copy of your db and instructions to reproduce what you see. We do not have enough information to go on with what you have described. Someone will be able to take a look and see what is going wrong

Is your code in frmPayroll's module? If so, I think @Gasman means you try something like: Private Sub Form_AfterUpdate() Me.frmCDpayrollrecommsub.Form.Recordset.Requery End Sub

Are you using the new version of Notepad? It seems unlikely that Notepad would provide this sort of 'helpful' conversion - that is usually the preserve of MS Word, which is why you should never mix MS Word with storing/displaying VBA (or any) code. If it was done by the new version of Notepad...

@The_Doc_Man , you may have to tidy up your pasted code 😬

From the most cursory of glances, I think you will have to nest all those joins, or more likely make intermediate saved queries joining a couple of tables/queries at a time.

phpMyAdmin is a web-based interface program for administering MySQL databases. Normally you would connect Access directly to the MySQL database and use it as the interface interface, not connect to another interface program. What are you actually trying to do?

Wouldn't it have been better to store the limit in a table with a DateEffective field so your data would be accurate according to what the limit was at the time?

The dash is not a natural separator for VBA dates. It is part of a standard that MS doesn't follow. Best to be explicit just in case. But if it works without, then all good 👍

Backslashes escape the literal characters to be paced in the pattern. Otherwise, hash and dash have significance in the Format() pattern

I *think* that without the extra backslashes the dashes are treated as minus operators instead of string literals

Oops! Missed that too! 😬

Public Const strcJetDate = "\#yyyy-mm-dd\#" ' wrong Public Const strcJetDate = "\#yyyy\-mm\-dd\#" 'correct

1. Use Alt+F11 to open the code editor. 2. Before doing anything else, you will need to set a setting called "Require Variable Declaration". 2.i In the menu bar of the VBA editor go to 'Tools' and select 'Options' 2.ii In the first tab of the dialog that opens ('Editor'), uncheck 'Auto Syntax...

Dim PathParts As Variant Dim CurrentPath As String Dim NewFolder As String Dim NewPath As String CurrentPath = "D:\works\123" PathParts = Spilt(CurrentPath, "\") NewFolder = "FolderName" PathParts(UBound(PathParts)) = NewFolder NewPath = Join(PathParts, "\") MsgBox NewPath

Also, this line will need changing too: ' ... ' Return the result dbgSHA256 = Join(cypher, “”) ' ...