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 SkipVought 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: *

  1. kszacki

    PASTE few cells (at once) into table (datasheet view)

    :~/ I feel stupid I wrote my post, just after my ... hmm how is it in english... injection that makes You flu resistant :-) and I was little X-) sorry thx for not laughing at me ... Charles
  2. kszacki

    PASTE few cells (at once) into table (datasheet view)

    Hi After few months, again... I need YOUR help. While in a table (datasheet view), I want to paste for ex. 4 cells, at once, (in one row of course) copied from Excel. Most common question -> HOW CAN I DO THAT? Charles
  3. kszacki

    SUPERLONG queries

    Thank YOU all :-) Charles
  4. kszacki

    SUPERLONG queries

    Yes please... examples would be very helpful. Charles
  5. kszacki

    SUPERLONG queries

    Hi I have 2 questions. 1) How can I set (using VB code) which query columns are visible in the query result? Like using "SHOW" switch in the queries design view. 2) Is it possible to make "superlong" query? It means... for ex., I have database containing products and...
  6. kszacki

    VB setting, which query columns are visible ?

    ooops... I quess I chose wrong forum... I'm sorry Anyway... can somebody help? Charles
  7. kszacki

    VB setting, which query columns are visible ?

    How can I set (using VB code) which query columns are visible in the query result? Like using "SHOW" switch in the queries design view. Charles
  8. kszacki

    let user generate a report (or generate Excel export)

    Hi I have to let database users generate (choose which columns from the table they want) a report. It can be also direct Excel export. But, I quess, if I have the report I can export it easily. :-) please help Charles
  9. kszacki

    Query -> Excel export

    I just need to let user choose which query columns are to be exported. yeahhh... just let :-) the most common question... how can I do it??? Charles
  10. kszacki

    Undefined function 'Right' in expression.

    Thanks Thanks Thanks :-) I was waiting 15 minutes for reply !!! And now all works just fine... ... so I can start (tomorrow) my 11 day holiday (canoe trip) :-) thank YOU ALL good people Charles (POLAND)
  11. kszacki

    Undefined function 'Right' in expression.

    Sorry... I forgot to tell... I am using Access 2000.
  12. kszacki

    Undefined function 'Right' in expression.

    I get this kind of message while opening (for ex. design view) query which uses 'Right' function. It the same with all 'string' functions. I remember I had this problem with Access97. But I forgot what should I do. please help Charles
  13. kszacki

    no read permission to MSysModules2

    I put all modules code... to the form related code. And now it is OK. :-) thanks !!! PS Does it really matter if code is in the module... or simply included in the form code? Just want to know what is the difference. Of course I know that now I cannot use it (code) to other forms.
  14. kszacki

    no read permission to MSysModules2

    When I set private accounts on my Access97 database... I get this kind of message. But only when I want to log on as non-Admin user. No matter if non_Admin user has all possible rights to the database. If I log as Admin group member... all wors fine. What is the problem...??? please help...

Part and Inventory Search

Back
Top