Search results

Think I have got to the bottom of it or at least found the right pond. This was the test input tag. <input type="search" role="search" placeholder="Search MDN" id="q" name="q" value=""> type="search" is html5 , the browser is ie8, I guess we have a compatibility issue but that said I cant see...

Using VBA from Access to automate IE . I have this not assigning a value to the innerHTML as expected. Function PasteToWebPage(txt As String, ie As SHDocVw.InternetExplorer, Optional IfNotExactlyOne As htmlNotExactlyOne = htmlPasteToNone, Optional ElementID As String, Optional ClassName As...

Several issues here - something has gone a muck with a subform and not sure whether they all might point to the same thing. Context. A database serving as an encyclopedia, without all the fields mentioned the encyclopedia table has: An ID. A reference field. A details field. A subform is...

Private Sub City_NotInList(NewData As String, Response As Integer) DoCmd.OpenForm "City", , , , acFormAdd, acDialog, NewData Response = acDataErrAdded End Sub Private Sub Form_Open(Cancel As Integer) If Me.OpenArgs <> "" Then 'It has been opened for new records only CityName...

Thanx RV for clearing up the red-herring! There is always a temptation to assume that people dont read the help. But of course the reality is that most are forced to reference it as they go and very rarely get time to read the entire contents in such a way as to retain the majority of what they...

There is still something missing in the understanding for me here! Access attempts to add first when encountering the + operator but if not able to do so will go on to attempt concatenation. In the ["Mr"] + ' ' + ["Andy"] + ' ' + ["Seabrook"] example then it would not have been able to add...

Yes I see how it might perform addition on numbers but in the example I had here for instance we had three pieces of text: ["Mr"] + " " + ["Andy"] + " " + ["Seabrook"] In the above example field names are replaced of course with the data they are holding. Using + on this data works exactly...

Thought I replied to this earlier! Sorry if there is a repeat. Thanx for your input EMP - did the job fine! but I am lost on the difference between the two concatenation symbols: could you explain?

Hi folks any help appreciated. I have a combo box displaying a concatenated trio of fields representing another individual in the same contact table. Title & " " & Firstname & " " & LastName I need to use this value with a DLookup or other solution to get the email address from this other...

So what about when it is a word merge operation (getting the same 3027 error - single user setup) i.e: DoCmd.TransferText acExportMerge, , "Incident Query", _ "..\FormsAndLetterTemplates\Case Brief for Internal Expert.doc" N.B. In the actual code the full filespec is specified!

Ok some mistakes in my trying to dedbug this thing! I didnt realise that system tables were invisible by default, the MSysAccounts table does exist, but still getting the 3173 error. Aslo the persistence of the checkbox state was a red-herring, the 3173 error is occuring further along the...

A lack of familiarity with access realy. I was manually doing a recordset update. Anyway I changed things around as you suggested and something new has developed. The DoCmd is causing a 2046 error "cant save at this time" and halting the procedure (ironically however the state of the the...

Thanks for the help Seth, OnUpdate occurs when any change is made to a command bar, so I am guessing you meant AfterUpdate() or BeforeUpdate() In fact the state is set first, and then the OnClick event is processed. But your suggestion did make me look again and in fact when I took a second...

Hi, Updating a single Yes/No field to show if the record should be visible. Have a continuous form with a bound checkbox to supply the new value. OnClick event for the displayed data innitiates an immediate table update. Values were not updating. The problem: However stepping through the...