SirJB7
Excel Rōnin
Hi, sagarrajula!
As far as I could see you've been experiencing problems for developing an Excel workbook with user forms in the front-end against an Access database table in the back-end. You've asked here, there, and everywhere. Cross posting and not even writing a line about the fact.
You were kindly guided thru the logical paths that you should follow (e.g., read articles, download samples, investigate thru the internet) to solve your main issue, which is trying to develop a solution far beyond from your nowadays skills, both in Excel or in Access.
After several weeks of questions posted, answers with advices given and neither effective actions taken by yourself nor even thanked or answered to the suggestions received, you still keep on asking how to do things that may be you'd be able to do, after an initial period of time studying -but not now-. In plain text, you can't do today what you want to do because you haven't gone thru the learning process. And this is not any shame at all, everybody of us ignore a lot of things.
If I were you I'd follow these steps:
a) Accept and take all the indications given, even they don't and won't provide an immediate solution.
b) Take any of the courses given by Chandoo at this website, they'll make you walk faster thru the basics needed for developing your project.
c) If times hurried up you or didn't succeed at previous steps, consider hiring a consultant -local or worldwide- to either develop the solution or guide yourself.
d) Give a look at this file:
https://dl.dropboxusercontent.com/u/60558749/Excel%20userform%20on%20Access%20table.rar
It's a sample workbook with two userforms performing additions, updates and deletions on an Access database table. There you'll find all the features that you should implement in your project, but keep in mind that I think that you're not yet prepared to adapt it and convert it into a fully working solution.
I'm afraid that this will be my last contribution to this topic or any equivalent one, at least while the actual status quo remains in similar conditions. Hope you understand.
Regards!
As far as I could see you've been experiencing problems for developing an Excel workbook with user forms in the front-end against an Access database table in the back-end. You've asked here, there, and everywhere. Cross posting and not even writing a line about the fact.
You were kindly guided thru the logical paths that you should follow (e.g., read articles, download samples, investigate thru the internet) to solve your main issue, which is trying to develop a solution far beyond from your nowadays skills, both in Excel or in Access.
After several weeks of questions posted, answers with advices given and neither effective actions taken by yourself nor even thanked or answered to the suggestions received, you still keep on asking how to do things that may be you'd be able to do, after an initial period of time studying -but not now-. In plain text, you can't do today what you want to do because you haven't gone thru the learning process. And this is not any shame at all, everybody of us ignore a lot of things.
If I were you I'd follow these steps:
a) Accept and take all the indications given, even they don't and won't provide an immediate solution.
b) Take any of the courses given by Chandoo at this website, they'll make you walk faster thru the basics needed for developing your project.
c) If times hurried up you or didn't succeed at previous steps, consider hiring a consultant -local or worldwide- to either develop the solution or guide yourself.
d) Give a look at this file:
https://dl.dropboxusercontent.com/u/60558749/Excel%20userform%20on%20Access%20table.rar
It's a sample workbook with two userforms performing additions, updates and deletions on an Access database table. There you'll find all the features that you should implement in your project, but keep in mind that I think that you're not yet prepared to adapt it and convert it into a fully working solution.
I'm afraid that this will be my last contribution to this topic or any equivalent one, at least while the actual status quo remains in similar conditions. Hope you understand.
Regards!