Recent content by 20dogdays

Based upon user sign on how do I make tables read only for that user? tia

I have to append a bunch of records (comma delimited file) to an existing populated table. One of the fields in the incoming file is an auto number field. Do I populate the auto number in the file or will ACCESS (2003) populate it for me. tia

Thanks for the tip, saved me a lot of grief.

There are six rows in the table ELUR1. Just after I created the recordset I inserted the MsgBox...., result was 6. rst.RecordCount was still 5.

Light dawns on Marblehead, it seems the rst.RecordCount is zero based. Now works fine. thx

I tried that and got same result, my table has six rows and rst.RecordCount gives me 5. It misses the last record in the table. Access 2000

Code/ Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("ELUR1") intNumbRows = rst.RecordCount /Code intNumbRows contains one less than the actual number of rows in the table. What am I doing wrong? tia

This is ACCESS 2000. I started all over and tried to export the same way (File->export etc). My code did not go with the form. When I View->code on the form in the new DB it gave me code for another form in the new DB. That being done I reversed my way of thinking. I am adding a form to a...

I made the form I wanted the active form then File->export and then -> to the other DB (.mdb file).

I have successfully exported a form to another DB, how do I export the associated VBA code? tia