BHA Consultancy

[BHA Consultancy @BhaConsultancy]

Start of 2018. Been busy updating the CRM to V2. Full size forms. Moved Web.Config to a table so users can maintain parameters. Added action based user permissions instead of Windows Groups. Now considering outgoing and also incoming email.

[BHA Consultancy @BhaConsultancy]

@daveedwards10 Dave, thank you so much for your coverage of SOGB 2017. Your publicity of our young people will really help.

[BHA Consultancy @BhaConsultancy]

Currently testing Access DB using Access Run Time and .net timesheets on the User server. So far so good. No show stoppers.

[BHA Consultancy @BhaConsultancy]

Needed to create a script to add in history for records not affected by sql triggers.

[BHA Consultancy @BhaConsultancy]

Been busy using SQL Triggers to add a history to a couple of tables. Took some working out for delete as the trigger runs in a Service User.

[BHA Consultancy @BhaConsultancy]

On CRM V2 worked out how to link Actions to User Permissions. IMO better to show dim Action name rather than hide it to know its there.

[BHA Consultancy @BhaConsultancy]

Completing the CRM V2 update in .NET I found out what SQL Server Referential Integrity means when I inadvertently ran a Test script on Live!

[BHA Consultancy @BhaConsultancy]

@BhaConsultancy Access DB successfully migrated to SQL Server at the 2nd go in Live. An old driver caused the first attempt to fail.

[BHA Consultancy @BhaConsultancy]

@BBCSPOTY Congratulations to Andy Murray but how did the trophy get to him in Miami when the vote took place and was counted this evening?

[BHA Consultancy @BhaConsultancy]

Currently busy with a couple of new projects. Convert MS Access DB to SQL Server. Develop V2 of our .Net CRM. Already V3 is on the horizon.

[BHA Consultancy @BhaConsultancy]

Got an answer to my HTML5 query. My form is working now. Solution was to turn IE Compatibility View Off as On means don't use new features.

[BHA Consultancy @BhaConsultancy]

Working on HTML5 autocomplete lookups. Works on Dev wont work on Prod. Prod adds extra HTML. Raised StackOverflow question hoping for answer

[BHA Consultancy @BhaConsultancy]

CRM revamp using a tabs solution. The plus with tabs is that the tab stays on current info when a different tab is selected. Neat solution.

[BHA Consultancy @BhaConsultancy]

Currently busy revamping the CRM app with a new User Interface.

[BHA Consultancy @BhaConsultancy]

Spent several days getting app to use a new email account as original deleted. It was planned to take 10 mins, it actually took 7hrs+.

[BHA Consultancy @BhaConsultancy]

Authorisation by Activity functions now stored in model not DB. At login valid functions put in array for speed of checking.

[BHA Consultancy @BhaConsultancy]

Authorisation by Activity is working now. Functions and Roles are stored in the DB. Need to see if elements can be stored in Model.

[BHA Consultancy @BhaConsultancy]

Currently working on C# Authorisation by Activity to replace Authorisation by Role. Also looking at C# soft menus.

[BHA Consultancy @BhaConsultancy]

Prices and Quantity Breaks worked out but need the customer to advise on how this should be presented.

[BHA Consultancy @BhaConsultancy]

Working out how to display price lists and price quantity breaks on the CRM Branch screen so that Sales staff don't look this up manually.