Forms :: Remove Grey Bar From SubForm

Nov 3, 2013

This seems like a really simple question but I have searched everywhere and can't find a solution.

I have a main form with a subform. The subform is in datasheet view.

How do I remove the grey bar from the left of the subform. I.e the row selectors where you click to highlight the entire row

I have attached an image in case

View Replies


ADVERTISEMENT

Grey-out Txtbox

Mar 30, 2006

I have a form that has several fields that a user will enter data. When finished, the data is inserted into a table. Works great. What I want to do now is look at one of the fields entered and if it is equal to a certain value, I want to disable one of the other text boxes (fields) on the form AND pop a screen that will allow the user to enter a list of names that will update a different table.

So, if user inputs a directory name GENERIC, the txtScriptName box needs to be disabled/greyed-out and I need a form to pop so the user can put in a list of script names. If any other directory name is entered, the txtScriptName box needs to remain editable. (For directories equal to GENERIC, there will be multiple script names instead of just one)

I've been successful at getting the form to pop if GENERIC is entered but can't figure out how to grey-out the txtScriptName field. I tried using Me.txtScriptName Locked in the Before Update of the preceding field but it didn't work - could still update the txtScriptName field.

Any other sugestions?

Thanks!
Mary

View 1 Replies View Related

Grey/disable Fields

Sep 16, 2005

quick question... i have a form with a "Save" button. i wanna disable/grey all the fields when user push the button, so they will not be able to make change... please help.

View 2 Replies View Related

Grey Option Button

May 23, 2006

Hi,

I have a group of option buttons. A user can select more than one. However, currently all of the option buttons have a grey spot in them except for the first one which is blank. I want all of the option buttons to be blank.

Any thoughts?

Thanks

View 2 Replies View Related

Grey Box Inside The Checkbox

Oct 13, 2006

I have a checkbox that has a grayed out box inside of it. What causes this/ what is it? I looked up the record and there should be a checkmark in the box. In the table it is set to have one.

I know that if the prefeances of Enables is set to No then all of the check box and the text label box is all grayed out, But in my case it is only the inner part of the box…. (And it is a Checkbox…)

The box name is ABC1 and it just reads the record, that’s it... It is used for reports later down the road. So there is not any code set to this check box.

Anyone have any ideas?

Thanks,

Darkhat01

View 7 Replies View Related

Cascading Combo Box - Grey Out If No Options

Aug 1, 2006

I have a form with two cascading combo boxes. The options available in the second box depend on what is selected from the first.

Some of the selections which can be made in the first box do not have any options to be selected in the second box and so it currently just pops down empty.

Is there a way that I can make the second box "greyed out" if there are no options for it?

Thanks,

Gary

View 13 Replies View Related

Odd Query Problem Giving Me Grey Hairs.

Mar 10, 2008

I have a query that updates a field on a table with the value in another field. When I run the query from the Access control panel, the query does exactly what it should do, 100% perfect. When I call the query using DoCmd.OpenQuery in VBA in an OnClick function on a form, it does not work properly, only appending certain amounts of information, leaving some fields blank.Can anyone shed some light on this.the SQL for the query is:UPDATE tblHolding SET tblHolding.CostGRV = [tblHolding]![OrderCost]WHERE ((([tblHolding].[Item Code])=[tblHolding]![Item Code]));It populates another field in the same record in the same table as itself.tblHolding is populated by a Subform on the Form that has the button that calls this query when clicked.Hope I am making sense.

View 3 Replies View Related

Close Form Leaves Grey Space

Oct 23, 2005

Hopefully just a simple one??? I am using a popup form to input data into a display form which is on one page of a tabbed control. The display form updates through an afterupdate requery command. This all seems to work OK but when I enter the new record via the popup form then close it, it leaves a greyed out space and I lose input ability. I need to close down and when opened up all records are OK. If I drag the popup box on the screen it leaves a grey trail behind it. Any ideas on what could be the problem?

Thanks

View 1 Replies View Related

General :: Using Check Box To Grey Out Certain Text Fields

Oct 24, 2013

I am trying to use a check box to either grey out certain text field(s). For example If the box is checked true then certain fields would become available to input data. If the box is not checked it stays grayed out.

View 8 Replies View Related

Remove Controls On A Forms' Opening

Sep 29, 2006

Hi there,

I've been puzzling over this one for a few days. I've done a few searches on here to borrow some code - but the fact is I don't understand how to implement the suggestions. I'm hoping somone can help.

Basically, I have a form for editing the database, however, there are a number of reasons for opening this form - so at the moment I have several copies of the same form all with very minor changes. In order to streamline the way I've done this, I'd rather have controls always call up the same Form - but state in their code whether or not certain controls on the editing form are visible or not...

:mad: :eek: :mad: :eek: :confused:

It's all gone rather Pete Tong here. And I must admit I'm button bashing the code a bit now. Basically, when a button is pressed, I want it to load the form "frmEditJob". Depending on what I want visible, the Tags "N, M and V" will activate and deactivate certain controls on "frmEditJob".

With me? :confused:

Any help is appreciated!

Cheers.

Private Sub EditJob_Click()
On Error GoTo Err_EditJob_Click

Dim stDocName As String
Dim stLinkCriteria As String


If IsNull(Me![IDEntry]) Then
strMsg = "You need to enter a Valid ID number in the box provided."
strTitle = "ID Number Error"
intStyle = vbOKOnly
MsgBox strMsg, intStyle, strTitle
Exit Sub
End If

stDocName = "frmEditJob"
Dim ctl As Control

stLinkCriteria = "[WorkorderID]=" & Me![IDEntry]
DoCmd.Close
DoCmd.OpenForm stDocName, , , stLinkCriteria


If ctl.Properties("Tag") = "N" Then
ctl.Properties("Visible") = False
Else
ctl.Properties("Visible") = True
End If

Exit_EditJob_Click:
Exit Sub

Err_EditJob_Click:
MsgBox Err.Description
Resume Exit_EditJob_Click


End Sub

View 5 Replies View Related

Forms :: Remove Layout Function

Apr 20, 2013

When I drop a field into a form I'd like to take the Lable Box and put in into the Page Header section and leave the data field or control box in the detail field.Sometimes I have available "Remove Layout" function to split the 2 so I can manipulate them around.

View 3 Replies View Related

Forms :: Way To Search And Remove Linebreaks

May 1, 2013

Data has been imported (from Word, Excel &/or PDF) into a Memo field in an Access 2007 database. Sometimes the data appears fine. Other times there appears to be excessive and unnecessary Linebreaks / paragraph returns throughout the data in the Memo field. Is there a way to search for and replace these linebreaks?

View 2 Replies View Related

Forms :: Remove Enter Parameter Value

May 26, 2015

I can not remove the Enter Parameter Value. In the attached date base, go to frmEvents, and double click on one of the shows, and you will get that error. I have deleted lines of code, text boxes, and anything else that is associated with the txtSearchS.

View 14 Replies View Related

Forms :: Remove Blank Row On Continuous Form

Feb 26, 2015

On a continuous form, I would like the user will add a new record via button click instead of popping open a blank record at all times. With AllowAdditions set to False on Form load, and turning it back on button click I can get a new record added. I am having trouble determining where to turn it back off. After Insert - doesn't seem to delete the blank row until I move to the blank row, so this doesn't accomplish what I am looking for.

AfterUpdate (for each field on continuous form) - this did what I wanted, but I was only able to update one field on the form for the new record. The combo boxes then were viewable, but I could not make a selection.

View 1 Replies View Related

Forms :: Remove Dots After Leaving The Field?

Sep 19, 2013

I have a database where I have a number from a client. We copy/paste it from a pdf file. The number has dots in it (1.00.00.000). I would like to create a solution that when I paste the number in the field and go to the next field, it will take out the dots from the number.

View 3 Replies View Related

Forms :: Remove List Item From Combo Box After Use

Sep 1, 2013

Is it possible to remove an list item from a combo box list after it has been used.

What I am trying to do is use a combo box that has a list of questions, after the user selects a question from the combo box list and answers the question when they reselect the combo box that question will not be seen again till the form is reloaded.

View 2 Replies View Related

Forms :: Remove Item After Being Selected From Combobox?

Mar 30, 2015

How can I remove an item after being selected from a combobox ?

View 2 Replies View Related

Forms :: Remove Multiple Selected Items From Listbox

Jul 24, 2013

How do I remove multiple selected items from listbox.

Noticed it is a table/query listbox, not value list.

Remove selected.zip

View 1 Replies View Related

Forms :: How To Remove Item From Listbox When Checkbox Is Unclicked

Apr 22, 2013

I'm using Access 2010 and have a form that is basically the last step in generating a report (which will be a printable invoice).

I am facing major problems when it comes to removing line items that the user may have accidentally clicked. I have a checkbox field embedded in the table (tblLineItems) which is set up as binary. I have created a form from tblLineItems, and have in turn embedded that as a subform on the invoice generating form.

When I select line items, I have them populating a two column listbox that shows the user what they have selected before actually opening the report. The code I am using is on the checkbox click event in the subform:

Code:
Private Sub InvoiceY_N Click()
Dim InvLineTotal As Currency
If InvoiceY_N.Value = True Then

[Code].....

View 13 Replies View Related

Forms :: Remove Filter And Stay At Current Record

Mar 9, 2015

I have a database For customers of the company, when you open the main form through the search form , there are a filter . when you try to move between orders of this customer, there are a mssage (Asking you to approve of movement between the customer orders). to this point no problem, when you approval to move , cancel the filter on the main form with a stay at the current record (current customer).

View 14 Replies View Related

Forms :: Deselect Or Remove Highlight From Item In Listbox

Jul 2, 2014

I am using Access 2010.

I have a form with three listbox. My issue is this, when I go from listbox to listbox the selected item in the previous listbox is still selected.

I would like it so when I go to the new listbox, then the previous listbox selection will no longer be highlighted.

I use the follow code, which works but the user has to double click on the listbox with the focus to make a selection.

Code:

Me.listbox.listindex = -1

I have the code in the lost focus event of the listboxes.

Is there a way to prevent the double clicking?

View 7 Replies View Related

Forms :: Cannot Remove Unknown Line When Creating Form

Jun 24, 2014

I have created a form and insert, delete some columns, controls in layout view. When all 's completed, i saw a dark vertical line on top right of the last colulmn but i could not delete it. I deleted column, set property but they all did not work. What i have to do now? Below is a screen capture from my situation.

View 5 Replies View Related

Forms :: Cannot Save Form - Remove Layouts With Empty Cells

Dec 8, 2013

I have added a delete button to my form but now I cannot save the form.

I get the error message:

"In order to save your changes you must remove any layouts that have empty cells in them and/or set the has module property for the form to no."

How do I locate empty cells.

View 1 Replies View Related

Forms :: Remove The DISTINCT From Query And The Detail Section In Form Is Empty?

Nov 13, 2014

i removed the DIsTINCT in my query to move some field to be updateable on the form. Once I did that my detail section of my form was empty ..why and how do I fix this problem.

View 1 Replies View Related

Forms :: Remove Spaces Between Words And Add Hyphen Copy Other Field Access

Mar 25, 2014

GOAL - I would like to have one text box where I enter a sentence

txtKeywords: Access Is For Smart People Smarter Than I

I would like to create a button when clicked moves txtKeywords into another textbox [txtKeywordscombined] field and removes the spaces between the words and adds hyphens

txtKeywordscombined: Access-Is-For-Smart-People-Smarter-Than-I

Would I use the 'Replace' command in even procedures to do this? Another way? Example?

View 1 Replies View Related

Forms :: Allow Horizontal And Vertical Scrollbars But Remove White Space (AC2007)

May 22, 2014

I have a form which I would like to enable scrollbars both horizontally and vertically (the main reason being, the application is designed for users with large / wide screens but may at some point be required on smaller screens)

Currently I have the scrollbars switched off and the form maximises but everything goes to pot if I resize the window. I'd like to add the scrollbars so if a user wants to resize the window to, say, half the screen, they can still scroll across to the 'hidden' parts of the form.

The problem with this is, if the form is maximised - or at least large enough to show the entire form - the area of the screen where the horizontal scrollbar resides is white (whereas the background colour of the form is a pale green) Which is quite unsightly.

I know I can remove the problem by removing the horizontal scrollbar and the navigation bar (which is already gone!) but then I can't scroll?

Is it possible to have a horizontal scrollbar but not have that white space at the bottom when the scrollbar is not required?

(Doesn't appear to be a problem with the vertical scrollbar?...)

View 8 Replies View Related







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