Search results

Code Hmm.. may be a version problem. Which version of Access are you using? If you post the db (without sensitive data) I'll be happy to look at it. :)

Form In the On Click Event of a field in the subform you can put some code like this: ****** Dim db As DAO.Database Dim rst As DAO.Recordset DoCmd.OpenForm "frmFault" Set rst = Forms!frmFault.Recordset.Clone rst.FindFirst "[FaultID] = " & Me.FaultID Forms!frmFault.Bookmark = rst.Bookmark...

Search May be this link will help: http://www.access-programmers.co.uk/forums/showthread.php?t=75365 There several search examples here, just search the forum.

Move Another thought is that you will need a way to reverse the process, in case the wrong record has been moved, or in case an employee who left decides to come back. So for the second table you would also need a form with a button to move the record back to the first table.

Move You could ad a yes/no field to the employee table, and for instance set the field to 'True' in case the record needs to be moved. Then put some code behind a command button that does the whole operation for a current records in steps: 1 - Set the field to 'True' 2- Save the record 3...

Moviestars Here's a database that has a table with 793 actors and actresses from the USA. Good luck..

New Record In Design View, go to Properties/Data Tab and set Data Entry to Yes. That way you will see a blank record when you open the form. It is good policy to use a query as record source for the form instead of a table. That way you can retrieve only those records you need (select), you...

Count You can put an unbound box in the footer of the subform and set the control source to: =Count(*)

Wheel If you had searched the forum you would have found these threads: http://www.access-programmers.co.uk/forums/showthread.php?t=38933&highlight=disable+mouse+wheel http://www.access-programmers.co.uk/forums/showthread.php?t=2096&highlight=disable+mouse+wheel...

Form Do you want to display the PropertyID in the Header of the subform? You can put an inbound box there and set the control source to: =Forms!frmContacts!PropertyID

Form Put the subform on the main form and set the Master/Child fields. That will 'synchronize' the records in both tables, provided there is a correct one-to-may relationship. In case you do want a separate form use the solution that is given in this thread...

Search Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=75365 Thre are other examples as well, just search the forum.

Subforms You can put the subforms on the main form with the master/child fields linked correctly (they can be on top of each other and make them visible or invisible as needed. For instance: use a command button to make subform1 invisible and at the same time make subform 2 visible...

Print You have to identify the record you need to print the label for. Check this link: http://www.mvps.org/access/reports/rpt0002.htm

Print You can use the label wizard to create the desired output, this way you can select label size and the fields you want to print. The command button should enable you to print a label for the current record. Please search the forum, there are plenty of posts on this topic.

Pdf You can select the printer before printing the report. Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=75887&highlight=default+printer Or this one: http://www.access-programmers.co.uk/forums/showthread.php?t=79768&highlight=print+dialog You can also open the...

Default You can assign the values of the 5 fields to variables, just before you go to a new record, and then assign the values of the variables to the corresponding 5 fields as soon as you open the new record. You can put a command button on the form that clears the 5 fields when needed.

Macro Please do not post your question multiple times.

Form Have you specified the data source for the form? Parhaps you can post the db (without sensitive data) so someone can have a look.

Fields Put the following code in the On Current Event of the form: If IsNull(Me.Department) Then Me.Job.Enabled = False Me.Classification.Enabled = False Else Me.Job.Enabled = True Me.Classification.Enabled = True End If