Application access object .docmd

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
travisc
Posts: 2
Joined: Fri Nov 29, 2019 8:41 pm

Application access object .docmd

Post by travisc » Mon Feb 03, 2020 10:22 pm

Product, powershell studio 2020 64 bit:
Operating system:
64 bit OS windows 10

I’m working on a script that uses the object access.application

When using the project it does not show any of the suggested commands under the .docmd.

$access= new-object -com access.application

$access.docmd.(nothing is suggested in studio, but in ISE it gives you a list.

Also when a error happens it gives the same error every time, ISE gives you a lot more details on errors. Like query isn’t in right format and so on.

I can attached screen shots if needed, but didn’t know if this was a known thing, I have a setting wrong, or something else.

User avatar
mxtrinidad
Site Admin
Posts: 380
Joined: Sun Mar 03, 2013 12:42 pm

Re: Application access object .docmd

Post by mxtrinidad » Tue Feb 04, 2020 6:39 am

Please can you provide a screenshot of the error, and it would help to have the version of Access you are currently working.

User avatar
Alexander Riedel
Posts: 7214
Joined: Tue May 29, 2007 4:43 pm

Re: Application access object .docmd

Post by Alexander Riedel » Tue Feb 04, 2020 7:11 am

Please also include if this is a 64 bit or a 32 Bit version of Access.
Alexander Riedel
SAPIEN Technologies, Inc.

travisc
Posts: 2
Joined: Fri Nov 29, 2019 8:41 pm

Re: Application access object .docmd

Post by travisc » Fri Feb 07, 2020 7:39 pm

Sorry of the long wait.

Access is 2016, 32bit. Whole company uses the 32bit version.

When running in the debug it says error "ERROR: You entered an expression that has an invalid reference to the property FileSearch. This is the same error i get for all errors when running the .docmd commands.