Search results for query: *

Since MS has Abandoned The product, Where have the adherents moved to? Since there are probably several choices, is there any discussion of the relative merits &/or demerits of the possibilities?

I would like to be able to access the "update date" of the various MS Access objects ... Forms, modules, tables, Reports Databases, ... et al as well as the sub entities. I can easily(?) get the various objects via the containers, but do not see any data properties associated with rather the...

After reviewing numerous threads numerous small clues in several allowing the turtle like speed of my 'brain' ... The last and apparently most necessary: you MUST [COLOR=red] save AND compile all modules /[color] before creating one! Compile does NOT (as was pointed out) save the module (it...

Thread 705-153380 provided the function code below. I know it worked when posted for Ms. A. 2K. I am trying to use it I Ms. A 2003 and get a failure on the line indicated (to SAVE the newly created object). The error is : Debug.Print err, Error(Err) 29068 Microsoft Office Access...

I have read many of the threads reefering to this. I undersdand that they generally refer to the scope of the variable. Brief statement of this situation: 1.[tab]I have searched the APP for type declarations there is only ONE. It is in a code (not a form) module. 2.[tab]I have traced it...

exploring the table.field.properties ONE of the properties is "Attributes" Two of the attributes APPEAR to have the same value? from the Object Browser --> DAO --> FieldAttributeEnum ? dbDescending 1 ? dbfixedfield 1 huh? Which guru can provide some insight into this? How might one...

Does anyone know where to find a discussion; 'map'; deffinition; etc of the object browser? I confess to realizing that it contains a huge amount of information. I further confess to a degree of confusion on finding the specific information I want at any particular time. The current 'object...

Declare @cols as nvarChar(MAX) With YearsCTE as (SELECT Distinct YEAR(OrderDate) As [YEAR] From Sales.SalesOrderHeader) Select @cols = IsNull(@cols + ',[', '[') + Cast([Year] as nvarChar(10)) + ']' From YearsCTE Order By [YEAR] /* Construct the full T-SQL statement and execute it...

I am trying to get through a adventure works tutorial from MS. Alas I get part way through chapter 2 and run into an issue. The script fails attempting to create a table Statement. I include the entire code, as I am quite unsure of the root cause see the comment line highlighted in RED...

Having read many of the suggestion, some directions and a few horror stories, I am about to start the oft delayed process. To this end, I have a few(?) questions: Do we really move ALL tables (even the local ones) to a seperate BE? (Assuming Yes to the above), SQL server is advertised to be...

Having read many of the suggestion, some directions and a few horror stories, I am about to start the oft delayed process. To this end, I have a few(?) questions: Do we really move ALL tables (even the local ones) to a seperate BE? (Assuming Yes to the above), SQL server is advertised to be...

/// WROX C# 2008 pp 57-58 Mathlibrary (Example) // Error 13,.4 & 13.26 " ... missing using directive of an assembly reference ... " using System; ///using MathLibrary.dll; namespace WROX.ProCSharp.Basics { class Client { public static void Main() { MathLib mathObj = new MathLib()...

New & confused. I am T R Y I N G to grow up to these new languages. I have the program (C# Express) and the Book(C# 2008) from Wrox. as the old joke goes: so far, so good Chapter 2!! Example from ye olde booke: using System; //CS(3,10) error CS1001: Identifier Expected //CS(7,10) error...

In thread222-794484, there is a discussion re stopping a program programatically. The discussion focues on having a FORM with the attendant timer. This seems to be "OK" for apps which always have a form with the focus. There is also a cryptic reference to "WaitTable". I have briefly searched...

I have generated a number of queries to transform some data (tables) in one database into similar tables in another database. All of the queries are generated as sql strings in a module. Most of them work just fine. Two of them do not. They do not generate any errors. When I output the SQL...

I have a number of routines using 'fso'. MS Scripting Run Time Library is in references, yet I get an error (suddenly today) saying the reference isn't registered. Aany help / advice appreciated. Only going a lot nuts!!! MichaelRed

How do i start (the question). I have attempted ever so many approaches and encountered ever so many objections (e.g. Errors). Perhaps the best help would be a pointer to the kinds of things which belong in the varions terms. the immediate issue seems to be ye olde: [Microsoft][ODBC Driver...

SELECT YrMnth, S_PWE As PWE, S_PW As PW, S_PDW As PDW, S_FE As FE, S_TPF As TPF, S_Fab As Fab, S_FI As FI, S_PM As PM, S_Svc As Svc,S_ProSvc As SubC FROM tblLaborPriceAsgnByJobProduct Where (((JobID) = "ROTHM01")) ORDER BY YrMnth; SELECT YrMnth, SaleSum As Sales, PriceSum As Asgn_Price...

Any one notice that "Conditional Formatting" is not included in the Toold -> Documentator -> Reports - > * (or your favorite trouble spot ??????? Most vexing when searching for the source of a problem. The specifics appear when attempting to OPEN the report, and what appears to be a parameter...

Probably unimportant. MS has slightly shaded the truth re temporary (un named querydef objects. The Docs saay these are not saved. Not True. They are saved until the next compact / repair operation. Perhaps in the grand scheme this (the saving) is necessary. To see this, create an unnamed...