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
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.
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?
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
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.
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.
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.
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));
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
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:
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?
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.
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....
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
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
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
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.
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
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?
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.