Search results

  1. M

    Compile Error: Invalid Qualifier

    Keep the Option Explicit but remove the error handler. Run the code. In what line the code is stopped ? What is the error message (again) ?
  2. M

    is there an autosave anywhere in access

    Me.Undo .
  3. M

    Form By Query

    Need to see your DB (2003 format)
  4. M

    What do Form level mouse events actually do?

    Too much text for me. Sorry.
  5. M

    Query - export to text file format

    First at all, Access can export in many formats and many other DBs can import directly from Access. So, if you will tell us what is this "other" database, someone can provide a better solution for you. If you will not find this better solution until tomorrow, I'll help you to create a .txt file...
  6. M

    Compile Error: Invalid Qualifier

    @Rx I'm glad because you remember a small country as Romania but, even if I don't understand (or speak) very well English, I am very sorry that what you remembers seems to not be too good. All the bests !
  7. M

    Issue running export query in vba

    We need to see your code.
  8. M

    Compile Error: Invalid Qualifier

    Just an add to what RX suggested: Replace 169 to (say) lbl169 . Use this exact syntax, with NO spaces between the word lbl and the word 169.
  9. M

    it's possible to update database application ?

    I'll try to answer to your last question (post 1): YES. For sure this is possible. How ? I don't know but, maybe, I can have some ideas. First I need to know where is the new DB ?
  10. M

    Insert binary data from other table

    Not sure, but a Make Table query should solve the problem. Of course, after you obtain the new table you should redesign your DB so... Why to not use a query NOW ? A query that collect data from both tables ?!?!
  11. M

    Thank you !

    Thank you !
    • Mihail
    • Profile post
  12. M

    Table relationships in Inventory DB with Clients

    Try to save the DB in a previous version of Access (I use 2007, but better is to save in 2003) then post it again.
  13. M

    it's possible to update database application ?

    You need to replace the old FE with a new one. So, the Windows tools (Copy - Paste) should be enough.
  14. M

    Pull from field in previous record in datasheet or continuous form subform

    Read this http://bytes.com/topic/access/insights/585228-database-normalization-table-structures
  15. M

    Writing a sub to change controls

    I think that a better way is to us the Optional Format.
  16. M

    Move after Enter on last record of continuous form

    Try the Requery command. Me.Requery or SubformName.Requery
  17. M

    Insert binary data from other table

    Don't do this. It is not necessary. Use table A where you need this information.
  18. M

    Count unic days in report

    @JHB Thank you because you still remember me. Yes, I've got a job that "eat" all my time :) . You ? How are you ?
  19. M

    Can images be saved in a table?

    I assume that "fat controller" advice you to have the images stored in a folder in your PC (or into a PC in the network). In the DB you need to store only the paths to every pic.
  20. M

    Count unic days in report

    While I steel use A2007 (and others, I am sure, A2003) it is not possible to open your DB.
Back
Top Bottom