Recent content by cheekybuddha

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 😬