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...
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...
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...
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.
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...
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
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...
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.
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,
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...
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...
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...
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...
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)...
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...
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 ....