Search results

Your recommendations worked like a charm - I will be finished with this by the week end thanks to you. CJ - you are terrific at what you do. I could not have done this without you - I learned quite a bit from your help. You are absolutely an asset to the forum. Thank you again for your help.

I did a search for the error - cleared my cache. I tried again - got the same error. If you PM me your email - I will send it over zipped.

Got a security token error - cannot upload my db so that CJ London and take a look

Good Evening: I am a new member - lovely site you have here - really nice people. I have tried to upload my db ad CJ_London suggested and I got a security token error? Can you assist?

You are a prince - I have tried however to upload twice and got a security token error - tried to email the admin - got a security token error

I was able to put it back together somewhat - it isn't doing what I need it to do. It is saving the new current status rather than the OldValue. Old value is not an available option after I enter me.currentstatus. ... after I enter the period in the builder it gives a little drop down - only...

I went from kind of working to not working at all :banghead:

I resolved the AppriasalID issue: I read somewhere that primary/autonumber fields could not be copied from one table to another - I created a calculated field in the table called StatusID which copies the AppraisalId in the main table. The tblStatusHistory.appraisalorderID are linked. So...I...

Private Sub Current_StatusCombo_BeforeUpdate(Cancel As Integer) If CurrentStatusCombo <> CurrentStatus Then CurrentDb.Execute "INSERT INTO[tblStatusHistory]([AppraisalorderId],[oldstatus],[oldstatusdate])" & "values ('" & Me.AppraisalID & "','" & Me.CurrentStatus.OldValue & "','" &...

I also have another question. I just noticed that it is capturing the changed value rather than the prior value. I see that there is something called .OldValue. I am working in Access 2010 - can I apply .OldValue in the code above?

I have had some success thanks to your help and another one of your posts! I used the following: Private Sub Current_StatusCombo_BeforeUpdate(Cancel As Integer) If CurrentStatusCombo <> CurrentStatus Then CurrentDb.Execute "INSERT INTO[tblStatusHistory]([oldstatus],[oldstatusdate])" &...

I got a runtime 424 error. I will post again in the morning. Thank you for your help on this.

Status date defaults to today(). This field is in the tblappraisalorders table. This table is bound to the form. the currentstatus combo box on the form has a set list from the statuslist table. Once selected, the status is saved in the tblappraisalorder.current status and the current date...

Hopeful that someone might shed some light and help out soon...?

I have a form with a combox control that is bound to a table. It is a status field. When the status changes, I would like to take the OldValue of both the status combobox and the status date and move them to a table that when accessed will show a history of the prior status and corresponding...

I am an existing Access User however, I do not do well with coding, modules etc - I typically have to use a manual and online forums if I want to do anything atypical. I am diligent however and will work until an issue is resolved. I have successfully built 2 databases.