Search results

Check the templates available on your computer or online, there is one specifically dedicated to contact management.

You could check out this cool search tool

This article might help

Try making a button, using the button wizard, that will open the form you want opened. Have a look at the code behind the button. You can then use that code in a logical test on the field in question. All you have to do is to decide when to fire the test.

Sorry I misunderstood what you were trying to achieve in your initial post. I'll have a think about it, perhaps one of the more knowledgeable contributors in this forum may have some ideas.

Looks like you answered my question before I had posted it :eek: Sorry. Try this page

Silly question, I know, but do you have your control correctly identified in your code?

Just tested Paul's code as well and it works fine too. I'd use Paul's code as it is far simpler than mine.

Not sure why the code doesn't work, as I've just cut and pasted it straight back into a test form, and it works fine :confused: An If Then statement doesn't need an else statement, but in this case it does otherwise the control will remain disabled after the first click, unless there is another...

I trust I've not wasted my time then :mad:

Try Private Sub cmdMailingAddress_Click() If Me.txtMAILINGADDRESSLINE1.Enabled = false Then Me.txtMAILINGADDRESSLINE1.Enabled = true Else Me.txtMAILINGADDRESSLINE1.Enabled = false End If End Sub

Yes you should be able to create a query to collect all the data that applies to any one employee. The way to display this would be to have a single main form, on which you display the employee details, and then have a continuous subform to dispaly all the courses the employee has completed...

kate10123 You've missed named the field in the criteria of your query; You have Like "*" & [Forms]![frmStudentSearch]![Search] & "*" Whilst you should have Like "*" & [Forms]![frmStudentSearch]![Search2] & "*" If you make that change it should work .

OK the only reason I ask, was that I was looking at the UserCP and thought that some were missing. So does the User Cp only show the last 5 received?

Sorry, way off topic I know, but do rep. points have a limited lifespan, or are they permanent? ie. do they expire after a period of say 12 months.

Do mean the sort of thing I've done in this sample?

You could have a pop up to record the number of orders the user wishes to add, and then modify your button to loop through your append query X time. I would think carefully on the consequences going down this path though. ie. accidentally creating excess blank orders. I'm presuming that the...

You will need a field in your table for each of the check boxes, format each of the fields as Yes/No

You will need to change the ctlToShow of ctlToShow.Visible to the name of your control that you wish to show.

Have a look at the search function in this thread, it might be what you are looking for.