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...

PHV, Thx, for your posting. Actually i even tried Me!TXT_Entries_TotalSub.Requery (.Recalc method do not apply to text boxes). However .Requery is not the best solution as i do not want to refresh / requery the whole form, but just recalculate the one field in the subreport. And, the worst...

KJV, Thx for your posting. However, i'm still at a loss: - No error happens. At least, errors that could be trapped. - The tables have only test records at this point (just a few dozens) - I reduced and eliminated everything else. I wnet back to the proverbial drawing board. There are only...

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...

Just a guess, but you might be missing the reference to the DAO library. LRH L.R. Humberto If you don't know where you are going to, doesn't matter how fast you are going, you'll never get there.

Hi PH, Thx again, but that did not solved the problem either. Anyway, I found the solution: I used the On Format trap event for the section where the affected fields are placed and it worked just fine. Again, thx for your time. L.R. Humberto If you don't know where you are going to...

Thx, PHV, but I need to avoid that. That idea is to click a button and have the cover printed, no preview. L.R. Humberto If you don't know where you are going to, doesn't matter how fast you are going, you'll never get there.

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...

Thx, Jeff, for your input but i'm looking for a function that will give me a bit more flexibility during runtime. Thank you PH for your tip also. I tried it but i'm getting errors. If i leave the field name in quotes (as in your suggestion) the error message states "can't find the field..."...

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...

Thx, John. I'll post my question on the suggested forum.

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...

Thx a bunch!!

Thx, Andrea. The CAST works great but I still have to concatenate the fields after the type conversion. Any ideas on that? Thank you, again.

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...