Search results

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

Greetings Gurus, Before I lose too much sleep over this I would like to know if it is even possible. The idea is something similar to what this guy was trying to do http://www.rage3d.com/board/showthread.php?p=1335449512 Effectively have a main-form with a listbox down the left hand side...

Hi Dave, That is exactly what I want to do. Column 2 from left to right in the datasheet is a combobox with a selection of existing products. If a product that is already in the products table is selected then the after-update for that field autocompletes the product code field and skips to the...

Problem solved. Here's my code for interest's sake. If Me.ProductCode.OldValue = Me.ProductCode Then MsgBox "no change" Else Dim strProduct As String, strTblProduct As String strProductCode = Me.ProductCode strTblProduct = Nz(DLookup("ProductCode", "dbo_Products", "[Type] = '" & strProduct...

Greetings Gurus... Please help before I completely lose it.... I have a subform whose underlying table is called Purchases.The 1st field in the subform comes from a table called Category, the 2nd & 3rd fields in the subform comes from a table called Products. When a user goes to edit the form...

Hi GTH, That's not quite what I meant. The SQL backend's columns are formatted datetime so their display is "01/01/1900 03:26:16" where the actual duration is 03:26:16 The plan is this:- On my form I have an "opened" time e.g.08/10/2010 18:32:48 I also have a "closed" time e.g. 08/10/2010...