Recent content by stillnew2vb

Doh! - RTrim

Seems the record in the source table that strProjectCode comes from has got some "padding" after it, probably because the SQL table it is linked to has a field size of 40 chars. There is probably a way to get Access to ignore the extra spaces but I'll leave that for another day.

OK, that problem solved through a couple of requeries, not to work out why there is an equivalent of a tab space between strProjectCode & strQuote (it comes out as ProjectCode Quote)

Finally got it working, I was think along the same lines John...Dim strProjectCode, strCompany, strOpenArgs, strQuote, strChange As String strOpenArgs = OpenArgs Select Case strOpenArgs Case "PENotify" strQuote = "has been edited. Please see Purchasing > Add/Edit Orders" Case "PRNotify"...

Now I'm very confused... Dim strProjectCode, strCompany, strStatement, strChange As String MsgBox "" & OpenArgs ' this returns PENotify which is correct strProjectCode = [Forms]![OrdersEdit]!List4.Column(1) strCompany = DLookup("CompanyName", "dbo_Company", "ID =" & Forms!OrdersEdit!Text10)...

Nope, that doesn't work either. Interesting that the msgbox is blank when I do this.DoCmd.OpenForm "Notifier", acNormal, , , , acWindowNormal, OpenArgs:="PONotify" MsgBox "" & OpenArgs. Should I declare "PONotify" statically?

Hi again John, I originally thought so too but if I omit it then the strStatement part of strChange is left out. Maybe it shouldn't be declared as a string?

Hi John thanks for that it sort-of works except it only works for button 1 on form 2. If I click button 1 on form 3 I get the result of button 1 on form 2. Is there something wrong with my code? Form 5 gets called like this Private Sub PONotify_Click() DoCmd.OpenForm "Notifier", acNormal, , ...

Hi Bob, That works if I am referring to form2 itself of a record on it. I am trying to refer to the name of a button (if that's possible). I get a run-time error 438 "object doesn't support this property or method" and/or run-time error 2498 "wrong data type". I think this is because the...

Greetings Gurus, Could someone please tell me how I can refer to a button on a subform from another form? Basically I have a mainform "form1" which has 3 subforms "form2","form3" and "form4". Each of those subforms have a button on them which call another form "form5". I need form5 to...

I was reading your GE adventure yesterday... very cool

Typical... spend weeks looking for something and as soon as you ask someone about it you find a (potential) answer. http://sourceforge.net/projects/dnvnccl/files/VNCClient-all/1.03-all/VNCClient-1_03-all.zip/download has a C# based VNC client that could be interesting

I have been looking around a few other forums to see if anybody else has done something similar and have yet to find any solutions. I am presuming that VNC won't natively run under Access but I was hoping that the shell that it will run under could be "embedded" in a subform. I guess I'll just...

Hi Darbid, Nice to "see" you again... I can get it to work quite happily from Shell "C:\Program Files\..." . What I can't get it to do is run that shell inside a subform without cheating by manipulating the shell screen-size and position

Hi Simon, TS & RDP is not involved, I am using it as an example. I need to connect to a number of managed servers & workstations and it would be nice if I could do it from an Access form where I have a list of the machine's names in a list box and then use an on-click event to get Access to...