Recent content by Sendeman

Hi, I'm sorry, I forgot all about this thread! I have already resolved the issue. Somehow it is a Putty version problem. Putty/Pageant 0.61 somehow has this issue. I installed the Putty 0.60 package and all is right now. Best regards! Martijn. I love deadlines. I like the whooshing sound they...

Yes, I am sure. I followed several tutorials that all state the passphrase can be bypassed using Pageant. Even saw a video that shows it works. But right now, it does not work for me. So, any ideas on how to leave the passphrase intact, but still have to enter it only once per session? Thanks...

Hi all, From Windows, I have made an SSH connection to my centos vps server. I use Putty to connect and using the public key on the server and private key on my local machine I the connection is made. I have to enter a passphrase every time I connect in this way. As I understand it...

Ok thanks, I'll try a combination of other queries. Best regards, Martijn Senden. I love deadlines. I like the whooshing sound they make as they fly by. - Douglas Adams -

Thanks for your reply! That's sort of what I thought was happening. Is there anything I can do about the order in which the query is compiled? This is the SQL code for it: INSERT INTO Interval_BM ( BhId, DatMons, X1, Y1, Z1, X2, Y2, Z2, Comment, [Value], Depth1, Depth2, IntervalTypeId ) SELECT...

Hi All, A strange thing just happened. I created a query that joins a few tables together and when designing it, it returned a set of 176 records. When I saved the query and opened the saved query again, it returned 0 records. The design view still looks exactly the same and the SQL looks...

Oops solved it. The Having statement was missing quotes. Stupid. Thanks for your feedback though! I love deadlines. I like the whooshing sound they make as they fly by. - Douglas Adams -

Any other ideas? I love deadlines. I like the whooshing sound they make as they fly by. - Douglas Adams -

p.s. I think not, because if I use a different format, Access turns it into this... I love deadlines. I like the whooshing sound they make as they fly by. - Douglas Adams -

By the way, this is the query that is stored in strSQL in one of my test runs: SELECT tblVerkeersborden.Deelgebied, Sum(tblVerkeersborden.Vervangingsprijs) AS KostenJaar FROM tblVerkeersborden WHERE tblVerkeersborden.Vervangingsdatum>#12/31/2009# And...

No, I still get the same error... I love deadlines. I like the whooshing sound they make as they fly by. - Douglas Adams -

I know as much as you do. I used Dim As Recordset. Shoudl Is use ADO or DAO? I'm not sure what the difference is (no access expert). I love deadlines. I like the whooshing sound they make as they fly by. - Douglas Adams -

Hi All, I'm trying to assign a value returned by a custom vba function to a textbox on a report. The function uses two parameters that are passes from the call in the textbox. I tried setting the textbox value to: =Bedrag(0, "Deelgebied_1") or something similar. I have around forty different...

Whoops! Just saw the huge typo! The code below works just fine!SELECT tblGWS_Alle_data_tmp.BhId, [Top_Drijflaag_NAP]-[GWS_NAP] AS DikteDrijflaag INTO tblDiktesDrijflagen FROM (tblGWS_Alle_data_tmp RIGHT JOIN tblGWSnabijLaatsteDrijflaagmeting_tmp ON tblGWS_Alle_data_tmp.IntervalID =...

Hi All, I'm having some trouble with this SELECT INTO-query query I'm trying to build. This query (Query 1) gives the error statement: "Query input must contain at least one table or query."(Error 3067) Query1:SELECT tblGWS_Alle_data_tmp.BhId, [Top_Drijflaag_NAP]-[GWS_NAP] AS DikteDrijflaag...