Create a popup form upon opening ACCESS

[johnseito]

Hello,

I am fairly new to Access. I am trying to create a form in access that upon a user opening it a form will pop up with a button for them to click.



Please advise and provide some example if possible.

Greatly appreciate it.

[June7]

This can be a file setting: File > Options > Current Database > Application Options > Display Form

[Micron]

If you want to disallow any other user action until that form is dealt with, make the form modal as well.

[johnseito]

June7 -

Thank you for your response and information.
I did just that and when I click on Access to open it, I couldn't see the form or the button.
However when I go to the form after is has opened (meaning access), and switched to layout view I could see the form and the button.

[johnseito]

Micron - Ok, thanks for that nice piece of information.
I am sure it can come in handy and that I will need it soon.

[June7]

If you can't see the form, exactly how do you go to it?

Default form setting works for me. I don't understand issue you describe.

[johnseito]

I actually just want the form to be visible and not Access (not sure if this is possible)
With your steps Access is still visible (but I tried it, in my situation, I couldn't see the form or button).

[johnseito]

If you can't see the form, exactly how do you go to it?

I go to it by open Access and click on the form and in design view I could manipulate and design the form.
and then in layout view I could see my changes made.

But with your steps - I was hoping after your step, I close and save Access then open it again and I am seeing a pop up
of the form with the button (ideally I just want the form to pop up with the button and not see Access at all but not sure if this is possible).
I want it this way is because so user can just put an excel file, set it up, and then click on Access, a form and button pops up and all they do is
click on a button to run the program and the program do what it needs and give them the result in excel formatted workbook/worksheet.

Default form setting works for me. I don't understand issue you describe.

How to default form setting ?

[Micron]

Can you see a Word document without seeing Word? Can you see a workbook without seeing Excel?
You might have a good reason, but I'm wondering what's the point of building a database that you can't see?

[johnseito]

I meant you can see access but not to where the user can do things that can break the program and only allow
just what they need to use it. I am trying to create this access application not for the user to view, or search for information stored in it
but to use it just as a program that analyze data and produce a result. I use access instead of excel because access can
do query to data which I think can be quicker than using excel and loops.

User can see Access, but then the table, query, macros and module should not be in the view of the user because
it wouldn't be robust and the user can break the Access program set up. User just open access and a form pop up
with a button and they just click on it to run the access program.

Sorry I am not trying to make it difficult or anything, just want to see the options and capabilities of Access and make it robust and user friendly application
for just what user need to do to use it.

[June7]

It is possible to set up an Access file to open without the application frame displaying, just forms and reports. It requires VBA code and from what I've read it can be a bit frustrating for users.

I just disable the Navigation Pane, shortcut menus, function keys, and customize the ribbon, also disable the app X close and the File Exit. Review https://www.accessforums.net/showthread.php?t=48543

[johnseito]

Ok - I wonder why it would be frustrating for users when they don't need to see or use any of the underlying data to use it. Thanks :-)

[Micron]

I meant you can see access but not to where the user can do things that can break the program and only allow
just what they need to use it. I am trying to create this access application not for the user to view, or search for information stored in it
but to use it just as a program that analyze data and produce a result. I use access instead of excel because access can
do query to data which I think can be quicker than using excel and loops.

User can see Access, but then the table, query, macros and module should not be in the view of the user because
it wouldn't be robust and the user can break the Access program set up. User just open access and a form pop up
with a button and they just click on it to run the access program.

Sorry I am not trying to make it difficult or anything, just want to see the options and capabilities of Access and make it robust and user friendly application
for just what user need to do to use it.

That is an entirely different animal. You can make an Access db look like most other programs insofar as June7 is saying. I believe June7 is saying hiding the whole application window is what the frustrating pain can be - not what it sounds like you want to do. A customized ribbon with the navigation pane hidden and the db designed so that users cannot use short cut menus, etc. to expose things you don't want them to see is probably what you're after.

[June7]

Something about if a form is minimized then restored, the app window also exposes. But it's been a long time so my recollections are jumbled. So maybe it wasn't user that was frustrated, but the developer.

http://www.tek-tips.com/faqs.cfm?fid=2562

And other issues have to be dealt with: https://social.msdn.microsoft.com/Fo...w?forum=isvvba

[Micron]

After recalling that this has been asked in this forum several times that I'm aware of, I searched this forum and found one where there's code and it was marked as solved.
https://www.accessforums.net/showthr...+access+window