Recent content by Krayna

  1. K

    SQL Server Query

    Thank you. I have looked through the syntax and corrected a couple of other things. I find that the main issue is that I can't use a calculated field from the query in another calculated field in the same query. What do you suggest I do?
  2. K

    SQL Server Query

    Hi, Having trouble with syntax in a pass-through query. Keep getting a syntax error and I don't know T-SQL well enough to understand where I've gone wrong. My SQL is: SELECT dbo.tblOrders.*, dbo.tblAddress.*, CAST(ISNULL(([fldototalquote]*([fldOvatpercentage]/100), 0)*([fldovatrate]/100)) AS...
  3. K

    Solved Cumulative Total in query

    Your last solution worked best :) Thanks for the suggestions Have a great day!
  4. K

    Solved Cumulative Total in query

    Tried that but now it won't format any values in column to currency.
  5. K

    Solved Cumulative Total in query

    @arnelgp it works great. Can you explain your approach please? Also is there any way to have a blank result when no total income - at moment it shows a £0 but its misleading. I attempted several methods but it would either show Error or would not format column as currency.
  6. K

    Solved Cumulative Total in query

    @arnelgp I need your help again with this please. The numbers are not tallying for the income column and can't figure out why! I have attached same DB. Query you supplied is named: qryPropAccInc. If you open on the first property, it appears they are in debt -6855! Not sure how this happened??
  7. K

    Solved Saving procedure in datasheet form

    Thank you managed to work it out.
  8. K

    Solved Saving procedure in datasheet form

    Hi, I have a datasheet form for data entry purposes only. I would like to validate the data user inputs once a record is input but before creating a new record. Have tried several events but couldn't achieve desired outcome. BeforeInsert/BeforeUpdate fires for every new field entered - I...
  9. K

    Connection to Google Calendar

    Hi, Thanks for the direction points above. I stumbled on this youtube link which explained how to integrate Google Calendars into SQL Server using Visual Studio. It was quite a journey to follow but I did manage to get it working to the point that the calendars are linked to a similarly...
  10. K

    Solved Multiple Recipients Resolve trouble

    Thank you. Worked perfectly like that!
  11. K

    Solved Multiple Recipients Resolve trouble

    Hi, I am trying to set up an email command which sends the message to multiple recipients. I've tried many approaches but always throws error 'can't recognise one or more names' after the send command. If I do 'display' it will send once it has resolved the email addresses manually. Can anyone...
  12. K

    Save updates when multiple users editing record

    Actually our system has been up and running for several years already but we are constantly improving based on user feedback and changes in requirements. This was just one issue that has arose from use. Good to know though.
  13. K

    Save updates when multiple users editing record

    The structure of this database is a main job list. Users can update the jobs e.g. mark as complete by opening the main job form or by knocking off the summary form which lists jobs which are due today. So if a job is knocked off the list and marked as complete, it may be opened at the time by...
  14. K

    Save updates when multiple users editing record

    It is a very rare occurrence but if I would implement DocMan's approach - which doesn't seem to be too much extra work it would reinforce the DB's accuracy and predictability. Would it work to add generic code in each of the relevant form's BeforeUpdate event?
  15. K

    Solved Cumulative Total in query

    Thank you arnold Yes its a test DB - the data is totally fictional.
Top Bottom