Search results

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

Sorry if this is bunk but I am a self taught VBA user of about a month! Here is the code: Private Sub Vehicle_Make_LostFocus() If Me.Vehicle_Make.Enabled = True And IsNull(Vehicle_Make) Then MsgBox "Vehicle Make Required - please select from list", vbCritical + vbOKOnly + vbDefaultButton1...

Sorry, not getting an error....the problem is that the message box appears and when I hit ok it just continues on. In short I have two fields that if enabled require data (problem resolved by code) The problem is if a user tries to exit the form or initiate a report via a command button, the...

I seem to have the set focus working ok, however I am still struggling with whre to put the code to ensure that the form cannot be closed or updated without the options being complete. I have a print function with a me.refresh command, if I place the code in before update, it warns about the...

Thanks banana, but if I set it to required it kept asking for data even if the field was diasbled. On the same topic, where should I code it, before update doesnt seem to work. I used on lost focus but my concern is that users may not click in the box at all.

Thanks heaps... Two things not a huge deal, but what is the reason for the Cancel = true And It doesnt seem to be setting the focus properly.