Hey All,
I have connected our salesforce platform with our access system so we have read only access to the SF data and run a whole heap of things out of Access instead of having to pay heaps of money for Salesforce Apps then we can also keep the costs low on licences and then we also pump this data out to our clients.
I want to be able to scan a barcode on one of our letters and the scanner put the value in a text box called "Scanned_Textbox_Value"
Then I want Access to change the colour if the query "Duplicate Check" returns more then one value to the form turning "Angry" red... Then if there is only one record turn to Happy "Green" and if it comes back with nothing then "Confused" Orange.
I get that I have to put the macro or VB code into the form or field in the "When Updated" option for the text box but I cant find a way to get the count of a query
Can someone please help
Also if I have posted this in the wrong thread please be nice I am a noob here.