Can somebody help me debug a problem?

[mctaguma]

--------------------------------------------------------------------------------

Hi guys,

I have a database made with Access, have uploaded here: http://www.scoutingtimaru.org.nz/dbtest/Training.mdb (8.9MB)

When I create a new user, the programs creates two blank users.

Can anybody help debug the problem, would very appreciate help.

When you open the file and it asks for password, just click ok.

Click the record button, click the blue add record button and create a user and give them a section, then close.

Next time you go back into records, and view the drop down name list, you will find blank records.

Many thanks in advance for anybody that can help.

Regards

Matthew

 

[RuralGuy]

Hi Matthew,
I have a couple of suggestions to start. I don't believe your code will compile. Start there and Dim *all* of your variables before you use them. When you post your db, do a Compact and Repair first and then Zip up what is left to save some download time. Go ahead and make the corrections and post your db again as you did before and we'll look at it and make some suggestions.

 

[mctaguma]

Hi Matthew,
I have a couple of suggestions to start. I don't believe your code will compile. Start there and Dim *all* of your variables before you use them. When you post your db, do a Compact and Repair first and then Zip up what is left to save some download time. Go ahead and make the corrections and post your db again as you did before and we'll look at it and make some suggestions.

Thanks Ruralguy,

will do. and post again when done,

Matt

 

[mctaguma]

Hi Matthew,
I have a couple of suggestions to start. I don't believe your code will compile. Start there and Dim *all* of your variables before you use them. When you post your db, do a Compact and Repair first and then Zip up what is left to save some download time. Go ahead and make the corrections and post your db again as you did before and we'll look at it and make some suggestions.

RuralGuy

Have followed your instructions, the zipped database file is available here:

http://www.scoutingtimaru.org.nz/dbtest/Access 2000 Training.zip

Thanks for any help you can give.

Matt

 

[RuralGuy]

I'll take a look at it but I'm still getting "variable not defined" errors with acXP. Are you sure your code compiles?