Recent content by thirty

Chris, Thank you for the quick response. All problems are solved. Thirty

Chris, I use the Option Explicit. I erased that option. lngRed = 255 Now i am using my program without the Option Explicit. I have a question. Why do they use the Option Explicit?

Thanks, It is working with the buikd in VBA color constants

I am running dutch OS and Office. My system delimiter a comma. I tried olso green and blue. The textarea backcolor stays black

Hello, I want to change the color of the background from a textarea txtTitel. I want to change it into the color red, but i get always the color black. The forecolor doesn't change. I use the following rules: lngWhite = RGB(255, 255, 255) lngRed = RGB(255, 0, 0) lngYellow = RGB(255, 255, 0)...

That is it. I changed the dutch word "formulieren" bij the english word "Forms" It works! Thanks alot.

I am getting the error 2465 in the program below. Error discription: "can't find the field '|1' referenced to in your expression" Here is a part of the program Dim strMySql_zoekenOpId As String Dim strTitel As String strTitel = "DVD-LIJST" strMySql_zoekenOpId = "SELECT tbldrager.Id...

Thats great! Thanks alot for the quick reply.

Hi, There is a error in the next piece of program. The error is the red text below strMySql_zoekenOpId = "SELECT tbldrager.Id, tbldrager.Naam, tbldrager.Soort, tbldrager.Aantal, tbldrager.Formaat, tbldrager.Kostprijs, tbldrager.LEVERANCIER, tbldrager.Verpakking " & _ "FROM tbldrager " & _...

I am new to access 2010 and i hope to learn a lot here.