Search results

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...

Dank je wel Namliam for you comments, the demo was just a database to demonstrate the the question I was posing. The values would appear in a management report. As you can see I am not a professional programmer and only assist if asked by family members. For this project I will stick with...

Gasman, you have made a octogenarian a happy bunny , I am nearly at my desire outcome and will work with your solution. Many thanks Regards Ypma

Gasman, your SQL is almost there , however I need the Not PT sources to be counted as a whole and the PT sources separately. see below Desired out come ,without the dashes . Year--- Not PT----- P T 2019 ----1----- ---- 2 2020 ---- 6 ------ 2 I really like your script and have learn...

Namliam, Thank you very much for you response, its not quite the result I had in mind. As per my demo I only require two two totals per year . Example total for PR and total for Not PR , I hope this makes sense . If you would be so kind as to modify you SQL script so it reflect my result in...