FORM Fields Programming

[accessprogram]

Can you post the db?

Can you come to teamview presentation plz. I tried to upload the db but its too big in size to get uploaded.

[pbaldy]

Sorry, I don't do that type of thing except for clients. If you compact and zip, it will usually be small enough. If not, you can import the relevant objects (the two forms and the tables) into a new db which should be small enough.

[accessprogram]

Sorry, I don't do that type of thing except for clients. If you compact and zip, it will usually be small enough. If not, you can import the relevant objects (the two forms and the tables) into a new db which should be small enough.

Hello PBaldy,

I have uploaded the DB in which there are tables and 2 forms. Please check and help. Thanks


Karan

[accessprogram]

Hello PBaldy,

I have uploaded the DB in which there are tables and 2 forms. Please check and help. Thanks


Karan

Please find the attachment named as Database14

[pbaldy]

For starters, the code won't compile. You need to add the MS ActiveX Data Objects library in Tools/References. Then the recordset will open correctly. Because you have your code in a module, you have to have the full form reference instead of "Text0".

That said, I don't know what you expect that code to accomplish. It would keep overwriting the two form controls with each record until you're left with the last record's values.

[accessprogram]

For starters, the code won't compile. You need to add the MS ActiveX Data Objects library in Tools/References. Then the recordset will open correctly. Because you have your code in a module, you have to have the full form reference instead of "Text0".

That said, I don't know what you expect that code to accomplish. It would keep overwriting the two form controls with each record until you're left with the last record's values.

Hello PBaldy,

Finally the code is running after I placed syntax of form given by you. Thanks a lot for helping me. I appreciate your kind gesture and helping attitude. Thanks a lot.

Regards,

Karan

[pbaldy]

You are welcome, and good luck with the rest of the project.

[accessprogram]

You are welcome, and good luck with the rest of the project.

I hope I have a good friend in the name of PBaldy who will guide me and help me in the future for any other difficulty.

[pbaldy]

There are many people here as knowledgeable as I am (or more knowledgeable) that are ready and willing to help. One or more of us is usually around to answer questions. One advantage to a site like this is that you aren't limited to one person, but of course I'll help when I can.