Search results

  1. jimbrooking

    Add column/field to linked database?

    I have what I thought would be a pretty simple problem: add a new field to a linked table. The application is a large for-sale database installed at a number of client sites. I was intending to sneak into an update code to check if the field was in the table already using something like...
  2. jimbrooking

    Configuration Management & Control Tools?

    Can anyone recommend a tool or technique for automatically maintaining a list of MS Access (2000) objects changed since a given (baseline) date and time? I'd like to be able to export a list of changed objects to another database to create update files for a production front end to a database...
  3. jimbrooking

    Access 2000/2002/2003 Interchange Problems?

    I have been doing some consulting for a NJ (USA) firm on a fairly complex database that was originally developed by the firm in Access 2003. They outsourced a carefully spec'd upgrade to an off-shore developer, and about a month ago I got to start picking up the pieces from that debacle. Our...
  4. jimbrooking

    Open file:// URL?

    I have an Access app that is distributed with an HTML file. The HTML file contains references to US gov't regulations for the privacy and security of medical records (HIPAA), including definitions of terms. The Access app contains a number of command buttons for the purpose of looking up the...
  5. jimbrooking

    Delink Backend for Copy?

    I have a split database. The path to the back end database is saved in a table. I want to let the user change the location of the back end so it can be moved, e.g., from its install directory to a LAN directory. The back end tables are linked when the DB is opened and unlinked when it's closed...
  6. jimbrooking

    Hypertext Text Box?

    Is anyone aware of he existence of a text box control that displays HTML-formatted text in forms and reports? I know of 3rd party RTF text box controls but haven't seen (and maybe could use) an HTML text box. Thanks, Jim
  7. jimbrooking

    CDO for Win 2000

    Has anyone found success and happiness in using CDO for Win 2000 to send email? Apparently this is MS's new! improved! way to fire off email from your apps. I copied some code off the MS site at...
  8. jimbrooking

    Download File?

    Does anyone have a code snippet or a reference I could peruse to learn how to automatically download a file from a web site? We'd like to provide a list of documents (MS Word) on our web site for people to download if they need a sample form, document or whatever. We don't want to package these...
  9. jimbrooking

    Test for long memo field in text box?

    I have a form with a text box whose recordsource is a memo-type field. I have a buch of stuff on the form that precludes a significant part of the form being "taken over" by this field. I have sized the field to accommodate probably 90% of the records, but a few of them overflow the field. A...
  10. jimbrooking

    Missing/Inconsistent References

    I'm hoping someone can point me to a solution to the maddening problem of "fluid" References. I have developed a database my Non-Profit organization intends to market. I have developed it in the Access 2000 component of Office 2000 Developer's Edition. I installed Office 2K "custom", adding...
Top Bottom