Recent content by marjdk

Did you manage to solve this issue? If so, would it be possible to see your solution since I am having the same kind of problem.

There seems to be a syntax error :-(

Like this With ActiveSheet.QueryTables.Add(Connection:= _ "ODBC;DSN=xaldb;Description=xaldb;;;APP=Microsoft Office 2003;;DATABASE=xaldb" _ , Destination:=Range("A1")) .CommandText = Array( _ "SELECT LEDTRANS.ACCOUNTNUMBER, LEDTRANS.DATE_, LEDTRANS.TXT...

Hi all, I have this piece of vba-code which doesn't work for me. Sub HentNavisionData() Dim KtnNr As String, StartDato As Date, SlutDato As Date KtnNr = "' " & Range("B5").Value & "'" StartDato = Range("B6").Value SlutDato = Range("B7").Value With...

Hi, I am having some troubles with the sizing of my form. In the Form_Open VBA-code of the form I have entered Me.Width = 17600 However it doesn't seem to use that settings, and I can't find a way in vba to define the height of the form. Does any of you have a solution for this? Thanks, /...

You have to this in a query. The table is just the storage of your data and if doesn't allow you to do calculations in the table itself.