Search results

Thank you once again. There are no records created. I will see if I could create a stand alone copy and send you. Meanwhile, please accept my gratitude for persevering with me.

Thanks. I have a normal one to many relationship where I have a parent form and the sub form. The field in question is in sub form. I do have other validation events at form level. I am sure they are not likely to affect what is being done on the exit and enter events. If there was an error...

Thanks. In the actual DB which is fairly large to share, I am using ProjectID which is auto number and even then I had the issue. I will try to change this anyway to see if it works.

Just to help you, I have created a sample db and added the code and table. But it does not quite work in this. I think I might be making a silly mistake. I am using the Parts form to test it.

Private Sub BuilderComp_Enter() Dim strold As String strold = Nz(Me.BuilderComp, "") End Sub Private Sub BuilderComp_Exit(Cancel As Integer) Dim strnew As String strnew = Nz(Me.BuilderComp, "") Call RecordChange(" BuilderComp ") End Sub

Yes, I have. There is just one date field I am trying to track changes for. The only change I made was to add declarations as these were missing and I was getting error.

Yes I have created a table and changed field name in the code everywhere.

Thank you once again for the tip. It is good code but I somehow can't get this to work. I have on enter and on exit as well as Record Change code used it in a sub form making sure that I change field names. I added two public functions to a module. When I make a change to the date, nothing...

Thanks. Will try that. If no luck I will deal with it in MS Excel.

Thanks great. How do automatically I create a record on the many side when user is done amending the date. Would that be after update event or something?

Thanks. Understand but the problem is that in the select query, I have nothing to report in terms of aggregation. I just have dates. I am listing stores by state and store number and two rows of dates planned and actual. Summary option needs something to be summed or similar.

If I may just ask a supplementary question, how do you group values in a union query? The resulting query I have created, has state and store names repeating each alternate row as I have planned and actual dates.

I am sure I am not asking a question that has not been asked before. I have a form and i can capture who edited the form using log in ID. But now the issue that is coming my way is that certain date field are more critical and we need to know who amended those dates and whether it is possible...

Thanks a lot for your kind help.

Unfortunately yes, it should look like the spreadsheet. I have a projects table where I have actual dates for all these columns (or as they become available) and I have created a query where I could generate planned dates using store opening date. So I do have the required data in two...

I have attached a sample spreadsheet. Each store has a planned date which is calculated off the dates in column b and c. The second row is actual date. As much of the data I have is in MS Access, I tried to use some extracts to appear in this format but no luck. I am hoping may be I can...

Thanks so much. That did the trick and it is all good. So very grateful.

Thank Galaxion for the tip. I recreated a sql statement and that does not look any different than what I was using. But I over wrote the statement in the code and I still have the same. error. When I run ? dbOpenDynaset, I get '2' as the number.

I was merely trying to advise Galaxion of the field type in relation to his contact. If you could have a better explanation of the error I am getting, that would be great. I just cannot explain the reason for not being able to use the code if I am using it after a long time.

Just to be sure, I have attached a screenshot FYI.