Recent content by Colin@Toyota

  1. C

    Unbound form with a bound subform

    Is this possible? I have a data entry form that I can't quite get to work. I have an unbound form with 5 fields on it... Part Number, Part Desc come from one table, Category comes from another (many parts - one category), and Source, Default Exchange Rate come from the last table (many parts -...
  2. C

    On Dirty, save all changes as NEW record

    FINAL UPDATE: Got it working. Somehow, the parent/child link between form and subform was gone... replaced it, and it has worked since. Also, I took out the one-by-one approach to revaluing the fields, and went with me.undo. Thanks to everyone who helped! Cheers, Colin
  3. C

    On Dirty, save all changes as NEW record

    UPDATE Everything to do with the records saving, etc is working, just now when I open the form and go through the part numbers, all the info displayed in the subform is the same as the first record. I think it has to do with the how I reset the fields in the before update event... Here is the...
  4. C

    On Dirty, save all changes as NEW record

    So I have the code sort of working... I tried it, forgetting to reset the fields to the original values, and it added a record with the changes, but changed the original record too. That's ok, I think I can handle fixing that. For some reason, the subform then displayed the "changed" values of...
  5. C

    Allow Edit on cmd Button Click

    Or maybe have two cmd buttons... one containing: Dim cntrl as Control For each cntrl in me.Controls .cntrl.locked = true Next cntrl and the other... Dim cntrl as Control For each cntrl in me.Controls .cntrl.locked = false Next cntrl
  6. C

    Allow Edit on cmd Button Click

    Hmm... I am by no means an Access or VBA expert, so nothing immediately jumps out to me as being wrong... Could you try using the toggle button with the locked property?
  7. C

    On Dirty, save all changes as NEW record

    I've got that down, but if I need the timestamp to go with the "changed" record. I may have misunderstood your post, but I thought you were saying to save/move the unchanged record into a temp table, and save the changes to the existing record... which as I type this, no longer seems like it...
  8. C

    On Dirty, save all changes as NEW record

    So in trying to run the code, Access is balking at the cntrl.value = cnrtl.oldvalue line... saying "object does't support this property or method" hmm...
  9. C

    password field in ms access

    no problemo!
  10. C

    Allow Edit on cmd Button Click

    Maybe try with a toggle button, instead of a cmd button
  11. C

    password field in ms access

    Go to the control's properties... to the Input Mask. Select password.
  12. C

    On Dirty, save all changes as NEW record

    All the pricing data (current and historical) are in the same table... The only issue with saving changes to the current record, is that I need to time/date stamp the record with the changes
  13. C

    On Dirty, save all changes as NEW record

    I'm missing an End If in there too... I will also need to set the fields in the form back to the values stored in the variables somehow so that Access doesn't automatically save the changes because the form is dirty... Would it be best to call the variables back to each of the text boxes? or...
  14. C

    On Dirty, save all changes as NEW record

    Adam, I'm gonna try this tomorrow, as I want to go home now. Thanks for all your help! Here's the code I came up with: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim cntrl As Control strTimeStamp = Now() strUserID = Environ("UserName") If Me.Dirty = True Then...
  15. C

    Adding New Child Record

    I'm working on a similar (sort of) problem here... Maybe it will help
Top Bottom