Visible False In An Event

Aug 7, 2006

Hi guys, here is my problem. thx 4 hlping me.

i created a form to work as a menu. At this point the menu has only one option (File) which is a text box. Once the user click on the text box FILE, a list box appears below, leting the user select between a few options. When the user clicked one of the options , a new forms comes (popup and modal in yes).

The problem is that when the second form is closed, the menu still has the list box visible. I would like to make it no visible but i dont know how.

any clue?

thx, max.

View Replies


ADVERTISEMENT

Set Form's Visible Property To False

Feb 17, 2005

This seems really straight forward to me. I have 3 forms - FormA, FormB and FormC. When I open FormA the user inputs some information, when they tab to the last field, FormB opens (which I want to be invisible) and Form C opens.

I've tried putting this coding on the Open event of FormB:
Me.Visible = False

I've also tried putting this code on the Open event of FormC
Forms!FormB.Visible= False

Neither work. My form (FormB) still displays when eithr event occurs.

Any suggestions?

Cindy

View 6 Replies View Related

Modules & VBA :: Change Which Row In Combobox Is Visible Depending On Event

May 21, 2015

I have a combo box with three columns, the first one is the bound one, the second is text in English, and the third is text in Spanish. Currently when the form is open, both the English and Spanish texts columns are visible. What I would like to do is set up a command button on a different form that will open the form with just the English showing in the combo boxes, and another button for Spanish. I've tried the following code which opens the form, but the combo box is disabled altogether.

DoCmd.OpenForm "frmEditar", acNormal, "", "", , acNormal
DoCmd.SetProperty "niv_gest", acPropertyColumnWidths, "0;1;1"

What am I missing?

View 5 Replies View Related

Forms :: Timer Event - Wait Until Form Fully Loaded Before Visible

Nov 7, 2014

I have tried using a timer event to not show a form until it is fully loaded, to no avail.

Code:
If CurrentProject.AllForms("FONNewEdit").IsLoaded = True Then
Me.Visible = True
Me.TimerInterval = 0
End If

I have tried using the onload, onopen but the form still displays before being fully loaded.

View 7 Replies View Related

Forms :: Visible / Non-visible Combobox - Column Attribute?

Oct 17, 2013

I have a combobox on my form called TypeOfBusiness, with fields including Corporation, Education, Industry, Non-Profit. In order to make a second combobox called IndustryClassification appear when Industry is selected from the TypeOfBusiness combobox, I have used the following code:

Code:
Private Sub Form_Current()
If Me.TypeOfBusiness = "Industry" Then
Me.IndustryClassification.Visible = True
Else
Me.IndustryClassification.Visible = False

[Code] .....

It works just fine. However, when a user selects both, say, Industry and Education, the IndustryClassification combobox will not appear. What code I can use to ensure the IndustryClassification box will appear regardless if another box is checked in addition to Industry? I am wondering if it has to do with the Column attribute.

View 14 Replies View Related

Modules & VBA :: Make Controls Visible Or Not Visible?

Mar 24, 2015

I have a Main Form with a Sub-Form, the sub-form is base off a query. on the sub-form i have 8 controls, one of them is "Status' and "Process" and "Review" My Main Form have a Refresh command that refreshes the data in the sub-form.

What i am trying to do is make the "Process" Control only visible is "Status" is a certain status and "Review" visible if "Status" is something else. what i have done works correctly On Open. I run into and issue on the refresh command. I get Run-time error '2165' "You can't hide a control that has the focus"

Code:
If Forms!Main_Form.[Name subform]!Status = "Ready" Then
Forms!Main_Form.[Name subform]!Process.Visible = True
Forms!Main_Form.[Name subform]!Review.Visible = False
ElseIf Forms!Main_Form.[Name subform]!Status = "Reviewing" Then
Forms!Main_Form.[Name subform]!Review.Visible = True
Forms!Main_Form.[Name subform]!Process.Visible = False
End If

I have done similar with a main form and making sub-form visible or not based on a control on a main form and that has worked perfectly. I am not sure how the control is getting focus and cause the error.

View 4 Replies View Related

Visible.Enabled Remaining Visible!

Sep 12, 2004

I have a form with four subforms set up in a tabs on the form. In the subforms I have a copuple of command buttons which enable/make visible fields when they are clicked (see previous posts but for eg) - if a height and a weight are added in two separate boxes a calculation is done and then a command button pressed to make visible the (label) which shows the mass index the patient falls into. My problem is that the label is then retained so if I click out of the form and re-enter with a new patient then the height and weight boxes are clear but the label from the previous patient remains.

I tried to put the code
Private Sub Form_Load()
If PtWeight = Null And PtHeight = Null And Text60 = Null Then
Label106.Visible = False
Label101.Visible = False
Label177.Visible = False
Label122.Visible = False
Label123.Visible = False
End If
End Sub
in both the open and on load event of the main form (not the subform) but it doesn't help. Any ideas?

(When should code be put on the main form and when on the subform?)

View 2 Replies View Related

Allowedits = False

Aug 6, 2007

i have a little problem, at least, i think it is little.
Within my access db form i have made a combobox for searching a number. When selected the applicable information will be shown in the detail part of the form.

I made a button in the detail section, to allow people to change the information.

However, after i placed the button with the allowedits = false and true part to autorise if people may or may not change the information, the combobox for searching a number only works when i first press the button [change] (so that the property is set on allowedits = true), then search the number by the combobox. Directly after that the combobox is not allowed to be used(!?)

What do i want?
- combobox is allowed to be used always
- information in detail section only is allowed to be changed when pressing the [change] button.

I am not sure how to do this, please help me if you want? :confused:

View 2 Replies View Related

Setting All To False

Jun 20, 2005

I've got a form which shows all the records in a list, with a check box next to each which is for choosing which ones to print. i have created a "de-select all" button, using a macro with simple SQL behind it -

"UPDATE companys SET print = false WHERE print = true"

when i test this button, it sets all the boxs to false except for the last one that was set to true. it also doesnt update the form straight away, sometimes the checks say until you scroll so the record is no longer on screen.

does anyone know how to rectify these problems?

Thanks

View 1 Replies View Related

IIF Function Not Returning The False Value

Jan 16, 2006

IIF function not returning the false value. I have the following results based on the query shown below.

SELECT Trade.Ref_No, Trade.CERS_Price, Market.[USD/EUR_Rate], IIf("CERS_Price_currency = US Dollar.USD",[Trade].[CERS_Price]*[Market].[USD/EUR_Rate] , 0) AS [Price In Euro], Market.[USD/CHF_Rate], Trade.CERS_Price_Currency
FROM Status INNER JOIN (Market INNER JOIN Trade ON Market.MarketDate = Trade.Trade_Date) ON Status.StatusID = Trade.StatusID;


Price In Euro USD/CHF_Rate CERS_Price_Currency CERS_Price
35 7 US Dollar. USD 5
91 7 Euro. EUR 13
1,715.00 7 Brazil Reais. BRL 245
759.00 33 Indian Rupees. INR 23.00


As you can see returns all calculations whether is USD or not.
Can you help please?
Ultimately I want to do this for all other currencies by nesting the IIF function.

Thanks

dfuas

View 2 Replies View Related

How To Change Every Checkbox Value To FALSE?

Oct 28, 2006

How do!

First post, spent a long time trying to find an answer but to no avail

How would you add a simple way to turn the value of a specific checkbox in each record in the DB to false?

Very nice place you have here, I hope I will be able to return some information at a later date :D

Cheers

Wmffra

View 3 Replies View Related

Me.Form.allowadditions = False

Nov 1, 2004

Hi
I have a subform with several records entered. When a particular entry is made in the subform
eg. chocolatebiscuit
I want the subform to not allow any more entries - records in that particular subform
Is there a easy way to do this?


I have tried to do this by saying
Me.Form.allowadditions = false

Unfortunately this works on the whole form
and stops the next subform - belonging to the next main record
from adding a new record.
How do I restrict the new records in A particular subform?

I tried
Me.Form.allowadditions = true
on entering the subform

but it doesnt work every time.

Also i put on enter
if not chocolatebiscuit then
allow entries
but for new records it takes the last entry in the subform
which could be two records back in the main form
says yes there is a chocolatebiscuit
and will not allow a new record.

View 3 Replies View Related

Adding A New Record Using With AllowAdditions Set To False?

Jul 17, 2005

Hi,

Is it possible to add a new record thorough VBA (for a command button) with the AllowAdditions property set to false?

I only want new records created if this command button is pressed.

TIA!

View 8 Replies View Related

True Or False Query Issue

May 12, 2006

I have a query that shows banned users (I work in a school). When a student's ban has ended, a tick box is checked in a form linked to tblBannedUsers to show they are no longer banned.

The query itself simply queries all records in tblBannedUsers with a username field (UserID) taking search criteria from a box on a form.

However, I want to filter out the students that are no longer banned (those with a tick in the checkbox). To do this, I thought it would be a simple case of editing the query, and in the Ban Lifted field criteria, use =False to say I only want those records with a tick.

This doesn't work and I still get all records given the combo box filter (which are just filtering for a username...if I leave it blank it gives all records via Is Null).

What should I be putting in the criteria to filter out those records with a ticked checkbox?

Thanks,

Steve Swallow

EDIT: I've just done a test query and <B>No</B> is the criteria to use, but when I use this criteria in my query which also take data from a form's combo box it ignore the <B>No</No> criteria.

View 4 Replies View Related

IIf Function - False Condition Problem

Dec 12, 2006

Hi, I've used the following code in the Criteria line in a query (Access 2000)and the false condition doesn't seem to work. If I replace the false condition >0 with any other single value (say 1) it works fine.

IIf([Forms]![frmReports]![cboServArea]>0,1,>0)

I'd be grateful for any help,
Thanks

View 5 Replies View Related

Command Button.Enabled = False

Jun 15, 2005

I have a form with many command buttons. This form is a master for a database that keeps time for my department. One command button is a setup button that I want the user to run once and only once. What code, and where do I put it will allow my to set the command button's visible or enabled to be false. Even when the user closed the database and reopend it, if the user has run the setup once, I do not want to allow them to run it again.

Thanks.

View 5 Replies View Related

Filter On A Form True/false/neither

Jun 2, 2006

Is it possible to filter a forms records by using a boolean True/False field.
I want to show all current records for option 1, Expired records for option 2, and all records for option 3. The form is based on 'tblMembers' which has a field [Expired] which is a boolean yes/no field formatted to true/false.

View 1 Replies View Related

Set Allowedits = False On Record Change

Nov 7, 2006

Hi

I was just wondering if it was possible to set the Allowedits setting to false whenever someone moves to a new record.

I currently have Allowedits = No by default on form open, and an "Edit" button which sets allowedits to Yes. However, I want the form to go to Allowedits=No again when the user scrolls to a new record.

Also, is there a way to set the form so that if someone makes changes to a record, the change doesn't automatically save unless you press a save button.

Thanks
Natasha

View 1 Replies View Related

Queries :: SQL Like Returns False Records

Jul 9, 2015

SELECT tbl_Visits.vst_VisitDate, tbl_Visits.vst_Complaint, tbl_Visits.vst_Diagnosis
FROM tbl_Visits
WHERE (((tbl_Visits.vst_Complaint) Like "*asthma*")) OR (((tbl_Visits.vst_Diagnosis) Like "*asthma*"));

returns records with no occurrences of asthma. about 4 of 638 hits.

View 14 Replies View Related

Modules & VBA :: Set Warnings (False) Not Working

Nov 1, 2014

I have a combobox, and the 'OnNotInList' event has code to show a message box, then set focus to another control. That all works fine, however I am still getting the system generated 'Not in List Warning', despite the code for the not in list event starting with DoCmd.Setwarnings (False)

How to disable the warning?

View 2 Replies View Related

Modules & VBA :: Sum Up 10 Columns For Same Row Of True / False

Sep 19, 2014

There are around 100,000 records to update. Would a SQL Statement be more efficient?

It is a local table being used to sum up the results of a handful of rules.
The columns can only hold True or False (datatype)
If and only if all columns are True - then true

MyRow T T T T T T T T T T - Sum in next column is T
MyRow T T T T T T F T T T - Sum in next column is F

Speed is very important. The Recordset for a single row is still open on the Currrent Record since the Update just finished.

Code:
RS_RE_1SegStatusProfiled.Fields("Total") = (RS_RE_1SegStatusProfiled.Fields("RE_1") AND CStr(RS_RE_1SegStatusProfiled.Fields("RE_2") AND (RS_RE_1SegStatusProfiled.Fields("RE_3") ' and so on

My guess is that since the recordset is open to the current record on a local table, it will be efficient to just re-read all of the values and And them together.

Since I have code writing to each record, I could also go through all the extra assignment of a local variable.

View 4 Replies View Related

How To Set Up An Error Message If Criteria Is False In A Query ?

Aug 9, 2005

How to display an error message if the specified criteria is false in a query?
what function should be used for that?

I have a query which has to check 3 conditions and if the 3 conditions are true then it should display an error message.

What should be done for that?

View 1 Replies View Related

Query Criteria True/false Field

Apr 25, 2006

I'm trying to limit the records on a subform via an option group selection. The group has 2 options: optionTrue (option value = 1) and optionFalse (optio value = 2). I have the following code in my query criteria of the true/false field.

IIf([Forms]![FrmHome]![frameProcessed]=1,-1,0)


The false part works, but the true part doesn't. I've tried many variations using true/false, using checkboxes, etc. and nothing works.

The database is SQL Server if that matters.

Any suggestions?

Also, is their a way to have an option for True or False or ALL?

Thanks,
Sup

View 5 Replies View Related

Returning True/False To A Form When Query Is Run?

Mar 9, 2007

I'm really not sure how to go about this. I'm creating a course booking system and when creating a booking I need to check for current bookings with the same employee and course id's (i.e. the employee is already booked on the course). The query takes the employee and course id's from a form, and is initialised when the 'book' button is pressed. It correctly selects if the person is already booked on the course but I want the query to return a value to the form i.e. if it returns null/false then the booking can be created but if it returns a record/true then the booking already exists and a message box can be displayed.

I'm not sure if I'm going about this the right way, can anyone suggest how this can be done as described above or suggest a better way of doing the task?

View 5 Replies View Related

Show If False But Wont Let Me Make It True

Sep 16, 2005

I have a form that shows the records found in a query if the completed tick box is false. this is fine, but i have also put the tick box on the form, and wish the user to tick it when they are done how ever they, get a beeping error and wont let you change it to true. Can anyone suggest the resolutoin for this.

View 2 Replies View Related

Option Group With True Or False Values

Jul 3, 2006

I want to create an opion group with two rad buttons in it. The values of those button wont be values but as true or false in order to use it in another text box to performa calculations. EX.

=IIf([radNew],"Hello",IIf([radUsed],IIf([txtAgeofCar]<184,[txtExciseinTotal]=Null,IIf([txtAgeofCar] Between 185 And 365,[txtExciseinTotal]*(-0.15),IIf([txtAgeofCar] Between 366 And 1095,[txtExciseinTotal]*(-0.2),IIf([txtAgeofCar] Between 1096 And 1825,[txtExciseinTotal]*(0),IIf([txtAgeofCar]>1825,[txtExciseinTotal]*(0.25))))))))

As you can see radNew and radUsed are the Options Buttons. Its not working in an option group.

Thanks in advance

View 2 Replies View Related







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