Access :: Grey-out Txtbox

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

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

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 5 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

Select Between (Date) AND In TxtBox

Jul 4, 2005

Hello,

I'm trying to make a report query work but with no succes so far. Can anyone please help me?
I've got a multiselect listbox and a txtbox (txtCursisten) where the results from the multiselect listbox appear.
I want to get the results out of a table (tblAbsentie) where I can set a start and end date AND use the people selected in the txtBox. So far I've got a NOT working query, a report based on the query and a button on my form.

The VB code behind the "show report" button is this:

Private Sub cmdAbsentiePerCursistPerPeriode_Click()

On Error GoTo Err_cmdAbsentiePerCursistPerPeriode_Click

Dim db As Database
Dim Q As QueryDef
Dim sql As String

If IsNull("Me.txtCursisten") Or Me.txtCursisten = "" Then
Exit Sub
Else

Set db = currentdb()
Set Q = db.QueryDefs("qryAbsentiePerCursistPerPeriode")
Q.sql = "SELECT tblCursist.Naam, tblAbsentie.Datum, tblAbsentie.Lesuur, tblAbsentie.AantalLesuren, tblAbsentie.Deelkwalificatie, tblAbsentie.Docent, tblAbsentie.Gemotiveerd, tblAbsentie.Reden, tblAbsentie.Status, qryCountLesuren.SumOfAantalLesuren" & _
"FROM (tblCursist INNER JOIN qryCountLesuren ON tblCursist.OVnr=qryCountLesuren.OVnr) INNER JOIN tblAbsentie ON tblCursist.OVnr=tblAbsentie.OVnr" & _
"WHERE (((tblAbsentie.Datum) Between [Voer begindatum in] And [Voer einddatum in]) AND ((tblAbsentie.OVnr) In ("Me!txtCursisten"))); "
Q.Close

DoCmd.OpenReport "rptAbsentiePerCursistPerPeriode", acPreview
End If

On Error GoTo 0
Exit Sub

Exit_cmdAbsentiePerCursistPerPeriode_Click:
Exit Sub

Err_cmdAbsentiePerCursistPerPeriode_Click:
MsgBox "Selecteer klas en cursist(en)."
Resume Exit_cmdAbsentiePerCursistPerPeriode_Click

End Sub

I get a syntax error when pressing the button. Please help...
SeBasTiaan

View 3 Replies View Related

Insert The Value From A Txtbox Into A Table

Sep 15, 2005

Hi there

Can someone give me a basic example.

I have a form that contains a textbox and a listbox. The listboxs rowsource is tblSPNZ.
The table has 2 fields 1 is and autonumber and the other is where I want the results to go.

How do I make a command button populate the table? Avoiding putting any results into the autonumber field?

Thank you for your help.

View 11 Replies View Related

Txtbox Ctrlsource = Query Question

Dec 14, 2006

I have a form, on the form a textbox. Through the expression builder I have assigned one value to the control source of that textbox from a query. The query holds three values, all three of which I would like to use in a separate textbox. When I open the form the textbox just displays #Name. I'm guessing since nothing is happening because the query isn't run by command yet. I've used code like this:

Private Sub AppointmentID_Click()
Forms![ClientsMain]![TechViewSummarySubForm].Form.Requery
Forms![ClientsMain]![TechViewSummarySubForm].Form.Refresh
End Sub

to get a query to open, run etc. But that one is located in a subform which has the query as a control source. How does that work in the case I have now? Can I use the DoCmd function to run the query and get a value from it for the specific textbox? Or can't I use a (segment of a) query as the controlsource of a textbox at all?

I'm asking this since now I calculate and store certain totals by use of a textbox with =Sum() as control source in the footer of a form, which values I then assign to some fields in a table.

But I would also like to learn the right way, using queries, maybe for a later version of my DB when my skills have improved. I've been struggling with this now for a bit, but without succes. So that's why I wonder if I can assign a query or more specific one value of a couple of values in a query to a textbox in a form which has a totally different control source itself.

View 3 Replies View Related

Date Criteria From A Form's Txtbox

Aug 20, 2007

Hi all,
I have a select query that pulls in two date values from a textbox on a form.

SELECT DISTINCT Table01.SRV_NAME, Table01.IMP_CUTOFF_DT
FROM Table02 INNER JOIN Table01 ON Table02.Servicer = Table01.SRV_NAME
WHERE (((Table01.IMP_CUTOFF_DT)=[forms]![frmreport].[txtsqldate].[value]))
ORDER BY Table01.SRV_NAME;

However when I run it I get the following error message:"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may...." but when I copy and paste the value of that txbox from the form into the query it works fine.

Can anyone see where the problem lies? I can't work it out.

Thanks in advance,
Mitch....

View 5 Replies View Related

Validation Rule For Length Of TxtBox

Jun 27, 2005

Here's a bit of a pickle I've been trying to wrap my noodle around.

Anyone have an idea what route to pursue (unbound form, or afterupdate, etc?) to force a validation rule on the number of characters in a text box based on the value of combobox in the same form.

Example:
If cboBox1 = 840, then len(txtBox2) = 6
But if cboBox1 = 820, then len(txtBox2) = 3
And so forth?

Thanks,
~Chad

View 5 Replies View Related

Replace Data From Txtbox To Subform

Oct 3, 2006

friends, a small question.

I have placed a txtbox on my form and via a cmdbutton a can copy data to another text box. Is there a way I can replace data? Will appreciate any help.

View 4 Replies View Related

Update TxtBox With Combobox Description And Not ID?

Jun 7, 2014

I have a form that has a combobox and a field text. If i select any value in combobox i want to update the txtBox but not with the ID of the selection. I need to get the description of the combobox selection which is essentially the Column 2.

View 3 Replies View Related

Counting Columns And Storing Result In TxtBox

May 18, 2007

Hello,

In a form I have "txtBoxA". I would like store the number of records from table "A" based on a specific field into "txtBoxA".

Ex:
Table 'A' fields: QuoteID, Date, GenerateOrder

What would be the exact syntax for this??
The following code is not working

Me.txtBoxA.Value = DoCmd.RunSQL ("SELECT COUNT(GenerateOrder) FROM A")

Thanks

View 2 Replies View Related

How To Make Form Txtbox = Multilpe Fields?

Jun 17, 2005

Having had a pretty good look around, I think I must have missed something...

I just want to try and make a Forms single Address textbox = multiple table fields values:

Add1
Add2
Add3
PostCode

Cheers,

Pailin

View 2 Replies View Related

Populate A Bound TxtBox And Not Have It Update Table?

Mar 12, 2008

It's an unusual request, I know, but it's necessary for my purpose.

I have a form, frmMain that I use to update a number of tables. On it is a number of combo boxs, comProduct, comBrand, comSize, comPrice and comQuantity. comProduct opens a new form, frmNew if the users input is not already in the table. On frmNew there are again combo boxes comProduct, comBrand and comSize. This form adds the record to the table.

So, if I input a new value - not already in the database - for product in the comProduct combo box, the form frmNew appears and I can proceed to define the product, brand and size of the new record. The form then closes and reopens frmMain and tabs across to comQuantity (skipping the fields I've already defined in frmNew).

Now if you can wrap your head around that, here is the problem: Because I've already entered the values for product, brand and size in frmNew, I want them to automatically appear in the appropriate combo boxs on the frmMain form. I've been using the following code (executed from frmNew, so Me = frmNew):

Code:[Forms]![frmMain].[comProduct] = Me.comProduct[Forms]![frmMain].[comSize] = Me.comSize[Forms]![frmMain].[comBrand] = Me.comBrand

It works, but I've since discovered it creates a new record in the table so I end up with two duplicate records (one when I submit frmNew and another when the values are automatically input into frmMain.)

Now, my question: How can I display these values in frmMain without having them create the second record? I was thinking of using a SELECT query somehow, but I don't know where to begin. I also considered using labels instead of comb boxes, but I'll need to be able to edit them if the record already exists.

View 3 Replies View Related

Queries :: Criteria Using DLookup String From Another Txtbox?

Aug 19, 2015

I have a table tblDateGroups, with two field, [Group] (like This Week, Next Week, Last Month, etc) and [Code] that holds the code for criteria for each group in a query. I know the code is fine (like next week = Between Date()-Weekday(Date())+8 and Date()-Weekday(Date())+14 ) because I tested before putting in the table.

On my form I have a combo box that list all the [Group] and i hidden textbox that looks up the code based on the cbx after update...all that is good.

However, when i try to requery the report the criteria is not working. I am simply using the date criteria to read the hidden text box with the code string.

Forms!frmMainHome!subaWelcome.Form!txtCodeForQuery .

the error code is "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

View 2 Replies View Related

Changing A TxtBox To A Check Box Or Similar, Based On A Field In Db

Feb 22, 2006

Hi.

I have

Form with 3 list boxes.
1st LB populates 2nd etc.

The 3rd LB value chooses a field.
The Fieldname Table has field "Field Type"

I want to change the Text box next to the List box to this entry in the Db.

Ie. If I choose a field in the LB, say "Done?", then to update that field it needs to offer me a "yes/no" field type
Therefore it changes the TextBox to a Checkbox (or combo with Yes and No as options)

Any ideas?

View 2 Replies View Related

Using Expressions To Display Value In Txtbox Based On Combo Selection

Aug 2, 2007

hi Guys

I would like to write an expression (i presume) to auto fill a text box based on the selection made from a combobox...can anyone help or point me to a tutorial that deals with this??

Many Thanks,

RF

View 10 Replies View Related

"#Error" Shows Up On Txtbox Instead Of "nothing"

Aug 17, 2006

Hello friends :D

Can anyone direct me no how to get rid of the text "#Error" showing up on my form field when there's no value. This is the txtbox on my main form and it's looking up its value from another txtbox on my subform.

The main form textbox produces #error when there is no record on the txtbox on the subform. It's controlsource is: =subfrmWorkDone.Form!txtGrandTotalTime

The controlsource on the subform txtbox (where the value is wants to be gotten from is): =(Format(Sum([Timestop]-[timestart]),"h") & " Hours" & " " & Format(Sum([Timestop]-[timestart]),"n") & " Mins") and it works perfectly and simply doesn't show anything when there is no value.

How can i get rid of this #Error. It's not really an error cos it produces the value from the subfrm correctly when there's a value on the sufrm txt, when there's no value, i get the #error on the mainform (but a blank shows on the subfrm, which is what i want).

The #error will confuse any user to think my form has a problem when it really does not.

I have tried wrapping it in a ISNULL IIf and this =IIf(subfrmWorkDone.Form!txtGrandTotalTime=Null," ",subfrmWorkDone.Form!txtGrandTotalTime) but no luck. Any more ideas?

View 6 Replies View Related