Search results

The quickest and easiest way to do this is to go the properties of the column months and insert the headings manually "Jan";"Feb";"etc"

Select Case Me.Check1 Case -1 Or 0 Or 1 '/Do This Case Else '/Do That End Select

Place this function in a standard module Public Function NextBirthday(AnyDate As Date) As Date Dim D As Date D = Format(Day(AnyDate) & "/" & Month(AnyDate) & "/" & Year(Date), "dd-mmm-yyyy") If D < Date Then D = DateAdd("yyyy", 1, D) End If NextBirthday = D End Function Include this...

Set Rs1 = CurrentDb.OpenRecordset("Select * From Event Where EventID = " & cmboEvent) Rs1 is pointing at the wrong table Cange it to Event not EventDelegate

Are you simply want to find out who's birthday is in the next month/30 days?

Did you get a performance boost?

Try recreating the offending query and see what happens

That because you are using spaces in your name Should be SELECT Clients AS Birthday, Format([Birthday Date],"ddmm") As [Birthday Day]

Yes I knew it would. Thanks:eek:

As you want to sort by only the day and the month of the date then you need to create a dynamic column that is only day and month. Then you can sort by this format. Where does telephone numbers come into this?

You could try and change... This IIf(IsNull(Me.HoursStart), 0, Me.HoursStart) To Nz(Me.HoursStart),0) IIf reads both conditions then makes a decision which one to use, whereas Nz() doesn't

If you type it into the actual propery command line Access will encapsulate it with []. If you do it in vba it does not.

So now we know the table is still there, is the fieldname ClientName still there? Does it appear in the field list for the client table in your query?

Have you added a new column such as bDay:Format(BirthDate,"mmdd") Sort Ascending

So if records are entered in in batches how will you ever identify which was the last one added. If that is what you want.

I have this issue and my workaround is that it is down to using unbound controls. You cannot use BeforeUpdate on unbound controls with efficiency. So lets think about what needs to happen. If the code already exists you give a warning message, then you need to set the original text box to ""...

Create a new query based on your union query bring down the birthdate field and format it Format(BirthDate,"mmdd") Then sort by this field.

(D)Last is the method you use to get the last record thown into a bucket (the table) now this does not mean that it is at the top of the pile. Imagine having 9 red balls and one white one. Throw the 9 red ones in first then throw the white one in. Now close you eyes and reach down and pull out...

Sounds like your client table has either been renamed, deleted or dropped from the front end. If all users are experiencing the same problem check your back end for the client table.

LstForms is the name of the list box on your form RowSource "Select FrmName, FrmAccessName from TblFormNames Order By FrmName" Was an example of using SQL in the rowsource property of the list box