Search results for query: *

Hello all! I need to create an ODBC connection (for data mining purposes). Problem is, the SQL server resides in a different domain. Long story… In short is a separate domain from the “main” firm wide AD (no trusts in place), just a few individuals will access that file / data server through a...

Hello all: I have i three-level form destined to control cos acounts. In a simplifications the tables in use are Firm, Accounts and Account-Entries. The tables have relations ships as: One Firm has many Accounts, which may have many entries, all based on foreign key (sorry if this is TMI, but I...

Hey folks, Should be a simple task but... In a small application the user has the ability to decide a few characteristics of the fields to be printed in a report cover (what font size, bold: yes / no, Italic: yes / no). Problem is although I’m changing the properties for the fields (using...

Hey folks! In a form, a few fields should have their format (font color, type and weight) changed based on their value. I created a function to be called once for each of the necessary fields, from within the OnCurrent trap event. My problem is: how to pass the field name to the function (it...

Hello to all, This question probably pops up time to time, but training centers also come and go, so here we go again: what are the best places of the moment for in-class (not looking for web courses) Transact SQL training for somebody with a medium level of experience? The final objective...

Hello to all, I'm preparing a report on databases for an internal group and I would like to post the current marketshare (both by servers and $) for the top databases (oracle, db2, MS SQL, etc). I searched around on the "googleland" but could not find anything current enough or the numbers...

Hello to all, I'm preparing a report on databases for an internal group and i would like to post the current marketshare for the top databases (oracle, db2, MS SQL, etc). I searched around on the "googleland" but could not find anything current enough or the numbers were conflicting. Would...

Hi Folks, For a SQL View I need to concatenate three different columns of a table and group the table by the result of that concatenation and sum a forth column on that grouping, but i cannot find the correct sintax. I tried using just the "&" (copied the sintax from MS Access "sql" view of a...