How To Disable Form Window While The Second One Is Being Opened?

May 17, 2006

Hi all, I have a main form which contains buttons to control all other window. I'd like to prevent user to work on two forms at the same time. Can anyone advise me how to disable the main window while the second window is opened?

thanks

View Replies


ADVERTISEMENT

How To Disable Save / Close Window In Form

Aug 14, 2012

I would like to disable this window : (which appears by right-clicking mouse on form headline)

So the users won't be able to close form by right-clicking. How to do it?

View 2 Replies View Related

Forms :: Disable Or Hide Minimize / Restore And Close Window Buttons On A Form

Mar 9, 2014

I need to disable or hide the restore, minimize and close window buttons found in the top right hand corner of a form.

I navigation buttons that controls open, close etc already set up.

View 4 Replies View Related

How To Disable The Properties Window

Nov 30, 2006

I was hoping someone knows how to disable the ability for users to gain access to the properties window.

When viewing a form (or any object), one can usually right click, click on the corner of the form, or a few other actions and gain access to the properties option. If selected, the properties window is displayed with all the object's properties.

Is there a way to NOT allow the users to select this option? i.e. to disable this option from the menu list?

Thanks for any help you can provide.

-arm1

View 3 Replies View Related

Disable Window Unhide

Apr 8, 2008

I have a Access database that is used as the user interface for general users but the data is stored in SQL. My client has asked that general users be able to see only selected fields in the table. This means that they must only use the form to view records and not be able to get to the table.

How do I disable the the Window Unhide in the MDE?

View 2 Replies View Related

How Can You Disable The Close (X) Button On The Database Window?

Dec 6, 2006

Hi Guys,

I have a database that uses a switchboard with a close button that runs several instructions before it exits. The problem is that some users have access to the database window and I need to prevent them from closing the database by hitting the X in the upper right.

Anyone know how to do this?

View 8 Replies View Related

General :: How To Disable / Prevent Overwrite Option In Window From Being Selected

Sep 8, 2013

Creating a database for processing survey data into a report format. We receive these reports as paper copies, which are then scanned in using Remark Office OMR. This results in a table of data, which is intended to be appended to the existing table in the database using Save As --> Access 2007, selecting the database and target table, clicking save as, and then selecting 'Append' from the subsequent popup.

What I want to know is: Is it possible to disable/otherwise prevent the 'Overwrite' option in this window from being selected? Can I make the table or database in such a way that data can only be added, not edited or deleted?

View 3 Replies View Related

General :: Disable Navigation Pane Db Window / Tool Bars To Users

Mar 11, 2013

I use Access 2007.I have a db split in FE(forms, queries, vbcode) & BE(tables only).I want users not to be able to view or explore the tables, the queries, the form design and details, in both Ends.Unfortunately, even disabling via VB code the menus, the db window, the tool & status bars, they appear and are accessible to the users (it only works in a non-split db, turned to an accde).

How can I disable any view on forms, queries, vbcode and tables details and data to users, in both FE and BE and only allow them to add data through specific form?

View 11 Replies View Related

Update Excel Spreadsheet That Link To A Form While Users Having Form Opened

Sep 17, 2014

What is the best way to accomplish this? I have a database that split into the Front end and the Back end. The form that the users entering the information uses the queries from two sources. One is the a table within Access and the other is an excel spreadsheet that I link to it. How can I update /replace the Excel spreadsheet while users are using the form of the front End?

View 9 Replies View Related

Form Won't Stay Put When Opened

Nov 8, 2005

I have a Main Form that utilizes tabs to control several other forms by opening, closing and making them visible/invisible. One of the forms needs to be closed when its tab on the Main form is unselected. The problem is that once the form is closed, when it opens up again it opens right infront of my Main form's tab control so I need to move it down an inch to get to the tab control.

I've positioned this form where I want it and saved it numerous times. But once I select the tab, it opens up right ontop of the Main form's tab control again. I have the AutoResize set to No and the Auto Center also set to No.

Any ideas how I can get this form to stay put?

Any help is most appreciated. Thanks.

View 2 Replies View Related

Formatting A Form Before It Is Opened

Jan 2, 2006

hopefully someone will know what to do...

i have a form that has a bunch of check boxes and labels that are hidden to start with,and become visible when a confirmation button is pressed. Wen i set this up in the design view i.e making their visible status = false, everything runs accordingly - however when the next person comes to update their details the form will not format properly. i think the reason has something to do with the check boxes having different visibilty statuses after the initial confirmation i therefore used code on the form open event

If Check2.Visible = True Then

check.Visible = False
End If

however this tends to fail at the first checkbox, however if i then press run on the VBA screen everything else seems to then run fine and so only the first checkbox is left visible...

can anybody help....

thanks in advance i hope i have made myself clear..

View 2 Replies View Related

Form Size When Opened

Jan 18, 2006

Hi
Is there a way I can make a form open to maximum size to fill the work area without click the forms Max button


dave

View 1 Replies View Related

Which Tabel Was Opened, Who And When Opened It

Apr 26, 2006

Hi
I want to see Which tabel was opened, who and when opened it.
And if possible I want to see what is changed.
I want to see as I mentioned above as a "log file"

Thank you
Sedat ONAT

View 3 Replies View Related

Viewing Form When Database Is Opened

Sep 2, 2005

Hey there, when a user opens my database, I want the form to enter records to automatically open. Can someone plz help with that... thx

View 3 Replies View Related

Forms :: Refresh Form That Is Already Opened

Mar 17, 2013

I have forms that show commitments by Client, by Cost Centre, by Provider etc.

If I add new commitments or edit commitments it is done through the Commitments by Client form, as all other forms lead back to this one.

To create a new or edit an existing commitment, it is done through a Commitment Form, which goes into a query (query A)which does all the calculations. My client form has subforms based on Query A, however my other forms (commitments by Cost Centre etc) have subforms which have querys that are based on Query A . I hope that made sense.

My problem is that If I edit a commitment, the client form and subforms refrlect the changes imediately, even though they are open and I can see them changing when I change the commitments. However the other ones don't unless I close them and re-open them.

My navigation within the database is based on once a form has been opened it is set to be invisible untill called on again (i.e. visible = False).

How to requery all the forms without having to close them.

View 1 Replies View Related

Go To Last Active ID When Form Is Opened Or Refreshed

Sep 14, 2012

I have main form with everything on it using tabs and so on and everything is working fine. What I would like to do is this. Since I am jumping frequently between different records and many actions require main form to be reopened or refreshed and when this happens the form goes to random records, I would like for form to go to last record i was on before it was refreshed or opened.

I was thinking using tempVars to set the id but the problem is that I am not sure what can trigger the TempVars since I am jumping between the records and not making any changes to them.

View 3 Replies View Related

Update Form Everytime Database Is Opened

Jan 24, 2006

One of the forms in my database has a calculated text box control. The calculation is conditional, one condition being based on current date. One of the queries display that calculation. If the the form with the calcualted control is not opened before running the query, the calculated control uses the day the form was last opened as the "current date" which is not what I want. I want to do one of two things:

Either: (Preferably): update the form everytime the database is opened, so that the current date is actually the current date and not when the form in question was last opened.

Or: Update the form first before the query in question is run. This is not preferred because, if I use the calculated control in another query or something, I have to have another "update" step.

View 4 Replies View Related

Deactivation Of Mouse Second Button In Opened Form

Mar 16, 2006

How can i deactivate mouse second button click on form?

Can anyone help me pleae? :)

View 1 Replies View Related

Modules & VBA :: Pass Value To Form That Opened A Popupform?

May 9, 2015

I have two subforms in a tab formation sitting on a main form. They can both open up a single popup form (via a button) and that popup form is opened via openargs with the autoID field.

What I need to do is pass back a value on the popup forms [On Unload] event to the subform which opened it.

As the popup form is Modal, the subform which opened it can't be changed.

Am I right in thinking I can pass back the value to the form which had previous focus?

Previously, to pass a value from a popup form to a single form I've been using

Code:

If CurrentProject.AllForms("MyForm").IsLoaded Then
do this
else do this
end if

But in this instance, how do I code the On Unload event in which to tell Access which form opened up the popup form, and pass a value back to it?

I'm guessing
Screen.PreviousControl.SetFocus
has something to do with it?

View 14 Replies View Related

Form Doesn't Always Update When Opened. Is This A Requery Problem?

Apr 11, 2005

Please refer to the attached file. The form of concern is frmAssessmentInput.

Select the appropriate criteria per instructions (in red), including entries on the continuous subform. Then click the "Input data" command button. A 2nd form opens (frmObservations) that contains a textbox labeled DocumentStreamID, and this textbox SHOULD contain the value from the corresponding DocumentStreamID textbox contained in the master form, where you clicked the command button. However, even though the sources are linked properly, the value doesn't pass if you click the command button immediately after adding a new record to the continuous form; it only passes if 1) the master form is closed and reopened first, or 2) if you close the 2nd form, toggle to design view and back to form view for the master form, and then click the "Input data" button again.

What is going on here? Given that the value passes once another procedure is run, do you think this a requery problem? I tried placing a VBA control requery in the 2nd form's On Current and On Load events, but this didn't solve things for me so I took out those event procedures (code could have been wrong though).

View 3 Replies View Related

Modules & VBA :: Saving Combobox After Form Is Closed And Re-opened

Sep 26, 2013

I have a main form called frmAF54. In this main form I have a subform named frmPassdown. The subform record source is from a table called tblCards. This table contains many different cards. I have a combobox called lstOpCard in the main form as well. The combobox lists all of the different cards in "tblCards". I have a button called "buttonFilter".

A user opens the form and clicks (or selects) the different cards in the combo box "lstOpCard" that they want to filter for. Once their selections are made, they can click the "buttonFilter" button and the subform "frmPassdown" will be filtered based off of their selections.

The filter is applied using the IN() function as shown below:
Me.AF54PassDown.Form.Filter = "[OpCardID] IN ( " & sTemp & " )" --sTemp is a string containing the keyIDs of the cards selected.

My problem is that people will be opening and closing the form throughout the day / week. When the form closes, it loses the applied filter. How can I have my filter on the subform be saved after the form is closed and the filter is still applied when the form is opened later?

View 1 Replies View Related

Forms :: Access Form Must Be Opened In Design View Before Use

Oct 1, 2013

I have a access form that has a text box that holds a search term. The search term is used as a variable in a query. The query results populate a list box. Selecting a result in the list box populates the rest of the form where the record can be edited. All of that works great...sort of. When first opening the form you cannot view any records. The search function works fine and the list box populates but selecting a record does not populate the rest of the form. Attempt to navigate (next, first, etc.) and you get a "You can't go to the specified record" dialog. There is a simple fix for this. Open the form as normal. Then switch to design mode. Do absolutely nothing. Switch back to form mode. All is well.

View 1 Replies View Related

Forms :: Macro To Close Report And Opened Form

Mar 10, 2015

I am using MS Access 2003.

I would like to open the form = VendorPayables_Maintenance_F
Choose a cheque number
Print the cheque

How to create a macro to
close the open report = d_One cheque information
and close the open form = VendorPayables_Maintenance_F

View 2 Replies View Related

Modules & VBA :: Export From MS Access To PDF With Set Variables From Opened Form

Jul 9, 2015

I have been at this for almost 3 weeks now and I'm having great difficulties trying to get this right and working. First let me explain what I am doing and what I am trying to do.

Firstly, I am making a Maintenance database using MS access software, what I have are tables, forms and no queries or report existing so far. The forms and tables all work correctly.

After the form (Job request) has been completed I need to save/export into PDF so I am able to hyperlink it against its existing asset card elsewhere.

now what I have done is Created button, on event "on click" I have tried to go to macro builder

ExportWithFormatting
Objet Type: Form
Object Name: FrmMachineFault/GenMaint
Output format: PDF
Output file:
Auto Start: No
Template File:
Encoding:
Output Quality: Print

when I click this button it opens to save to and it works perfectly but I have to manually type the file name when it gets to the Save to section.

What I want it to do is define the name by the existing fields in the open form. Example Closed date, Effected area, Asset and title.

What I am hoping for is something like this.

10/07/15_Foundry_Furnace_LPG_Leak
(Closed date)_(Effected Area)_(Asset)_(Tittle)

Is this possible?

View 14 Replies View Related

Forms :: Hide Controls When A Form Is Opened Conditionally

Oct 7, 2014

I've searched and can only find information setting the visible property when selections are made on an open form--I want to set the visible property when the form is opened depending on which avenue the user chooses from the navigation form.

I have a navigation form (Form A) and a second form with a subform (Form B). The user will choose from a combobox, either an existing record or a new record on Form A. On Form A there are two buttons, one that will take the user to the correct record on Form B for editing and one that will open to a new record on Form B. Once Form B is open, all controls will be blank (if a new record is chosen) or with certain controls prepopulated if an existing record is chosen.

What I want to do is to hide controls on the main form (not the subform) of Form B if the user chooses an existing record. Form A's buttons work correctly to open Form B right now. I want to be able to hide prepopulated controls on Form B if the user chooses an existing record from Form A.

Here's the code I'm using to open Form B to an existing record. I'd like to set the visible property here if at all possible.

NOTE: "Form A" and "Form B" are not the actual names of my forms--it's just easier for illustration purposes here in my question.

Private Sub cmdAddLogEntry_Click()
DoCmd.OpenForm "Form B", acNormal, , "Activity_ID = " & Me.cboINum
DoCmd.Close acForm, "Form A", acSaveYes

End Sub

View 4 Replies View Related

Forms :: Access 2007 - No Records Shown When Continuous Form Is Opened

Dec 21, 2014

IN Access 2007 when a Continuous form is opened there is no records shown.

Only after hitting the page down records are shown.

View 1 Replies View Related







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