Search results

Error checking i.e. when you do a search that comes up with no records, a message box pops up with "No records found".

Yes. I think the only way to write to a bound control is through a query.

Add this code to the Pop-up form's Close event: Form_Form1.Combo1.requery Obviously substitute the Form1 and Combo1 for the names given in your database.

The Calculated control works perfectly using CDate. The problem is replacing the value from the text box that is bound to the underlying table. The error occurs when you try to manipulate that bound control's value with code.

Instead of putting the code in the form properties, use Code Builder and enter the following code: [Forms]![Record Attendance]![Calendar of Attendance]![scrStudent] = Me.scrStudent I have tested this and it works perfectly.

Me.txtBound = Me.txtCalculated I suppose I could write a query to update the underlying table, but there must be an easier way?

Thanks for your help. The only problem I now have is trying to replace the bound control's value. I get the error "you can't assign a value to this object". How can I get around this?

I have added a search form to your database. There is no error checking, so you will have to add this yourself. I hope it's useful.

I have used the Microsoft Create a Stopwatch Form in Access 2002 article: Link to Article I have used the stopwatch as part of a timesheet system to bill time spent on user Support projects. The Text Box is bound to a field, so that when the clock is stopped, the value is entered into the...

The list boxes are set to show the the count value (i.e. 5) from a query: SELECT Sum(Leave.NoOfDays) AS SumOfNoOfDays, Leave.UserID, Leave.LeaveType FROM Leave GROUP BY Leave.UserID, Leave.LeaveType HAVING (((Leave.UserID)=[Forms]![Main]![cbonames]) AND ((Leave.LeaveType)="PL")); I don't know...

I have several List Boxes on my Form, which take their value from Count Queries. Each list box shows the number of occurances of a particular name in the main table. The problem comes when I try to add the values together from the list boxes, they are all null although they do show the correct...