Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Sendeman

  1. Sendeman

    Passphrase is still being asked even with pageant running

    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...
  2. Sendeman

    Passphrase is still being asked even with pageant running

    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...
  3. Sendeman

    Passphrase is still being asked even with pageant running

    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...
  4. Sendeman

    Access changes query on save?

    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 -
  5. Sendeman

    Access changes query on save?

    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...
  6. Sendeman

    Access changes query on save?

    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...
  7. Sendeman

    Assign custom function to field in report (openrecordset problem?)

    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 -
  8. Sendeman

    Assign custom function to field in report (openrecordset problem?)

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

    Assign custom function to field in report (openrecordset problem?)

    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 -
  10. Sendeman

    Assign custom function to field in report (openrecordset problem?)

    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...
  11. Sendeman

    Assign custom function to field in report (openrecordset problem?)

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

    Assign custom function to field in report (openrecordset problem?)

    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 -
  13. Sendeman

    Assign custom function to field in report (openrecordset problem?)

    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...
  14. Sendeman

    Query input must contain at least one table or query. (Error 3067)

    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 =...
  15. Sendeman

    Query input must contain at least one table or query. (Error 3067)

    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...
See more

Part and Inventory Search

Back
Top