Programmatically move a control on a view (1 Viewer)
- Thread starter ZacWolf
- Start date
That fairly easy to do in VBA but I don't see any way of doing it in a macro. I suggest learning VBA. This video series would give you a good start.
- Local time
- Yesterday, 16:25
- Joined
- Aug 30, 2003
- Messages
- 36,124
I'd agree, but won't help in this situation; no VBA in web apps.
I think SetProperty exposes those properties, but no idea if it works in a web app.
Sorry I didn't notice this was in the Web Access forum. Also apparently I'm wrong. You can manipulate these properties via SetProperty. In the attached database there is a form with two simple examples. One button modifies the Height and Width property of a rectangle and the other modifies the Left property. Note that the values in the macro are in twips.
Yeah, I think that's the issue, as I can find no such properties exposed via the web based macro system.
SetPropery in webapp macros expose only the following in the attached screen grab.
Attachments
-
Capture.PNG
- Local time
- Yesterday, 16:25
- Joined
- Aug 30, 2003
- Messages
- 36,124
I think there are security and performance trade-offs to make apps work in a web-based environment. Maybe that kind of dynamic movement of the controls can't be done in a browser? Who knows, I'm only speculating. I was paying more attention when they first came out, as I was excited to try them. Didn't need them enough to fight through the learning curve. I know those trade-offs are why VBA can't be used.
This web page seems to imply that they can but I'm pretty sure that the macro code needs to be translated into something that would run in a browser like Java or Javascript at some point. My guess is that Microsoft just doesn't want to spend the bucks to implement it.
- Local time
- Yesterday, 16:25
- Joined
- Aug 30, 2003
- Messages
- 36,124
If memory serves, macros are converted to Javascript to run in a browser. I know the Access development team is constrained in what they can work on, so maybe they haven't been able to devote resources to this particular need. They have to balance the demands of management, customers via UserVoice and such, and MVP's whispering in their ears.
Well I spent six hours going down a rabbit hole to figure out a work around. I thought maybe I could use their "web box" display item to load some Javascript to manipulate the page, but that lead to issues with crossdomain blocks, so in trying to figure out how to host an html file on the Sharepoint server, even after created a new content-type that should identify an .html file as text/html, instead it keeps sending as binary so that instead of viewing it triggers a download.
Via a "real" SharePoint server it would be possible to set both "true" mime-types, or set the "BrowserFileHandling" property to passive; but after loading up all the necessary PowerShell addons to connect to a web based SharePoint server, they've even made this property "read only" for the 365 version of SharePoint.
Via a "real" SharePoint server it would be possible to set both "true" mime-types, or set the "BrowserFileHandling" property to passive; but after loading up all the necessary PowerShell addons to connect to a web based SharePoint server, they've even made this property "read only" for the 365 version of SharePoint.
