Search results

  1. M

    Coping tables between two Databases

    I want to create a new Access Database and then copy whole tables with data to the new database from my current database. I need to do this through VBA, not the menu import feature. I can create a new DB with the CreateDatabase object, but I can't find an example of how to copy a table from...
  2. M

    FindNext Problem

    I have a table that contains a field called PurchaseOrderNumber. In this field the data is type String, and looks like this; NM001-018 NM001-018-001 NM001-018-002 NM001-018-003 NM001-019 NM001-019-001 etc... I need to set up a criteria string for FindNext which will match a sub-string match...
  3. M

    SubForms

    I have a standard form with a sub-form. The problem I am observing is that every time the user changes focus from main form to sub-form, or vica-versa, the form attempts to save the data to the table. I know this to be true because I have code attached to the onupdate event. What I would like...
  4. M

    Canceling an Event

    I have just started using Access 2000. I have code hung on the on-close event. In that code, at one point, I call DoCmd.CancelEvent to stop the closing of the form. This code worked just fine in Access 97 but is just being ignored in Access 2000, no errors - just ignored. i.e. the form closes...
Back
Top Bottom