Results 1 to 14 of 14
  1. #1
    Join Date
    May 2008
    Posts
    9

    Unanswered: Record control in datasheet

    I need to be able to control the format of records in a datasheet form. The problem is, apparently there is no way to get to the properties of an individual record or cell when a subform is in a datasheet view.

    I tried using the DataGrid component but it always gives me a databased is locked error.

    So. I need some ideas of either how to make the DataGrid work, or how to get at the properties of the cells in datasheet view.

    I don't understand why Access does not have a native Datagrid component.

    Seem a basic need of forms.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try the datasheet view if you must have that stylistic
    Access is a RAD tool, it isnt' perfect, it isn't like a lnaguage like VB, C# or C/C++

    if you need that sort of capability then you need to either use one of those languages or roll your own control (not for the faint hearted)
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2008
    Posts
    9
    As I mentioned in the OP I did try that. However, there is no way to conditionally format cells or rows.

    Again, what do I need to do for the DataGrid to work in Access.

  4. #4
    Join Date
    May 2008
    Posts
    9
    Hello, anyone...Bueler....

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Access <> Excel.

    The data grid works fine, you just want conditional formatting because you are accustomed to it from Excel.

    You can upgrade to Access 2007 which has conditional formatting for forms (I think it only applies to controls though) or you can go back to Excel and use Conditional Formatting there.

    I've been developing applications in Access for years and never found the need to do conditional formatting... it just seems too dinky to me to bother with.

    Why do you think you need to conditionally format "cells"? Maybe there is an alternative?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    May 2008
    Posts
    9
    First, Excel is not a database and I don't care for it.

    Second I am accustomed to real RAD tools like Delphi and Paradox that are so incredibly more flexible.

    Third, I need to manipulate the way the cells look because that is what my boss wants in this application.

    So, once again. Is there or is there not a way to manipulate the cells or rows or columns in a datasheet view.

    I can't for the life of me understand why there is no native datagrid component in MSAcess. VB has it so why not Access

    If you have a real suggestion I would like to hear it.

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    ...and Access <> VB!

    Access uses VBA, which is a cut down version of it's bigger brother.

    Have you considered using the MS Office Excel object; and before you tell me it's not the answer you were looking for, have a think about what you really want from the control
    George
    Home | Blog

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Oh well, so sorry that I tried to help
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    May 2008
    Posts
    9
    OMG..why is this so dificult. I just want to have a do loop course through all the records in a datasheetview and change the backcolor of the row based on code.

    This is not a simple conditional format. Which, BTW, does not work on datasheet views.

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    OMG..why is this so dificult.
    Personally I think it's your choice of words, your failure to listen and your failure to appreciate the advice already given to you.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  11. #11
    Join Date
    May 2008
    Posts
    9
    Typical Microsoft BS since VB or VBA is not a real language.

  12. #12
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Wow, just wow.

    Your unwillingness to appreciate the fact that there is more than one solution to your problem, your arrogance in approach and general ignorance is not going to make contributers here want to help you.

    So just pick up the toys you've thrown out of your pram and come back with a better, more open-minded attitude if you want help again.
    George
    Home | Blog

  13. #13
    Join Date
    May 2008
    Posts
    9
    oh cry me a river......

  14. #14
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you want to do something that isn't supported by plain vanilla Access then usually there are ways of doing it.. but that involved you writing code, and in this case faking a datasheet...

    if its not up to your current skill set then fine, either develop your skill set to handle it or move on elsewhere

    if its because VB & VBA are to beneath your lofty self worth then fine.. but then wtf are you doing using Access in the first place. there are other tools out there which will do what you want.. but you will still have to do a lot of work. Even the open source db in openoffice uses a flavour of VB

    Incidentally I suspect that most of the respondents here don't use datasheets in their applications, precisely because of the sort of problems you are finding with them.

    I'd be intrigues to know what you regard as a 'real' language. For the work I do I don't care what language the customer or employer wants, I've no shame if someone is picking up the tab. You are playing to the pipers tune. if they want VB I'll do VB. With the development of .NET the practical differences between the .NET languages is narrowing.. so you can use c#,vb or vc.. it doesn't matter. ultimately its totally irrelevant as the customer (or user) doesn't care all they want or need is something that works.

    of course you could develop stuff in what ever the university academics deign as a real language (I remember being taught ALGOL, Pascal & Simula plus a bit of Fortran and Forth thrown in for good measure). I haven't touched any of 'em since leaving uni and the proponents of Forth & Simula separately claimed their language was THE one true language, the guy who pushed Pascal was involved in the team who developed Pascal on the uni mainframe (and it turned out was getting a percentage of sales on the various Pascal compilers / interpreters being sold.

    in reality it doesn't matter what academics say if there theories cannot be used in the real world. however youc an learn form them, you can use that knowledge in the current language. Personally I don't have much truck with the 'Access doesn't do this' approach... when usually (just like the open source world) you can get round Acces's limitations by extedning the functionality with your own code.. but you need to be prepared to duve in and develop a fix for your current problem. Its like seeign a child on the edge of the sea whining its to cold..... yes it it if if go up to your knees, then come out, the wind chill is not nice.. but dive in, get active it soons becomes less hostile.

    If you are a dab hand at OO design then use those skills and develop OO VB/VBA code.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •