Search results

Pat, in my demo post 36 I have call the function in the after update event and entered the following in the FORMS before the update event , should this suffice or am I missing something ? As a user and not a professional I am keen to improve my best practices If (IsNull(Me.Gasprice) Or...

Case name not correct Case "Gprice" Me.G_price = Me.G_total / Me.G_amount change all the case names Regards Ypma Uncle beat me to it .

I am in the process of modelling my example on Uncle's solution. I have got it to work ,it only a demo so error handling not yet completed, also i have placed the call of the function in the after update event ,you might move to to the before update event as suggest by Pat. Let me know how you...

Error noted and will rectify ASP Ypma

Silverson, I am assuming Uncle Gizmo's demo which I have tested is too complex for you to use in your database. I am still not 100% what your exact requirement is but have had another attempt . My demo assumes that two of the three fields are blank and one field has data by entering data in...

Uncle Gizmo, I revisited your demo and when I tabbed to a new record it produce the required results , I was trying change the figures on the records your created , with no results and assumed it was not liking my version. I was impressed with your script and will learn from it, for any...

No problem, I knew you were mistaken, as nobody had accused me of posing well written and clear questions. Regards Ypma

Uncle Gizmo, thank you for the courtesy of replying , you are confused as I did not pose the original question but tried with my limited knowledge to provide a solution. The reasons why silverson wanted the scenario is not clear to me. Regretfully I could not get your example to work , yes...

Pat ,my understanding of the question was that result of any one of the three fields in question could be calculated using the data from the other two fields . You state that F will automatically change but , no mention of other scenario where F and A are given to provide B . Does your...

I tried a command button to obtain the three different results . Private Sub Command3_Click() If (IsNull([ValueofGas])) Then ValueofGas = amountGas * Gasprice ElseIf (IsNull([Gasprice])) Then Me.Gasprice = Me.ValueofGas / Me.amountGas ElseIf (IsNull([amountGas])) Then Me.amountGas =...

Hello Jollland26 as a user, I use the following in the after update event Me!Combo729.Requery Me!Combo729.Value = Null Hope this of use to you Ypma

Enjoy.

Gismo: I use a vbs script to decompile and will attach , You will have to edit the script and enter your own database name . WSHShell.Run Chr(34) & MSAccPath & "MSACCESS.EXE" & Chr(34) & " " & Chr(34) & currentDirectory & "\YourDBname.accdb" & Chr(34) & " /decompile" Hopfully it will work for...

Gismo, as a user not a professional , I would look at the current and load events and eliminate them as a starter .I am sure others will be able to give you more suggestions . Regards Ypma After thought check that any indexed are still in place for and client number etc

Have you tried the clicking the visible property of the field you wish to have as not visible , go to design mode of the report and click on the field , and under format you should see the visible property . Best of Luck ops i was too slow Arnelgp beat me to it. Regard Ypma

Your most welcome, To concatenate is to join one or more fields together in Microsoft Access. There many example, if you care to Google . Regards Ypma

How about Me.Full = Me.Last & "," & Me.FirstName regards Ypma

Gasman : Thank you for you input. I took your advise and moved the IIF calculations into the query querytraining which has the training table as its source. I can now open the query extra fees which has the querytraining as its source and tick the appropriate check boxes and the records are...

Thanks for all who took the time to reply. Gasman , I tried using update , however the calculated fields don't seemed to be recognised . The_Doc_Man , I don't have problem with the query as mentioned in my Post 1 . The demo database shows exactly what I am trying to achieve, I notice that...

EDITED BY THE_DOC_MAN to correct the code bracketing. NO edits to the actual content. I would appreciate advice on updating a table via a select query which has two IIF fields .Query SQL below SELECT QueryTraining.ID, QueryTraining.FirstName, QueryTraining.Hampshire...