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