Hello,
I have a problem in creating a form for databases. Every time I record a macro to save the data I've inputted in the form I have created into the database all the macro does is save the worksheet. It doesn't ask me if I want to update the current record, or create a new record, and looking at the database file confirms the fact that nothing has been written to the database. However, when I click on the save icon or file menu/save, it does ask me for those options.
I record the macro by clicking on file menu/save (whereupon it *does* ask me if I want to create a new record, but that doesn't reflect that in practice.) and then saving the macro.
Any advice will be appreciated. I am using Excel 2000.
I have a problem in creating a form for databases. Every time I record a macro to save the data I've inputted in the form I have created into the database all the macro does is save the worksheet. It doesn't ask me if I want to update the current record, or create a new record, and looking at the database file confirms the fact that nothing has been written to the database. However, when I click on the save icon or file menu/save, it does ask me for those options.
I record the macro by clicking on file menu/save (whereupon it *does* ask me if I want to create a new record, but that doesn't reflect that in practice.) and then saving the macro.
Any advice will be appreciated. I am using Excel 2000.