Search results

more date problems The above code you gave me works fine bob. However it appears to only open the form correctly when the day part of the date is greater than 12. 13/11/07 it identifies as 13th November 2007. 12/11/07 it identifies as 11th December 2007. It is obviously getting mixed up with...

All my date fields are set to Short Date

Thanks for all your help Bob. I have changed all occurances of DATE throughout my database. And Open Form code work perfect.

blank form I have tried that but it keeps opening up blank forms. timetable_Code is a number. Private Sub OpenBtn_Click() On Error GoTo Err_OpenBtn_Click Dim stDocName As String stDocName = "Attended_Classes_And_Students" DoCmd.OpenForm stDocName, , , "[Timetable_Code]= " &...

Dates Thanks Bob. One of the fields is a date field, do I just use the text code for dates?

I have a button on one form that when clicked is supposed to open another form. The form its supposed to open is based on a table with a composite key. Is it possible to get this bit of code to open the form based on 2 fields values? The wizard allows you one choice and as I know nothing abot...

Thanks I got it sorted now. Thanks for all your help, very much appreciated

Fixed Thanks I got it sorted now. Thanks for your help, very much appreciated

Its not working unles I switch it to design view and back. Could it be because the DayCheck field is unbound?

Its not working unles I switch it to design view and back. Could it be because the DayCheck field is unbound?

No the problem was where I was placing the [Forms]![Form name]![Unbound date field]. I had it in the criteria row as opposed to the field row. Is it possible to have a form button disabled until a condition is true with other field values. I have a button, (appendbtn), that I want disabled until...

Is it possible to have a form button disabled until a condition is true with other field values. I have a button, (appendbtn), that I want disabled until 2 fields, (Day) and (DayCheck) are equal.

Thanks Ken. Sorted

Tried that Ken but still not working. Now saying it is an invalid date

I have a form bound to a table that passes several parameters to a query. However there is one field within the form that is unbound that I would also like to pass to the query. I have been unsuccessful in doing it. I have tried to pass it the same way as the others i.e:- [Forms]![Form...

would you like to see the structure. i could post it here i suppose

I cannot see how this problem can be overcome. I have it set up to work where Tables A & B get combined into Table C. But with approx 250 records per week getting added I get approx 225 redundant records. I know this is not a good situation. How long would it be before I would notice performance...

But can you insert to 2 tables with within the same statement?

more info I will try to explain a bit better. Table A contains:- TimetableID (PK), Day, Subject, Teacher, Location. Table B contains:- StudentTimetableCode (PK Auotnumber), TimetableID, Student. I would like to append them to:- Table C:- AttendanceCode (PK Autonumber), Date, Day, Subject...

I will try to explain a bit better. Table A contains:- TimetableID (PK), Day, Subject, Teacher, Location. Table B contains:- StudentTimetableCode (PK Auotnumber), TimetableID, Student. I would like to append them to:- Table C:- AttendanceCode (PK Autonumber), Date, Day, Subject, Teacher...