TheSQLGuru (3/6/2015)

---

Scott Coleman (3/6/2015)

---

Hopefully the CRM app rarely does "SELECT * FROM dbo.notes" on the whole table, so doing that in Management Studio is not a useful test. You're...

seshurtz (3/6/2015)

---

hi dschubel,

I would usually start troubleshooting an issue like this by using the "SET STATISTICS IO ON" and "SET STATISTICS TIME ON" feature in my script, turning on actual...

I'm actually trying to trouble shoot poor performance with the Suite CRM application....

Bummer, us Phillies fans were hoping to see him take the hill one last time here later this month. I'll always remember him digging up the rubber and leaving the...

This may be a bit over simplified, but I usually do something like this:

Set the form's Record Source:

SELECT tblQuote.QuoteDate FROM tblQuote WHERE Quote = '2007-5434A';

Then adjust the Record Source via...

View the properties for the field, on the data tab make sure Enabled = Yes and Locked = No. Also view the properties for the form and make sure that...

Moneyball - the movie? With Brad Pitt playing Billy Bean? Great book that made me see the game differently, but I'm not sure about how it will translate to the...

I've used the following to restrict user access. Usually by locking controls on a form or making things invisible

Dim stUser As String

stUser = GetLoginName

Select Case stUser

Case "DAVID", "KATHY", "JO", "Micheal"

...

Could you possibly save the reports as PDF?

I have had similar issues when the table included a column that used the bit datatype. Setting a default value of 0 fixed the problem.

Yes, in my example "Me.FilePath" is a reference to the field on my form that contains the path and file name of the file to be opened.

I have used the following to hyperlink to any file type. I assume it would work with Crystal Reports.

I keep the list of files in a table and use contents...