Hide A Combo Box

Aug 24, 2006

hello,
i'm trying to make the combo box hide after i choose one out of combo
box, eg: i have in combo box 1,2,3,4,5,6 and when i choose 4 i want it to hide
i have tried

me.nameofcombobox.Visible = False

but does not work because it has the Focus so i tried

me.nameoftextbox.SetFocus
me.nameofcombobox.Visible= false

but it comes up saying

Run time error '2108':

You must save the field before you execute the GoToControl action,
the GoToControl method, or the SetFocus method.

i don't no what to do can someone help me plz
___________________
David

View Replies


ADVERTISEMENT

Forms :: Hide Value From Previous Combo In Next Combo?

Jan 8, 2014

I have a continuous form which has 1 field in which is a combo box which has a list of names. Once you select a name, the next record down is available for selection. This is because my tables PK is a autonumber. How do i filter the records to only show the names which have not been previously entered in my above records.

View 11 Replies View Related

Hide Some Choices In Combo Box?

Oct 26, 2006

I have a combo box populated from a table containing names. Whomever processes the order selects their name from the combo box. Some entry persons have left the company but I cannot delete their names from the table as the orders are stored with their names and I want to maintain that history. Is there a way to hide their names from being displayed in the combo box?

View 2 Replies View Related

How To Hide The Drop-down Arrow On A Combo Box

Oct 4, 2005

Is there a method you can use to hide the drop-down arrow on a combo box until the combo box is selected?

View 5 Replies View Related

Hide Combo Box In Continuous Form

Jul 12, 2005

Is it possible to hide or show a combo in certain records in a continuous form. i.e if certain certain conditions are met.

At present I have if Check1 = true then Combo1.Visible = true

The trouble is it then displays the combo in all records.

View 2 Replies View Related

Hide Duplicates Values In A Combo Box

Mar 31, 2006

Hi Guys,

I have a problem. I'm trying to import values to a Combo List from a table:

Row Source = SELECT Tasks.Milestones FROM Tasks;

where Task is a table and Milestones a field of that table. In this field (Milestones) there are repeated values, but I'd like to hide those duplicates when I want to chose them from the Combo List. I don't know If it is clear, if not it's because I'm not an Expert of Access :p

Thanks a lot for your attention,

Ciao

View 4 Replies View Related

Forms :: Hide Records That Have 1 In Combo Box

Jun 10, 2013

I have a form with a checkbox and a combo box. When I click the checkbox, I would like it to only show the specified records that are in the combo box. The current code I have is this:

Code:

Private Sub chkHideComplete_AfterUpdate()
On Error Resume Next
If Me.chkHideComplete = True Then
Me.filter = "[ReservationStatus] = 3"
Me.FilterOn = False

[Code] ....

I basically want to hide all records that have "1" in the combo box.

View 2 Replies View Related

Combo Box Value Hide / Show Image

Jul 7, 2011

I'm using access 2007. I'm trying to get a combo box on a form to show or hide an image on a report based on the combo box's value. It seemed simple, but I've tried lots of codes.

View 7 Replies View Related

Combo Box-concatenate Field And Hide Column

Jul 8, 2005

Hi,

I have a combo box which is populated by a table with the fields ID, First Name and Surname. What I want to do is display the first name and surname concatenated and hide the ID column, but populate the field with the ID number.

Is this possible?

View 3 Replies View Related

Is There Any Way To Hide A Form...?

Oct 2, 2006

Hi.

I was just wondering if you can hide a form in the windows status bar?

View 3 Replies View Related

How To Hide All The Bars

Jul 28, 2007

How can I remove all the bars specially the menu bar:
File, Edit, View, Insert,...

View 3 Replies View Related

Hide Duplicates

Apr 4, 2006

Goal - Show how many policies (dbo_Policy22.Policy.Number) were cancelled during a certain time period (Invoice Date).

Problem - a policy can be cancelled more than once and I don't want to count it after the initial cancel status (885).

Question - Below is my query. I'm thinking I type "Distinct" somewhere, but I have no idea where.

Please help :) Thank you.

SELECT dbo_Producer22.Number, dbo_Producer22.Name, dbo_Invoice22.Invoice_Date, dbo_Policy22.POLICY_STATUS, dbo_Policy22.Policy_Number
FROM dbo_Producer22 INNER JOIN ((dbo_Insured22 INNER JOIN dbo_Invoice22 ON dbo_Insured22.Insured_Key = dbo_Invoice22.Insured_Key) INNER JOIN dbo_Policy22 ON dbo_Insured22.Insured_Key = dbo_Policy22.Insured_Key) ON dbo_Producer22.Producer_Key = dbo_Policy22.Producer_Key
GROUP BY dbo_Producer22.Number, dbo_Producer22.Name, dbo_Invoice22.Invoice_Date, dbo_Policy22.POLICY_STATUS, dbo_Policy22.Policy_Number
HAVING (((dbo_Invoice22.Invoice_Date) Between [Forms]![PfrmYearToDate]![txtStartDate] And [Forms]![PfrmYearToDate]![txtEndDate]) AND ((dbo_Policy22.POLICY_STATUS)=885));

View 2 Replies View Related

Hide 1 Record

Apr 10, 2007

I was wondering if there is a way to hide 1 record from a query

say I have 3 user accounts and on a form I only want to display 2 of them form the query,so the other record is still present but cant be deleted by accident or viewed

View 2 Replies View Related

Hide Field Value

Mar 22, 2005

I have a form with various fields, two of these fields are "Date Purchased" and "Lease End Date". When there is no value entered originally, I have made a default value of 12/30/9999.

The problem is that when you open the form and these two fields are next to each other, the user says it confuses them seeing a date even though it is a dummy date.

Is there a way for me to create a expression that will be something like:

IIf(DateField = 12/30/9999, Me.Datefield.Visible = False, Me.Datefield.Visible = True)

or VBA

Private Sub Form_AfterUpdate()
If Me.DateField.Value = "12/30/9999" Then
Me.DateField.Visible = False
Else
Me.DateField.Visible = True
End If
End Sub

If have tried both ways and neither works.

View 1 Replies View Related

Hide Record

Jun 8, 2005

Is it possible to just hide a record? My form is based on a query so I know I could remove the record that way but I also have a box that calculates a average time, so the data that is produced by that record still needs to be taken into account. I want to hide some records pureley so the user dosent have to keep scrolling thriugh loads of records. Is it possible to do this?

View 9 Replies View Related

Hide New Record Row

Jun 28, 2005

I have a continuous form "components" where the data is added by a query. There is no need to manually add records to the form, I just want to edit certain fields.

Is it possible to hide/disable the blank "new record" row at the bottom of the form?

I tried setting the form's "Allow Additions" property to no, but the line still appears.

Thanks for your help!

Frank

View 3 Replies View Related

Hide / Unhide

Aug 31, 2005

I created an app., for tracking changes, where once the user is logged in , the login form is hidden.
When a user modify the status of a change, i cretaed an event procedure in the update before. In that event procedure i am opening a new form to ask to continue or not and then i hide it. When the program comes back to the form where the event procedure is, it closes the hidden form, which asked to continue or not. The problem is that it closes the login form as well.
To sum up:
-Login form is hidden
- Edit form calls Confirm form
- when user comfirm, teh comfirm form is hidden.
- Edit form, close Comfirm form and also login form. (i dont want to close login).

Here is the code to close comfirm form in edit form....

DoCmd.Close acForm, "comfirm"

thank you, max.

View 1 Replies View Related

Hide Buttons

Nov 23, 2005

Hi,
I can hide buttons on a form but what I want is to hide/ show it when one of the fields has a specific value.

Cheers

Gordon

View 4 Replies View Related

How Do I Hide Access

Apr 3, 2006

Please give all the info you can. I have my database and forms set up. what I want to do is just see my forms and not see access in the background. Please specify where I enter code if it's provided. thanks for all your help,
Derek

View 1 Replies View Related

Hide Records

Jul 25, 2006

HI,
I have made form with a main form and a sub-form. The relationship between them are 1-t-many. The main forms key is security-number and based on this number the sub-form shows all the related accounts. One field on the sub-form is total arrears - and here comes my ?. Based on this calculated field - total arrears I would like to only show accounts if the total arrears are > X. Otherwise the main form - security-number should be the next in line.

I’m looking forward to hearing your suggestions. Thanks

BR

Henrik

View 1 Replies View Related

Hide Form

Sep 15, 2006

Hi, I have a form with a cmd butto that unhides a text box, this text box is quite big on the form and I want it to display extra informations, the problem I have is when I unhide the textbox this will appear under fixed fields on the form, I need this text box to appear over everything over the form, Hox can I achieve it?
Thanks
Marco

View 3 Replies View Related

Hide Forms

Nov 14, 2005

hello,
i have a form that shows up when I start my database. It has a combo that users use to select their initials.

This form is run by the autoexec macro.

The forms stores users names that then are propagates to other forms without having users each time selecting their initials.

Is there a way I can hide the first form behind others so that it keeps the data active? I have tried to minimixe it but still can see in the gray toolbar.
Thanks.

View 2 Replies View Related

Hide Everything But The Form

Jun 10, 2005

hello everyone,
I have a database that has only two tables and one form. There is about 100 people that will be using this system(not all at the same time), and I want to hide everything from them except the form, including the microsoft access window behind the form. if i just make the access window small and put it behind the form, that looks alright, but i don't want to have to go to everyone's computers and do that! i've already hidden everything else, i just can't figure out how to make it seem like it's a stand-alone application. Any ideas???
Thanks very much in advance
*j

View 11 Replies View Related

Hide Toolbar

Jul 20, 2006

I have create my first program. When you click on the program it runs (I am an expert now!) But when I want it to run, I want it to hide the toolbars on the top so no one can alter it. Any suggestion?

View 2 Replies View Related

Hide Toolbar

Dec 27, 2006

I am trying to hide some toolbars and have noticed that with the following command:

DoCmd.ShowToolbar "Design View", acToolbarNo

I get an error message. Is there a way I can avoid this toolbar to show whenever I issue an updated file? Thanks.

View 1 Replies View Related

Hide Subform If Criteria Is Met

Apr 12, 2006

Hi,
I have a main form which has a subform with another subform in it. Subform 1 gives details of a loan and a balance field which is calculated in subform 2 after amt paid is entered - using a macro on exit.

If the balance is zero after amt paid is entered. I want the amt paid field in subform 2 to be locked or disabled - preventing the user from entering further payments by mistake.

How can I do this?

View 4 Replies View Related







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