Search results

Report Probably the best way is to group the facilities in the report and put the count result in the group footer. In Design View, go to File/Sorting and Grouping, select the Facility field, group on Each Value and set Group Footer to yes.

form The problem may be that you have no record in the main table yet, if you have a main table and a sub table, linked one-to-many, you need record in the main table first before you can put one in the sub table.

Form In Design View, go to Properties, on the Data Tab set Allow Additions to YES. One more advice, use a query for your form instead of binding it directly to the table.

Maximize In the On Open Event put: DoCmd.Maximize

Check In the After Update Event of CheckboxA put something like this: If Me. Checkbox A = True Then Me.CheckboxB = True Else Me.CheckboxB = False End If

Web sites Try this one: http://www.microsoft-accesssolutions.co.uk/index.htm

Print Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=49415&highlight=print+current+record Or search this forum: print current records, lots of posts on this subject

Title In design view, go to properties/format tab, you can set the caption there

Combine Try this: =Left([Field1],1) & Left([Field2],1)

Macro No need for a macro to do this. In fact, try to stay away from macros all together since you cannot do error trapping using them. In the On Click Event of the button put something like this: Me.textboxname.Visible = True

Trap Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=38364&highlight=mouse

Direction You're welcome.

Direction May be you can use columns. Go to File/PageSetup/Columns. You can specify the data go across and then down.

Hide How about trying this code To show the database window: Docmd.SelectObject acTable, , True To Hide the database window: Docmd.SelectObject acTable, , True Docmd.RunCommand acCmdWindowHide

Copy Instead of saving a 'fixed' copy you can use a parameter query for the report. That way you will be able to generate the report based on start- and end date at any given time. You can view the results per month, per week, quarter, year or between any dates you wish. It also means you don't...

Dob In the After Update of the Field DOB put this: Dim Age As Double Age = Year(Now()) - Year([DOB]) If Age < 16 Then Me.Junior = True Me.Senior = False Else Me.Senior = True Me.Junior = False End If

Flash Check this link: http://members.iinet.net.au/~allenbrowne/ser-46.html

Report Try this. Open the report in design view, go to view/sorting and grouping. Select the group, and in Properties on the last line, set Keep Together to Whole Group.

Input Mask Instead of using a mask, which is not very user friendly, you can do this. Put the following code in the After Update Event of the field: Dim t_Lastname As String t_Lastname = UCase(Left([Lastname], 1)) & Mid([Lastname], 2, 40) Me.Lastname = t_Lastname After the field is updated...

Password Check out this link, there is a sample db there that demonstrates what you want. http://www.candace-tripp.com/_pages/access_downloads.asp