Search results for query: *

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

MajP....where did that Aceman come from? Actually its the forms("yourFrmName").controls(txtBoxName) that is Null, therefore (I think) ctrl is Nothing Terre

Thanks Aceman, and Duane Aceman.....something not quite right......ctrl always appears to be Nothing ctrl = Nothing even though all the others seem right Any suggestions? Terre dhookum I will need to ponder the setting up of a table of dates, as I wont always have an entry every week. Thanks...

I have a calendar grid for a school term which has 11 Rows of 5 Textboxes. 11 weeks M,T,W,Th,F I have named these textboxes 1,2,3,4,........55 (For originality!!) I then have a query AbsQuilt which returns DateAbsent, and Reason for a student. DateAbsent Reason 1/2/2011...

ok...SORTED Thanks to MajP ...in another post I cruised at random I guess. In text boxes, Control Source is =IIf([1e]="1","P","") for n =IIf([1e]="2","P","") for s =IIf([1e]="3","P","") for o =IIf([1e]="4","P","") for u Wingdings 2 Font

I have an option group which returns values 1,2,3,4. I wish to represent this in a report, with a tick representing the value returned, in a column n = 1 ,s = 2,o = 3, u = 4 as in uploaded pic. This is fine if the report has only one record, however I get multiple ticks in a row when there are...