Microsoft Access geeks right, im doin a database for my exam. this has to have an automatic counter on, so when someone opens up the database it adds 1 onto the counter. i havent a clue how to do it, iv tried doin stuff but it aint workin anyone help please
yeah but is some macro not created? i done what u sed it just splits up the form, but least its getting somewhere, it must be on the right lines
This shudn't be hard to do, easiest way would be to have a table with the counter as the field. If you still need it this should work (well, it does in Access XP): 1) Create a new table called counter 2) Add a field to the table called counterfield 3) Create a new macro in the database 4) Set the action to be RunSQL from the drop down 5) Set the SQL Statement in to be "UPDATE counter SET counterfield = counterfield + 1" 6) Save the macro with the name autoexec Now, whenever anyone loads the database that macro will automatically run and increment the counter.
