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 didn't know you could do this! Thanks! Mark Jones

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 had the same problem. I'm not sure what the pure answer is but I have fixed the problem by creating a blank new 2000 database and imported the tables/queries/forms/macro/modules from the coverted DB to the new blank DB. The error seams to go away? spooky.... Mark

DoCmd.OpenQuery "query name"

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