1-Open an Access database.
2-Select the New from File/Menu Bar.
3-Select Project(Existing Data).
Then enter the requested informations. (Server IP, User, Password...etc.) When you connect the database, you will see the tables of the SQL database in your Project.
You can't use .ADP without...
I found the answer in the same day! I'm giving the answer of my question below.
The wrong line is:
me.form.mysubform.recordsource = sourcesql
The correct one:
me.mysubform.form.recordsource = sourcesql
:) Now I can sort my data.
My problem is about a form that's using a datasheet subform. I create an SQL with the fields on the main form then I try to set the Recordsource of the datasheet. But the result is negative. (I can set the recodsource of the continuous subform with the same method.)
Do you know a way to set the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.