Recent content by vabki

  1. V

    Query resumes running

    I'm not sure if this question belongs here or in reports... I'm running Acc 2003. I've built a query which uses a function to translate/populate a field within the results. I then built a report based on the query. The function is not used anywhere else in the application. When I run the...
  2. V

    SQL error on 1st execution of new application

    I might have found the source of the problem 1. I googled for the error # with the minus sign attached, which fails. 2. If the machine on which the application is installed does not have folders (directories) and paths equivalent to those already present in the application then the...
  3. V

    SQL error on 1st execution of new application

    I recently completed an Access project in which the object (.mdb of queries, forms, reports, modules) is expected to run locally with the data (.mdb of tables) running on a network server. I sent the “setup” to our lab, where they built a machine with an “image” of the destination machine...
  4. V

    Has anyone seen this bug, if that's what it is?

    Resolved (Autocorrect) Has anyone seen this bug... I've been working with MS Access for many years now, and recently migrated to 2002 Developer's edition on a Win2k workstation. I habitually use the wizard to develop a basic form (or report), and then tweak the result until I'm happy. The...
  5. V

    What (software) am I missing?

    Thanks. I found the XP Developer cd, which also required the Windows Component Update 1.0 cd. I suppose your last item is intuitive, with MS' new approach to licensing everything. I've talked to my lab people, and we'll be experimenting once I have a 2002 deployment package available (so the...
  6. V

    What (software) am I missing?

    I've built several Access applications in the past using 97 and then 2000. In those instances, the software was loaded on my machine by me with complete access to all the components. I learned that one could build a complete deployment package one time, and then "clone" the shortcuts...
  7. V

    Module/VBA Question

    Hello, You'll need more than a single form to solve your problem. While your form, query and the underlying table are a good place to start, there are a few missing steps. Also, my users seem to prefer forms to switchboard entries, so I'll respond in that fashion. 1. I assume you've...
  8. V

    Search a folder?

    clarify, please did you want to do a windows search or a search from within an access application?
  9. V

    packaging wizard missing

    I was careful when installing Off 2002 prof to select all wizards and add-ins, but apparently none were installed anyway, because I'm trying to package my application and there is no packaging wizard. I got the add-in manager to where it will prompt me for a location, but I don't know what to...
  10. V

    recordset.seek with compound field lookup issue

    found it for those of you who are still thinking about this, the answer is that the key fields should not be concatenated but separated by commas... thanks anyway!
  11. V

    recordset.seek with compound field lookup issue

    My base table has an index based upon 2 fields, the first of which is a string type and the second a date type. Even though the basis for the record's fields and the seek arguments uses the same code construct, the seek fails. Is there some special connotation that I need to use to format the...
Top Bottom