Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MichaelRed
  • Content: Threads
  • Order by date
  1. MichaelRed

    Requim for the product

    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?
  2. MichaelRed

    I would like to be able to access t

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

    Create and Save Modules, Actually accompllished

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

    create Module & save 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...
  5. MichaelRed

    Public variable not keeping value - why?

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

    Field Attributes

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

    Object Browser discussion

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

    Trying to learn (2008)

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

    Adventureworks Create Table

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

    Upsizing from MS Access?

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

    upsize to SQL?

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

    /r for including a .dll?

    /// 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()...
  13. MichaelRed

    I just don't get it

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

    STOPPING app & Db on inactivity

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

    Query won't execute via 'Code', does fine when pasted into Query grid

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

    Weird. File System Object. Not Registered?

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

    Arggggggghhhhhhhhhhhh. Connection string(s)

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

    Why oh why do these produce different chart legends?

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

    Conditional Formatting not shown in Documenter

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

    Querydef documentation!!!

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

Part and Inventory Search

Back
Top