Search results

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...

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...

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...

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...