Search results

Sorry Frinds Only Selected List box Item

We can use function in query But the code for steps

Hello first how can I put list box column to array? second How can I use this array in query for example in cretieria (in (Array)) Thank you so much

thanks, friends if find the solution with qoutation ------------- SELECT T.ColumnA, GetList("Select ColumnB From Table1 As T1 Where T1.ColumnA = '" & [T].[ColumnA] & "'","",", ") AS ColumnBItems FROM Table1 AS T GROUP BY T.ColumnA; -----------

Please check this DB Sample with the function the function is great for stack over flow but the query give me an empty row Can you pls fix the error

friends as attached image if the client duplicated can I merge the fields value with "," for each field in one row as the sample attached

Thank you so much for your great help I'm testing and try to learn

I want to convert all query rows to excel like the report in image 2 The report not converted correctly to excel and transpose in excel need a lot of manual work

Thank you so much (y) (y) (y) (y) (y) (y)

Thank you

Hello where does the owner come to form did not allow me to add a new members

friends; Should the owner of the SharePoint Site add me? Or I can Sign in with any email from access for first-time access to SharePoint when I work on my computer not ask for credential but when moving it to the client's computer ask for sign in Why Should I add his email to...

this message appears when reconnecting in office 2016 the application runs very good with office 2019

Thank you How can I delete the old SharePoint link?

when I press refresh on the list or linked table this box appear

I connect Access to the SharePoint list the first time connected and work after that takes a long time to connect and access stop work and hang What should I do to connect to SharePoint How could I open the email login screen log in to the user when the application starts or after the...

why does this error appear when navigating between records after exporting/importing the list from SharePoint to access Operation is not supported for this type of object. (Error 3251)

Hello Friends I have a lot of questions related to the SharePoint link How can I clear this site? when adding a new site (this is my site, I want to add a client Site.) How can I keep both? Why asking me to sign in when changing the computer?

Hello how can I Export the Access Report with the format to word Example Line between Cells Shades I can export but I can't keep the format is there any VBA or any other method that can export with the format Thank you so much

Is there a limit for users? How many access front ends can access the list?