Search results

You're going a bit off topic here, but I think Daniel's entitled to his opinion.

Interesting. Frank talked a lot about using it for the BE, but perhaps he was looking to implement it. Shame UA is no more, he asked a lot of questions about it there.

Is it still using a postgres backend?

This UI looks familiar. Is that you, Frank?

As per pbaldy, if LDOW is really a datetime datatype, then try: Set rs = CurrentDb.OpenRecordset("SELECT TOP 1 LDOW FROM qryWeeklyForecast WHERE LDOW=" & Format(Me.LDOW, "\#yyyy\-mm\-dd\#"), dbOpenSnapshot)

That title was definitely generated by ChatGPT! :ROFLMAO:

Try again, with the following adjustment: ' ... strStep = "2. Set Target Database" strNewConnectString = "ODBC;Provider=MSDASQL;Driver={SQL Server};Server=IPAddress;DATABASE=dBName;UID=dBSa;PWD=dBPassword;APP=Microsoft Office;" ' Example for Access database" '...

When you query the connection string (eg Debug.Print tdf.Connect) VBA will not reveal the user and password to you, but it will have cached the values and apply them when you use the connection. This is for security, so it is more difficult for users to discover the connection credentials...

Welcome to AWF

@xavier.batlle 's suggestion in Post #3 will not work either (both "#1" and "#2" will be returned since they satisfy the other half of the expression)- @XPS35 has the solution in Post #6. @DHookom provides the cleanest solution in Post #4 Your options are: ([NewLineDesc] = "#1" Or...

🤪 😂

.bat != .dat All the .dat files I ever came across used to be some form of binary encoded files, not plain text files

Haha, it looks like I probably found it from Daniel Pineault's site linked by Tom in post#2! I had better add an attribution to my code library 😬

I can't remember where I found the CLSID, but I used a late-bound MSForms DataObject: Option Compare Database Option Explicit Private Const FORMS_DATAOBJECT As String = "new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}" Private m_cb As Object Private Function getDataObj() As...

Hi @Joan Wild , Since the demise of UA I was taking a trip down memory lane on Wayback Machine and noticed you and I were made VIP's there within a week of each other! 😆 UA front page on 2005-10-13

The point is why have tblRecords.LockID at all? Couldn't you just have a simple query like: PARAMETERS SpecifiedRecordID Long; SELECT R.*, IIf(Nz(Q.Outstanding,0)>0, -1, 0) AS LockID FROM tblRecords R LEFT JOIN qryOutstanding Q ON R.RecordID = Q.RecordID WHERE R.RecordID =...

This is not correct. It initialises to Empty (not the same as an empty string).

Was it bound?

Joseph is correct, June, a Variant variable initialises to Empty - what you see is as a result of datatype coercion. However, the point is that the function StringFormatSQL() handles NULL's passed as a parameter and correctly converts to the the word 'NULL' in the resulting output SQL string...

No, a variant can be whatever is put in to it. I *think* the StringFormatSQL() function will be able to determine what the passed datatype is. But it has the advantage that you can also put NULL in to it (ie when your textbox is empty/Null). The only problem might be if your currency fields in...