Recent content by terre

Of course I meant Row, not column Sorry.

Hi folks This should not be so hard.... I have a table with columns A,B,C,D A B C D 21 23 15 20 24 21 23 29 23 21 26 21 I want column E to show the name of the column with the largest number as shown. A B C D 21...

Yay! Thanks Have a great Xmas! Terre

The code strFilter = "SELECT Contacts.ID, Contacts.[First Name], Contacts.[Last Name], [First Name] & ' ' & [Last Name] " strFilter = strFilter & "AS CName, Contacts.IDate, DateDiff('d',[IDate],Now()) FROM Contacts " strFilter = strFilter & "WHERE " & (((DateDiff("d", [Contacts.IDate]...

I note that it is easy to link Ms Access 2007 to the Outlook Calendar. However, when I do so the startDate and EndDate fields aren't there. I wish to be able to see appointment dates from within the access database. Is it possible?

.ActiveDocument.Bookmarks.Add "ClientID", Range:= .Selection.Range Works!! Thanks for your help, and support, the world is a better place for the support of you guys out there. PHV in particular this time. Terre

Thanks PHV. A step closer I think, but now gives the "Bad bookmark name." message. I have checked, and the bookmarks are named exactly as in code above. It still stops after adding the first bookmark. Any suggestions? Terre

Actually......"Object required

I am trying to add some data to a word document. I found this code in FAQ, and it seems to work ok, but stops after adding only the first bookmark. Dim dbs As Database Dim objWord As Object Set dbs = CurrentDb Set objWord = CreateObject("Word.Application") With...

I have a form with a combobox (cboGoToContact) In the combo box After Update I have the following, to select a record for the form, by selecting a value from the combobox [COLOR=blue]Private Sub cboGoToContact_AfterUpdate() ' Find the record that matches the control. Dim rs As Object...

Wow...easy as Thank you

Is there a way to format dates as 11th September 2001 21st July 2012 etc?

Thanks MajP I think there is something else going on here Your code looks and feels right.....but the dabtabase just "jams up" Thanks for trying though, and if you think of something else sometime, let me know Terre PS the CrossTab method works well

MajP Had tried to add the Set Still a problem What seems to happen is...well nothing actually The database seems to freeze and then I get a message saying its not responding. Always happens I might just try waiting it out while I have some lunch. Terre

The Query AbsenceQuilt has the fields [Date Absent], PartofDayAbsent, LengthAbs, absenceReason My code is Dim rs As DAO.Recordset Dim ctl As Access.TextBox Dim startDate As Date Dim recordDate As Date Dim txtBoxName As String startDate = T1 'StartDate stored in Forms!Term1Abs!T1 Set rs =...