Search results

Dates Check this link. The sample database you can download has what you need. http://www.access-programmers.co.uk/forums/showthread.php?t=62570

DCount That works great! Thanks Pono1 :)

In the After Update Event of the field Lastname I have some code to check if a person with that First- and Last name already exists in the database: If DCount("*", "[tblPeople]", "[LastName]= '" & Me.LastName & "' And [Firstname] = '" & Me.FirstName & "'") Then Beep MsgBox "This name already...

Search Search the Sample Databases in the Forum, there are some excellent examples.

X of Y Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=85863

Query Use an Append Query. You can check the Help Files and this Forum about how to use it.

Disable In the After Update Event of the Check Box put something like this: If Me.CheckBox1 = True Then Me.txtField.Enabled = True Else Me.txtField.Enabled = False End If Replace 'CheckBox1' and 'txtField' with the appropriate names.

Combo Box Check this Link: http://www.fontstuff.com/access/acctut20.htm Or search the forum on 'not in list'

Read only You could put this code somewehere, may be in the On Opening Event of the Start up form: Me.AllowAdditions = False Me.AllowDeletions = False Me.AllowEdits = False

Number Don't know how to do it, but if it's for display purposes only I'm sure you don't need to do it. Use a query and sort the records on the Time Field and then use a Running Sum to display the records on a Form or a Report. May save you a lot of work (and trouble)

Pdf Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=55943&highlight=open+pdf

Focus Before you execute the code that generates the error you have to set the focus on the control involved. Me.yourcontrol.SetFocus (replace 'yourcontrol' with the actual control

Combo The column count of a combo box starts at 0. Setting the bound column at that value may do the trick.

Effect Ha, found it on a CD. Must have saved it back then...and forgot about it. And now I know it was on the site of Candace Tripp. Here's what I was looking for.

No, I'm afraid that's not it either. The sample I remember had a module and some code behind a command button that would close a form as described. And there was the option to pre-select the desired wipe effect. But thanks Michael.

Search Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=65331

No, that is not what I had in mind. However, the link you provied is very useful too. There are some techniques shown that may come in handy. Thanks GHudson :)

Some months ago I visited a site that, among others, had a sample mdb including nice 'wipe' effects for forms. Closing the form from left to right, top to bottom etc. I should have saved the link, but I didn't. Does anyone know which site it might have been, and/or, is anyone familiar with...

Combo This link will help: http://www.access-programmers.co.uk/forums/showthread.php?t=68985

Subform Don't know what causes it. The best thing to do is using a query to base the subform (and any other form) on. In the query you can specify the sort order of any field or combination of fields.