Search results

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 -...

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

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...

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...

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

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?

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...

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...

no problemo!

Maybe try with a toggle button, instead of a cmd button

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

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

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...

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...

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

Ahh I see what you have done now... the "original" record is changed and saved, then the "new" record is inserted with the "original" values. Now, to throw a wrench in it, how hard would it be to add a timestamp and username onto the "changed" record. Would it be possible to set the If criteria...

So for this table (recordset) the PK is an autonumber field "PartsPricingID". How do I include that? The foreign key is the part number, which I gather I have to include as well...

Hehehe One more "one more thing"... If Me.Dirty = True Then If varPart <> Me.partnumber Or var1 <> Me.one Or var2 <> Me.two Or var3 <> Me.three Or var4 <> Me.four Or var5 <> Me.five Then DoCmd.SetWarnings False Set rs = CurrentDb.OpenRecordset(Me.RecordSource...

Cool, thanks dude. One more thing, since this is occuring in a subform that is linked to the main form by the part number field, do I need to bring the part number as a variable to the new record? or will that happen automatically along with the PartPricingID (autonumber) field? But it should...

Since any of the fields that would be changed by a user are all numbers or a checkbox, would it be beneficial to store the variables as doubles, integers and currency? Also, instead of a command button, what if I put the me.dirty check in the subform's before update event? And since I have...