Search results

Just tried and now I get the error: Overflow

Ok... I have extracted relevant tables, forms and queries. It is a bit messy as I have taken over an existing database with macros :bang head: and I haven't converted everything back to VBA yet. Click on the first column and you get the form. There are two currency drop downs on the main form...

Thanks. Can it be sent in private?

Yes I can. No problem with that (I am making an answer longer than 10 character as the blog won't let me post just "yes")

Kind of difficult to upload. I need to make my tables local and somehow it creates errors. I have tried what you are suggesting already It crashes from the loop line. I have also tried to use the recordsetclone in which case it doesn't crash anymore but I get the following error message: Update...

I have just compiled it and tried again... Still crashing: "Microsoft Access has stopped working..."

Well that's the think. It doesn't say anything... Just that Access has stopped working.

Hi, My application crashes when trying to change the value of a text box in a continuous form. Here is the code: Private Sub cboPoCurrency_AfterUpdate() On Error GoTo ErrHandler Dim rst As Recordset With Me.sbfProductDetails.Form Set rst = .Recordset rst.MoveFirst...

Thread moved to: http://www.access-programmers.co.uk/forums/showthread.php?p=1359210#post1359210

Hi Not double posting but just moving a thread where it should have been started. 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. My tables are...

Sorry about that and thank you. But it is not a web app, it is a desktop app with linked tables.

:eek: :o Oops! I have omitted to share a piece of information. My tables are linked to SharePoint lists. I have tried to strip the application and to do so I imported relevant tables, form, queries and procedures into a new file. I converted the linked tables into local tables and... It works...

Thanks Gina and sorry I had to dash... I know I have cut you in your mission ;-) I am working on it know and will send shortly. Thanks again for your help!

Ok will do! Thank you!

tried Me.sbfProductDetails.Requery but no luck Is there a way to send you the strip file later? I'm sorry but I need to leave now. I can send it later in the afternoon. Thanks so much for helping with this.

Well it's about lunch time on a very sunny day here... I'm based in Hong Kong.

Can it be sent in private? I would take a bit of time to strip it.

and unfortunately... No effect. Private Sub cboPoCurrency_AfterUpdate() On Error GoTo ErrHandler Dim db As Database Dim strSql As String Dim dblRate As Double Set db = CurrentDb dblNCostR = DLookup("ExRate", "Currency", "ID = " & [cboPoCurrency]) dblRate = dblNCostR /...

Yes thank you so much for trying!!! And it must be very late for you!

I just turn the problem around in my head and really I can't see. It's making me crazy!