Recent content by Shepenwepet

  1. S

    Database Performance

    DocMan, I didn't create a timer in any of my code so I don't think that's the case. I have a form designated at startup... a basic switchboard and the only code on that is wizard-created command buttons and a few subform requeries. odin1701, I tried removing the RecordSource to my forms before...
  2. S

    Database Performance

    I'd like to know whether other users have had performance problems with different versions of Access in a single environment. In my office, two users are on A2007, and the rest of us are on A2003 or earlier. After some nasty conflicts in the (un-split) database when A2007 and A2003 users were...
  3. S

    VB Code won't run after Windows Update

    llkhoutx: The first code that trips: Public Function ListFiles(strPath As String, Optional strFileSpec As String, _ Optional bIncludeSubfolders As Boolean, Optional lst As ListBox). Commenting this code out causes it to trip on the next procedure, and so on, regardless of the content...
  4. S

    VB Code won't run after Windows Update

    I have a complex database that has modules and forms in the front and links to a separate back end. People in our office run Access 2000, 2002 and 2003, all on XP. We have never had this issue before in six months of development. The front end was primarily developed in Access 2000, 2002 and...
  5. S

    Append to Foreign Key?

    Thank you, Uncle Gizmo! Worked like a dream! I'm just beginning to figure out how to use queries but I like them already. Here's the final SQL, for the record. I'm going to set up a form to select the criteria and a process that used to take ages will be instantaneous. INSERT INTO...
  6. S

    Append to Foreign Key?

    I have three tables as below, linked by a many-to-many relationship. Contact Table ContactID (PK-Autonumber) Contact details... Mailing Table MailID (PK-Autonumber) ContactID (FK) NewsletterID (FK) Details... ynMailed Newsletter Table NewsletterID Details... My Problem: I have acquired 200...
Back
Top Bottom