Recent content by Melaz29

In the forms after update event Private Sub Form_AfterUpdate() If Me.Yourdatefield<= Date Then MsgBox "Date field should contain future date value - please check", vbCritical + vbOKOnly + vbDefaultButton1, "Error" End If End Sub

Create a query Create a query using the fields you require and design a form based on the query. post your db if you like and I will show you.

Use a Query Create a query that lists all files and in the criteria for volunteer ID Like[Forms]![yourformname]![volunteerID] Then use the subform wizard to create a subform based on the above query.

Change Default Value in the data properties of the form. Delete your "on open" event and change the default read "John Franks" (include the inverted commas), works fine Not entirely sure what you are doing with the techassign1 drop box, will there be more than one person appearing in the future?

Upload If you upload your db I will have a look.

Why are you not using a query to filter the records and printing a report based on the query?

Incase anyone is interested I found this and it is brilliant: http://allenbrowne.com/AppFindAsUType.html#Installation

I have been hunting around to find exactly what I need but cant seem to find it... what I need is a way to do a string search within a particular field (surname) and then filter by that string????? Any ideas or point me to the right thread will be much appreciated.

In the words of a work collegue....BRILLIANT! Thanks heaps You are a star! :D

I tried searching everywhere and cant seem to find an answer to this one... Is it possible to have a default value in a table which would be current month and year + text? Eg. mm/yy "text" =now() & "text" is fine but I need to format the date to mm/yy and cant seem to get it right. eg. 08/06...

Create a query and a form to run your query from.... Have date fields and a combo box (with the rep IDs) on the query form and use those for your criteria. Then use a command button to execute from the query form.

Can you zip your db and I will have a look?

For what purpose If you need to do a string search, cant you use a form with a text box and use a string search for the criteria using - Like "*" & [Forms].[Form1].[Text0] & "*"

It is ok I am an idiot....the report was missing the data so it wasnt updating at all....which is correct........the code will not let you exit so they will have to enter data. Thanks heaps for your help!

i placed it in the lost focus so as the users left the field that would get an error. Ok I have placed it in before update on the form, it stops me exiting the form but if I use the print report commands (as I said they have a me.refresh command included)....the errors appear but the report...