Search results

Try This it worked for me. It added a row with the numbers i wanted. You must compact database each time you do it. add a button on a form and enter this in the on click. You can use it to rest the Auto Number eg to 999 Dim db As DAO.Database Dim rst As DAO.Recordset Dim i, x As Variant Set db...

Great Answer

I have written a database for bird shows. I need to see what data is changed in a table. in a query from a different database. I have this SQL SELECT Exhibitors.* FROM Exhibitors IN 'M:\InFlight\Data\BirdShowData.accdb'; When i view it in design view it asks for the password which i enter then...

:D Thanks. Thats what i needed

Hi all What is the order of sequence when moving from one record to the next in a form? Is the On Current triggered first?

Even if i can lock the table

Hi I have a table that i need to lock the default value from being changed in table edit view

We live in Masterton which is just North of Wellington.

Hope she enjoyed the visit. Would have got the good weather in March.

Hi to you all from New Zealand