Creating new userform on backend to avoid interruptions

Pookiemeister

Well-known Member
Joined
Jan 6, 2012
Messages
625
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
I think I might already know the answer to my question but I will ask it anyway. I know that only tables should be stored on the backend and not on the frontend (with some exceptions) but would it be possible to create a userform on the backend and "refresh the database" and see that form on the frontend? Thanks
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
You want to know if you can put a form in the be (not a good idea) and open it from the fe? AFAIK it is possible, but you'd be opening another instance of Access and the be as another database. You could interact with it but it's complex and convoluted. You can't actually open a form from another db and have it act like it belongs to the one you initiate this from, if that makes sense.

Why wouldn't you just put the form in the front end? What do you want it to do?
FYI - in Access it is just "form". Userforms are an Excel thing. It's like house cat vs lion, and the Access form is the lion. :)
 
Upvote 0

Forum statistics

Threads
1,221,499
Messages
6,160,169
Members
451,629
Latest member
MNexcelguy19

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top