Search results

Is your form not already bound to table Planning?

Try: dubbel = "Bestelbon = '" & Replace(Me.txtBestelbonNew.Value, "'", "''") & "'"

I think you just mark the whole thread as Solved (Is there a button at the top of the thread?) I know you have said you are going to use UserForms, but I am attaching the Access version so you can see how simple it is in Access too. (y)

Make the following changes in your code: Private Sub passwtxt_Change() With Me If Len(Trim$(.passwtxt.Text & vbNullString)) > 0 Then .passwtxt.BackColor = RGB(255, 255, 204) '&H80000005 Else .passwtxt.BackColor = RGB(255, 255, 255) '&HC0FFFF End If...

Yes, there is. I guess Arnel was using hidden textboxes to demonstrate how it works. (I didn't look at his example) During the Change event the value in the textbox is 'uncommited' and you must use the .Text property to get the contents. The .Text property is only available when the textbox...

What happens if you try using bang syntax? Val([txtCarbsCalc])>TempVars!CarbLimit

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