• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Userform Data to store in access ... new database connection error

    Hello Sir I have thanked each one of you in this forum especially for u as well, if you will see my previous all comments, i have acknowledged for the same. However i am new and i thought this forum will help me at an certain stages. I am not asking for each and every project help, however...
  2. S

    on double click listbox data on excel userform return the records of access db

    Hello All I have code which retrieves data from the access db to excel listbox, however now i m stuck at the edit part, i want when a user click any data in the listbox then it must retrieve the row data automatically to the userform controls, It would be really great if any one help me on...
  3. S

    Userform Data to store in access ... new database connection error

    Sir Thank you very much again ... now its working fine.... however i m not getting the code for all the data of the same table to view in the list box of the userform and sorted descending order by date in excel ... and based upon 2 option buttons it should work... where if a user clicks on...
  4. S

    Userform Data to store in access ... new database connection error

    Hello Sir, Tried the statements given by you. still could not open the file. Can you let me any other option. or else which references are to be checked. Many thanks.
  5. S

    Userform Data to store in access ... new database connection error

    Hellooo Sir Thank you for the update, I have tried the things which u have said, but its not working, i m really shocked. And i am attaching my 2 files. access and excel file to show you the exact problem http://www.2shared.com/file/zD6OFvAx/SAMI_Tracker-Programme.html...
  6. S

    Userform Data to store in access ... new database connection error

    Hello Sir, Again i m getting the erro at .open and msg coud not find the file However as instructed by you, i have changed to .mdb and checked the address of the data source and its correct.... It would be really great if you help on the same. Many thanks
  7. S

    Congratulations SirJB7 4,000 Posts

    Congrats Sir on your 4000 Posts ... Really your speedy reply helped us very much to learn new things always
  8. S

    Userform Data to store in access ... new database connection error

    Thank you so much sir ... for helping ...
  9. S

    Userform Data to store in access ... new database connection error

    Thank you sir for your kind help...... It seems to be working now, However i have many fields and many textbox and date_picker which i want to add in this coding ... Can you help me with any of such examples or website which i can refer ... This code is to add new data to the database...
  10. S

    Userform Data to store in access ... new database connection error

    Hi Sir, Thank you so much sir, However i am getting an error at .open Statment, Errr:-could not found the file, also the file path is correct as i have checked 3times Can u also please help me on the same. MANY THANKS IN ADVANCE.
  11. S

    Userform Data to store in access ... new database connection error

    Hi Sir, Links revised : http://www.2shared.com/document/asUBljxs/Test_DB.html http://www.2shared.com/document/-lPN5l69/Testaccdb.html Hope so now it will work ... Thanks,
  12. S

    Userform Data to store in access ... new database connection error

    Hi, Thank you for the help, http://rapidshare.com/files/2733157737/Test%20DB.xls http://rapidshare.com/files/3986390986/Test.accdb.mdb These 2 are excel and Access database, where i want the userform textbox data to store directly in access.... I hope u came to know now what is my...
  13. S

    Userform Data to store in access ... new database connection error

    Hi, Thank you very much for the update, However, i am happy atleast we can do the 1 or 2nd option shared by you. Let me explain, what i m doing & expecting: I have created a userform named: PODetails, and 2 Text boxes named,1:No_Lines_Processed,2:total_PR Now i have created a database...
  14. S

    Userform Data to store in access ... new database connection error

    Hi, Thank you very much for your update, However I need to check the syntax error. Meanwhile, Just an help needed... I have created a data entry user form in Excel as a front end, and I want the userform data to be stored in the Microsoft access database. is it possible that the...
  15. S

    Userform Data to store in access ... new database connection error

    Hi Everyone, I have created a userform where i want the data to be stored in access automatically, However i have written some code, where in start only i m getting error at the Dim con as new adodb connection Can some please tell me why is this error occurring, or how to come overview...
  16. S

    Multiple coloumns with data filter to be viewed in Listbox

    Anybody can please help
  17. S

    Multiple coloumns with data filter to be viewed in Listbox

    Hello Guys!!! Hope you all are doing well. I think you guys can help me in resolving my issues, i have prepared a user form which has an data entry firm.... how ever i have a multipage view in that it has a section which i put the 3 option buttons where (1:In Process, 2:Completed,3:rejected)...
  18. S

    I want to link the data of combox to the check box also ...

    Hi Ashok, Thanks you very much , Really it has helped me a lot ..... All the best......
  19. S

    I want to link the data of combox to the check box also ...

    Hi, My self is an Intermediary in Excel, and Keen in learning excel formula's My Sincere apologies for not uploading the file .Link:-(http://speedy.sh/8KQD2/Combo-Check-box-together.xls) I want to make a graph in such a way that when the combobox is selected similarly i can click the...
  20. S

    I want to link the data of combox to the check box also ...

    i have created a combobox and check box ... now i wanted the Y axis data to b viewed 1 by 1 in check box of the data we select from the combo box .... please help i m very much confused .... i know its possible ... but i dont know the trick ....
Back
Top