Search results

  1. S

    Copy/Duplicate record problem

    I created a sub form to track labor hours. I designed it and tested it before I put it in the main form. It is a continuous form. I used the Command Button wizard to insert a button to duplicate the records. It worked better than I had anticipated. I have a default value in the date field...
  2. S

    Duplicate Record Problems

    My duplicate record button works perfectly when the form is open seperately. When I open the form as a sub form the button no longer functions properly. It creates a new record but it doesn't copy any of the information. I have tried changing the code but to no avail. See code below. This...
  3. S

    Form doesn't work as a subform

    Probably an easy fix for someone with a little more experience. I have a continuous form that I designed as a subform. I have a "copy record" button at the bottom. When I open the form by it's self the button works perfectly. When I open the main form and click the copy button in the sub form...
  4. S

    run time error 2107

    I get the subject run time error when I try to past a record. The error reads: "The value you entered doesn't meet the validation rule defined for the field or control." Then it takes me here in the VBA: Private Sub cboEmployee_AfterUpdate() Me.RecordSource = "qryHours" Me.Refresh...
  5. S

    Sum a limited number of items in a Continuous Form

    I am using a continous form for time keeping purposes. It looks somewhat like this: Project | Week | Mon | Tues | Wed | Thur | Fri | Comments| ABC |03/31/08| 1 | 0 | 3 | 2 | 0 | Design Work | XYZ Etc The form displays the last month's worth of work. I would like...
  6. S

    Need Help Simplifying

    All: What I'm trying to do: I want to be able to use a switchboard button (or a button on a form) to open a unique form. OK, true, that's easy. Here is where I am having trouble. I want that one click to set the title of the form and the criteria for the query of a subform. Basically I want...
Top Bottom