Search results

Have you been auto-correcupted, Ridders? I guess it should read 'twips' ?

Out of curiosity, what is your purpose in populating a dictionary with table data here?

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?