Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Converting from Access2K to A2016- can't figure out how to get forms displayed to look like floating popup froms without changing it to a popup.

Posted on 2016-11-21
15
Medium Priority
?
74 Views
Last Modified: 2016-11-21
I'm so new to A2016 I'm struggling for what should be an simply solution.

In A2K, my application loads each forms which displays as a floating form on the page. This allows users to see what's behind the form (actually behind but around.)

In A2016, running the same code, the forms appear as full screen, left justified against that Navigation Pane.  The only way I can get the form to display as before, is to set the Popup property true, but I don't want to do this for many reasons.

Am I missing something?

Thanks.
0
Comment
Question by:pcalabria
  • 6
  • 6
  • 3
15 Comments
 
LVL 23

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 1000 total points
ID: 41895489
if you installed 2016 by clicking on a web page button, you got Click-to-run, which is a light version.  Instead, download the installation file and install normally as  this will get you the full version.

In this case, however,, perhaps all you need to do is change default view to Overlapping Windows instead of Tabbed Documents ... File, Options, Current Database --> Document Window Options

you should still get full version though
0
 

Author Comment

by:pcalabria
ID: 41895592
Thanks Crystal.  That did it!

I installed Access 2016 as part of Office 365.  

Is there still a full version I should download?

Thanks
0
 
LVL 52

Assisted Solution

by:Gustav Brock
Gustav Brock earned 1000 total points
ID: 41895660
No. It is the full version. There is no "light" Access.

Your only "issue" was flipping the radio button to Overlapping windows as version 2007+ defaults to fullscreen forms with tabs.

/gustav
1
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Closing Comment

by:pcalabria
ID: 41896300
Thanks both.
Hope a point split is okay.
0
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 41896305
You are welcome!

/gustav
0
 
LVL 23
ID: 41896314
you're welcome ~ happy to help

with all due respect, Gustav, the CTR (click-to-run) version IS  light and does NOT include everything in the version that is installed downloading and using an installation file.
0
 

Author Comment

by:pcalabria
ID: 41896319
Crystal, does this mean there is a way to install a more comprehensive or complete version of A2016 than what was installed by the Office 365 install utility?

Thanks
0
 
LVL 23
ID: 41896328
if you installed by clicking on a button on the web, you got CTR.  Links are always changing though so you'll have to do some research to get an installation file.  When you find it, if you could share a link back, I will make a note of it to pass on.
0
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 41896329
I use it all the time. From our Office 365 ProPlus E3 subscription. What is left out?

Proplus.PNG
/gustav
0
 
LVL 23
ID: 41896338
2 things come to mind immediately:

1. if you customize QAT to add 'About', the CTR does not have "System Info..." and "Tech Support..." buttons below OK.  System Info is very useful.

2. Windows APIs such as browse to file are not in CTR ... at least not as of about 1/2 year ago; haven't checked lately

It is not that PRODUCTS are left out ... just that they do not have full features.  That is why it installs so fast.
0
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 41896375
1. I see no "About" to include in the QAT, but those two (left out) options don't impose limitations to Access.

2. Not sure what you mean - I can call all the APIs of Windows ..?
Are you thinking about the runtime which won't run the Office file dialogue?

The reason for the fast install is that only the basics are downloaded and installed first and then you - impatient as you are supposed to be - are offered to start. In the background the fancy features are downloaded and installed - some later on demand.

/gustav
0
 
LVL 23
ID: 41896414
> "1. I see no "About" to include in the QAT, "

when you go to the customize dialog box, choose All Commands. You should see 'About' on the left and can double-click to move it to the right, which is what the QAT has.
Access QAT customize -- About
> "don't impose limitations to Access."

It is an easy test to see what you have. Perhaps I do more intense things than most -- it is limiting if you find out you don't have something you need when it is needed (that is not the time you want to discover you need to reinstall).  I have the full version and only run into issue when I connect to others -- then they do the research and get installation files.  

> "some later on demand"

used to be that features would be installed when needed -- but not how things are done now. Some of the libraries you can choose from Tools, References are not there because they are not on your drive, nor are instructions to get them, with CTR -- only with full version.  I had to modify programs to take away the browse button and force users to paste info because libraries weren't there -- too many users to instruct so the capability was removed and more put on the admin to setup. I have now deleted the code so I can no longer see what was being used. Don't care to argue -- take it as you want to. Just a heads-up for those who may be interested.
0
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 41896605
1. Oh, I didn't select "All". Now it appears, thanks. But it is the same box as you reach from Files, Account, About. And true, no System Info, only a long list of helping tools used by Access.

Still, I can't see how you can state that a missing System Info and a support link limits the capability of Access.

2.
.. it is limiting if you find out you don't have something you need when it is needed (that is not the time you want to discover you need to reinstall).  

True, but that is not the case. In fact, on all my machines I have never had to reinstall except when upgrading.

.. too many users to instruct so the capability was removed and more put on the admin to setup.

Of course, if you - or an admin - choose not to install all features, you may miss something along the road. You may call such an installation for a "light" Access, but it is not related to the install done from Office 365 or an ISO.

I don't want to argue as I have zero issues, just curious if I really should miss something - but you should be careful not to confuse people not that skilled in Access.

/gustav
0
 
LVL 23
ID: 41896647
> "And true, no System Info, only a long list of helping tools used by Access."

so you are missing features.

> "Still, I can't see how you can state that a missing System Info and a support link limits the capability of Access."

this is a good indicator so I can figure it out quickly.

perhaps this will give the full version

Use the Office 2016 offline installer
https://support.office.com/en-us/article/Use-the-Office-2016-offline-installer-f0a85fe7-118f-41cb-a791-d59cef96ad1c
0
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 41897073
OK, we are talking about different matters, I can see. But thanks anyway.

And we do have the Office Professional Plus 2006 32/64-bit ISO - its just much more convenient to install from Office 365.

/gustav
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question