Search results for query: *

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

Hi again, Well thanks. That seems to explain why I can't do what I want to do. I guess access doesn't really add the value to BhId or its textbox yet until the new record is comitted to the database. I don't want to make the tabs visible in the before insert event. It isn't triggered at the...

Thanks! But I the same runtime error again: Runtime Error 94. Invalid use of Null. (translated from Dutch) So, BhId (autonumber field) doesn't get a value before the new record is inserted, which seems logical to me. Any more suggestions? Regards, Martijn. I love deadlines. I like the...

Hi PHV, Thanks for the reply! I obviously do not get the error message anymore, but I don't get a MsgBox either, because at the time the Forms OnDirty event is triggered, the new record does not have a BhId yet (BhId == Null). So, I really think I can not get this working using the Forms...

Hi AceMan, I tried your suggestion. I tested with this code: Private Sub Form_Dirty(Cancel As Integer) If Me.NewRecord Then MsgBox (Me.BhId) End If End Sub When I now type a single letter into any of the fields on the form, I get this error message: Runtime Error 94. Invalid use of...

Hi All, When I am adding a new record in the form, I want to make a tab visible as soon as the autonumber field in this record gets a value (i.e. after a value has been added to any other field in the form >> the autonumber field is disabled). Is there an event that is triggered that I can use...