General :: How To Disable Main Screen

Jun 8, 2012

Is there anyway to diasble the window that has the circle in the left hand. When I open my database I just want the form to open. I dont want the window with the toolbars to open it jus gets in the way an is more of a hassle to deal with.

View Replies


ADVERTISEMENT

General :: Disable Home Screen For Front End Users?

Jul 23, 2014

I have a database that logs people in and out. Works great unless the user minimizes the navigation page and clicks the X on the main Access Page. I have to keep the minimize button active on my nav page.

Is it at all possible to disable the main access page for the user?
If not, is it at all possible to set a logout macro to the X button on the main page?
If not, is it at all possible to set a logout macro to activate on "Quit Access"?

View 4 Replies View Related

Main Screen Subform Based On Query Reflecting Changes Only On Closing Database

Jun 25, 2006

I have a problem in reflecting the updated changes on a main screen subform based on a query .These changes get reflected only after closing the access database and reopening it .Tried the requery command. Also made a macro to update the query and run it after the form opens or load but not reflecting change in main screen immediately .I would be grateful if I can get some help on this forumThanks

View 3 Replies View Related

Disable Textbox On Main Form From Button On Subform

Jun 23, 2005

My subform when i click the New record button on the subform i want it to disable a text box that is on the main form.


Me.Pensioners.Form!quicksearch.Enabled = False

where Pensioners is the name of the Parent Form. Thhis isnt working for one reason or another. Please advise.

View 3 Replies View Related

How To Disable Subform Untill Values Selected In Main Form?

Jun 29, 2005

Hi every body . I got a a form and sub form. I want to disable sub form untill the user finishes selecting values from combo box drop downboxes. I be happy if some one show me how to do this.


http://i5.photobucket.com/albums/y180/method007/disablesubform.jpg

(form picture)

View 3 Replies View Related

Modules & VBA :: Look Up A Value In Table That Enable Or Disable Subform In Main Form

May 20, 2015

I have written code to look up a value in a table that then enables or disables a subform in my main form. The code works, but I know it is now as efficient as it can be. The main problem is that I have multiple values that determine if the subform should be enabled or disabled. I would like to use an IN statement but I'm pretty sure this doesn't work for Dlookup. Below is an example of the code I currently have:

Code:
Sub enablecontrols(setting As Boolean)
Inv_subform.Enabled = setting
End Sub
Private Sub Form_Current()

[Code] ....

Like I said, this works fine, but I am concerned if I need to add more items to look up and the stability of the code in general.

View 3 Replies View Related

General :: Display Progress Message On Screen

Jun 24, 2013

I want to display the message "Processing Record ? of ???..." on the screen while my vba code is running without interruption. Since the msgbox requires the user to click a button to continue, what is the simplest way to display this message on the screen without interrupting the program or requiring user interaction?

View 2 Replies View Related

General :: MS Access - Multi Search Screen

Jul 14, 2015

I am trying to build a Multi Search Screen and just do not know how to achieve this. what I want the application to do is:

1) I Created a main form for data entry called 'Orderfrm'
2) The Orderfrm Field EmpNo - I created a Search Button.
3) Users to enter the Employee No or Surname or FirstName (multisearch) and hit the search button to search for the relevant employee.
4) I would like then to open a 'SearchFrm' with the details of the employee.
5) If it is more than one employee - the system to list them all
6) users will select the correct employee details and finally the system to autofill the details in 'OrderFrm'

I am attaching the database.

View 2 Replies View Related

General :: Fitting Form According To Screen Resolution

Nov 21, 2013

I created a form which fits to my screen resolution. When I open it through an another computer which has different screen resolution then my form is opening according to my 1st screen resolution.

I wanted to fit the form resolution to the desktop on which it it opening. Is it possible?

How to set the form the screen resolution on which the form is opening.

View 3 Replies View Related

A Simple Login Screen / Also Access In Full Screen

Jul 27, 2006

I have tried to make a login screen, I have also searched for information and tried some of the examples but, I just can't get one to work.
Is there someone or somewhere where I can get information on how to build one step by step in simple easy instructions....(access 2003).

Also, how do you get access to open all the windows, tables, queries etc in full screen mode.
I have expaneded them and shut it down and then reopened it but they still want to open out of full screen mode.

Thanks, everyone has been a great help in creating my first Access program.

View 3 Replies View Related

General :: Invoking On Screen Keyboard In Window 8 From Access

Apr 18, 2014

Is there anyway to bring up the on screen keypad or on screen keyboard from Access when running Windows 8 on the desktop? It would really be useful if someone was on a tablet wanting to input data in a text box if could automatically invoke the onscreen keyboard. By default when running applications on the desktop in Windows 8, one has to manually bring it up. I would like to include a touch option so every time wanted to enter data, they would not have to manually touch display keyboard option. A number pad like in excel for iPad would be even better. If text field would bring up keyboard, if number field, it would bring up number pad.

View 6 Replies View Related

General :: MS Access White Screen - Error 1002

Aug 13, 2014

Our client has about 10 end users on Terminal Serve, and they occasionally get white screen error. The event log show following error message

"The program MSAccess.exe version 14.0.7104.5000 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Problem Reports and Solutions control panel. Process ID: 51cc Start Time: 01cfb681b4d13efe Termination Time: 0" Event ID 1002.

Server has MS Access 2010 (SP2) runtime installed. The error happens randomly, and happen on a particular form. When user has updated form details, click EXIT button, the white screen occur.

View 7 Replies View Related

General :: Distributed Application - Variable Screen Sizes?

Mar 26, 2013

Is there a means of making an application grow/shrink to accommodate different screen sizes? eg. not all users of a distributed application will necessarily have the same screen size.

View 2 Replies View Related

General :: Change Splash Screen For Database Using Method Of Creating Alternative Bitmap

Oct 17, 2014

I've changed my splash screen for a database using the method of creating an alternative bitmap.Is there a time setting for this or an alternative?

View 6 Replies View Related

General :: Disable Security Warnings

Sep 21, 2012

I will be sending out copies of a program to several locations. Once I send the program I have absolutely no control over it. The FE file will always be in the same folder. The setup process creates C:MyFolder with the FE file in there. Is there a way to to programmatically disable the warnings throughout setup or to make C:MyFolder a trusted location?

View 3 Replies View Related

General :: How To Disable Menu Choice

Jun 16, 2014

I have several menus defined for Access 2010. However, only one is set with the visible property set to true.The user is able to show and bring up the other menus by right-clicking in the menu area. How can I disable this so the user may not bring up these menus? An example is shown in the picture below. I don't want to give the user access to the "CPLAccess" and "Datasheet column removed" menus, but I do want to keep them so that I can make them visible via VBA.

View 8 Replies View Related

General :: Disable Import Of Access ACCDB?

Jul 4, 2013

I have a .accdb with security where ihave hidden navigation pane and toolbars...

Now left with one more thing, is it possible to disable anyone trying to import stuff from my database?

Maybe some code or is there a setting somewhere in current db?

View 5 Replies View Related

Forms :: How To Disable Edits In General Tab But Not In Calls Tab

Apr 9, 2013

I have a form called Contacts that has two tabs. One is called General adn the other Calls.

In the General tab I have a bound field called CustomerIDdet which can be numeric or alphanumeric. I need to disable edits in the General tab but not in the Calls tab if CustomerIDdet is numeric (and it follows certain additional rules)

I have placed this code in the Onload even for the form:

Code:

If Len(CustomerIDdet) = 9 Then
If IsNumeric(CustomerIDdet) Then
If Right(CustomerIDdet, 4) = 9090 Then
If Left(CustomerIDdet, 1) = 0 Then
'disable editing in the General tab
End If
End If
End If
End If

I know how to disable edits control by control, but can I disable edits in all controls in that tab at once?

View 2 Replies View Related

General :: Function To Enable / Disable Screensaver

Jun 10, 2015

I need an Access 2010 function to enable/disable screensaver on W8.1

View 1 Replies View Related

General :: Command Button Enable Or Disable

Jul 27, 2012

I have a form. and it has three buttons. Such as Submit, Reject, Under Observation.

I want :
1) If i click SUBMIT button it will be disable and other two buttons REJECT and UNDER OBSERVATION will be enable
2) If i click REJECT button it will be disable and other two buttons SUBMIT and UNDER OBSERVATION will be enable
3) If i click UNDER OBSERVATION button it will be disable and other two buttons SUBMIT and REJECT will be enable

View 1 Replies View Related

General :: How To Disable Textbox After Saving Data

May 6, 2014

I have some field in my details section,It works like a grid view,if I search data by query then It shows all of the related data from database,then I edit or save data one by one,but the problem is I want to disable text box after edit/save data.But if I write code like--

If Me.Text103 > "" Then
Me.Text103.Enabled= False
Else
Me.Text103.Enabled= True
End If

It disable the all of the rows,but I want to disable only the specific field where I enter the data.

View 4 Replies View Related

General :: Disable Printing Of All Records In Forms

Feb 5, 2013

Is it possible to disable the printing function in a form ?

We are getting people clicking the print icon when viewing a single form record. This results in the printer printing all records !!

View 2 Replies View Related

General :: How To Hide Or Disable The File Tab From Front Ends

Apr 12, 2013

How do I hide or disable the File tab in Access 2010 on my front ends?

The file tab being present allows end user to get into Privacy Options and Printing. Printing is okay if I could disable the Privacy Options for end users, then it wouldn't matter if they have access to the File Tab.

Possible very serious security issue!

View 2 Replies View Related

General :: Disable Close Button Access 2013

Jul 18, 2013

how to disable the main close button so the user is forced to click the Quit Application button on my main switchboard?

View 8 Replies View Related

General :: Bypass Shift Key To Disable Ribbon And All Menus At Startup

May 4, 2014

I am able to bypass the shift key so I can disable ribbon and all menus at startup.

But the issue I have is anytime someone makes a copy of the database or it is their first time opening it they get prompted with the security warning:

"Security Warning - some active content has been disabled, click here to enable"

and it gives them complete access to see the back end of the database because while that warning message is popped up ... before they click "enable" they can go do anything in the database including see tables, data, and vba.

Once they click "enable content" that first time the bypass takes effect and the ribbon and all menus disappear, but if they dont click it they can navigate all around the db

how can i stop that?

View 1 Replies View Related

General :: Disable Title Bar Minimize / Restore And Close Buttons

Oct 31, 2012

How to disable the Minimise, Restore and Close Buttons at the very top right hand corner of the Access application?

I have got buttons on my database to open / close everything so no need for them, even to hide the full Title bar probably be okay.

I am running Access 2007.

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved