Please help with working code. Access 2002 ADO

[hooks]

Please help with working code. Access 2002 + 2000 ADO

Hey all. I have a sample database that is ADO unbound and unlinked. Could some of you experts please look at the code and let me know how to make it better and faster. The code does work but I know very little about programming and Im sure there are easier ways of doing things.

Im not worried about the buttons. I'm more worried about the recordsets.

I have the form locked until the edit button is pushed.

I have a combo that you can add to the underlying table.

Please give me some suggestions

Thanks Hooks


Extract to C:/ so that the connection will work properly.

 

[hooks]

Bump......

 

[WayneRyan]

Hi Hooks,

Access 2000 can't open your 2K sample.

Wayne

 

[hooks]

If I post all of the code will you look at it. There is a lot of code though.

Thanks

 

[hooks]

I don't have any problems with this database other than I want to learn to do things correctly.

My original goal for this test project was to get it working. Now that it works I want to make it correct if not perfect which I am nowhere near at the moment. I know there are a lot of good programmers on this site and would like to learn from them. Please help me learn to code the correct way.

Thanks again to all that have helped me.