Search results

Not exactly VBA but maybe a solution The easiest way to do this is to insert a bit of SQL code into your VBA sub as follows: Private Sub Command1_Click() DoCmd.RunSQL "ALTER TABLE YourTable ADD ColName Varchar(30) Comment:Your index needs a name DoCmd.RunSQL "CREATE UNIQUE INDEX Name ON...

I am trying to create and edit a new record in an existing table,(Transactions). It has 3 records in. When the code below runs, it creates the new record, (Record 4), but updates Record 3 - NOT the new one. The field I want to update is called 'Balence'. Any help apopreciated. I have run this...