Search results

alright... thanks for the advice. There is no difference. I can see that the save and doEvents make the whole process a bit slower but the result is the same. Last modified record doesn't get updated.

But this has no effect on the outcome.

As you were saying... great minds think alike. While reviewing the code I noticed: I have declared the lngID variable and have not used it. Basically the me.txtID in the SQL statement should be replaced by the variable lngID

No luck... Private Sub cboPoCurrency_AfterUpdate() On Error GoTo ErrHandler Dim db As Database Dim strSql As String Dim lngID As Long Dim dblRate As Double Set db = CurrentDb lngID = Me.txtID dblNCostR = DLookup("ExRate", "Currency", "ID = " & [cboPoCurrency])...

It is the table QuoteLineItems.

Yes but... Just changed it. Obviously it was not necessary but it did not solve the problem. The last modified record still does not get updated :(

But now thinking about it... I don't think it is necessary. just using the table as a record source should be enough. Let me try.

Because each item belongs to a category. So there is another table called tblCategory with a relationship ID -> CategoryID. This is being used in the subform to filter items (cascading combo boxes)

Would it make a difference to run the SQL on the query (that is used as a record source) rather than on the table?

The Exchange Rate is in tblItemNames, it is picked up and stored in the double variable dblNCostR. But the field that gets updated is in table QuoteLineItems. (sorry I made a mistake in the table name. What I have described as tblQuoteItem is actually the table QuoteLineItems that you can see...

Form has the tblQuote as a recordsource and Subform has qryQuoteItemExtended as a record source. qryQuoteItems links 2 tables together: tblQuoteItem and tblItemNames. There is a Master-Child relationship: tblQuote.ID and qryQuoteItemExtended.QuoteID. I don't understand what you mean by "overlap".

Yes it is right. All the records except the "last one that has been modified". Meaning that if I add a new record in the subform, and then trigger the event, all but that record will be updated. Now if I decide to change something on one of the previous records, the last added will work but the...

Hi Gina, Just gave it a try but no luck. Still the same problem.

Hi I have this update query that is triggered by an after update event on a main form. The record being updated are in a continuous subform. It works well except from the last added/modified record. If I save and close the form and then open it again it works for all records but if modify or add...

Turns out that the issue was a data type issue due to Null value. Still don't know why it was working when Sharepoint was not caching.

Hi, My data is on Sharepoint. I have a simple Crosstab query that works well unless I choose the option "Cache List Data". In that case I get a Type Mismatch error. Any idea what it could be? TRANSFORM Sum(PivotData.QuoteTotal) AS SumOfQuoteTotal SELECT PivotData.FullName FROM PivotData GROUP...

So is late binding the only solution? No way to register EXCEL.EXE in its new location or to install it in a specific folder?

You were right, it was a reference issue. I used a code to list them all and then I packaged them with the application. There still is an issue with one reference file: EXCEL.EXE Since some of the machines do not have office I need to package EXCEL.EXE for some pivot table features of the...

I removed my update queries and replaced them by coding.

That sounds like pretty good theoretical thinking to me... I will give it a try!