Modules & VBA :: Change Formatting Of Unbound Text Field On Continuous Form

Apr 16, 2015

I have a continuous form with a text field that says "Select". There are two other fields, one of which is Brand. When the Brand Combo box has nothing in it I want the text box to appear (instructing the user to select a Brand) But once the user selects a Brand and goes to the next records, I would like the "Select" in only that record to become not visible. I tried conditional formatting but can't apply that to an unbound control ( or at least it is grayed out when I select the text box) and any other possible solutions I have found changes all of the selects - not only the one in the changed record.

View Replies


ADVERTISEMENT

Unbound Text Field In Continuous Form: Update One Record, They All Get The Same Value

Feb 20, 2006

Hi,

I want to show some text from another table based on the values of the bound fields in each record of a continuous form. I thought it would be easy, but I can't get it to work.

I step through the records in the bound recordset and use some of the values to query another table. Then I use the value from the query to populate the unbound text field.

It works fine for each record. But every time the unbound field is updated, all the records in the continuous form are updated.

I'm stuck on this one. It's probably something simple to fix - if you know what to do!

Do you have any suggestions?

Thanks!
-Daniel

View 10 Replies View Related

Forms :: Sum Unbound Field In Continuous Form?

Dec 17, 2014

I have a continuous form with a number of unbound fields and bound fields. However, I would like to sum an unbound fields (Text28). Text28 is an unbound calculated field based on another calculated unbound field (Text22). I would like to sum Text28 in the footer or somewhere in the form.

Here are the codes for my field:

Code:
Text28 = iff([Text22>0], [Text22], [Text20] --- This works
Text29 =sum(iff([Text22>0], [Text22], [Text20]) --- this is not working

and it did not work.

View 3 Replies View Related

General :: Conditional Formatting - Change Backcolor Of Process If Status Field Contains Certain Text

Jan 8, 2014

I have a subform with two fields [status] and [process], i am trying to get the backcolor of procces to change to red if the status field contains the text "expired".

I have tried vba. plced on the after update

if me.status = "expired" then
me.process.backcolor = vbred
else me.process backcolor = vbwhite
end if
this

Changes the color of the field [process] but also all process field colors to red even if the status field does not contain "expired".

I think conditional formatting is the way to go but i think i need an expression to complete this.

View 7 Replies View Related

Modules & VBA :: Change Multiple Records On Continuous Form

Mar 5, 2014

I have a form (Form4) which has a a list box (list11) that allows multi select. When I select on the records I need I hit a button that opens a form up with the selected records. This form is a continuous form. I have an unbound combo box (Combo55). Its values come from a specific table. I want to hit a button and change the field "Assigned" on all the records showing to the value that I selected in Combo55.

The problem is it only changes the value of the currently selected record. How Do I get it to change the value of all records that are showing?

I am only testing this idea with default field names. Before I implement the database I have to get a working model and present it. So I am building this and naming at the moment isnt important.

View 4 Replies View Related

Forms :: Continuous Form - One Field Change Background Color / Current Record

Jul 28, 2014

in a continuous form i want to click on one record and have the one field change the background colour to highlight it. When I use the code: Field. BackColor = vbYellow it changes the background on all the records. Is there a code to say only for the record with focus?

View 1 Replies View Related

Get Value From Unbound Text Field From FORM And Store Value In Bound Field

Nov 5, 2012

I've created a data entry form w/ 7 fields.... [f1], [f2], [f3], [f4], [f5], [f6] are bound to a table. While [f7] is unbound and has Nz function.

Now, the value of [f7] is the summation of [f1] to [f5], i want that what ever value is generated by [f7] will be stored on [f6] in both forms and table...

View 1 Replies View Related

Modules & VBA :: Import Excel File Into Access And Append A Date To A Field From Unbound Text Box

Aug 22, 2014

I have a form which i use for a user to select an excel file they want to import and then click a cmd button to import the file into a table which works fine, however i want to append a date into a date field from an unbound txtbx before the file is imported so it will look something like;

id;date;excel info;excel info;excel info.

View 7 Replies View Related

Forms :: Change Text Color On A Form If Text In Field Contain Certain Word

Jul 12, 2013

I have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in display form?..

View 3 Replies View Related

First Record In Table To Appear In Unbound Text Field On Form?

Feb 20, 2006

Hi All,

I hope someone can help me.

I have a table here tblTemp with a field client. This table can have from 1 to 100 records at times as it keeps getting cleared for the purpose of this exercise.

I also have a form frmLabel1Data with an unbound text box txtclient.

I was hoping to get the first record of the table into this text box upon opening the form.

I tried creating a query which gave me the following sql;

SELECT First(tblTemp.client) AS FirstOfclient FROM tblTemp;


I also tried placing it in this code with no luck

Private Sub Form_Open(Cancel As Integer)

Dim SQL

SQL = "SELECT First(tblTemp.client) AS FirstOfclient FROM tblTemp;"
MsgBox SQL

End Sub

Does anyone know why I cannot see the same result as when I open the query it gives me my client name but the code above does not????

Any help is appreciated.

Robert88

View 2 Replies View Related

Change Memo Unbound Text Box When Combo Box Changes

Dec 8, 2013

I have

an unbound combo box
an unbound text box (made to resemble a memo field)

a continuous form with many schooltype

The form is filtered by schooltype when the unbound combo box is changed i.e. high school, primary etc

I have made a field in the tblSchoolType called emMessage1 (there is 2, 3 etc)

The idea is that you choose to filter the form and then the relevant type emMessage1 appears in the text box

So if you choose high school then the high school emmessage1 appears (filled with the text) because all the high schools are tied to tblschooltype - when you select high you are getting the high emmessage1

When I select all records I am guessing that the text box will be invisible until you select a school type in the combo box (to avoid problems)...

When you have selected a type, the text gets swapped accordingly to the corresponding id of school type id thus changing emMessage1 to suit and make the textbox visible...

Now I can type in the field and it saves it in the table however:

I do not know how to do this. I thought about dlookup but not sure if that will allow me to change or whether it will do this...

View 7 Replies View Related

Modules & VBA :: Click Event To Open A Form And Select Record Corresponding To Value In Unbound Text Box

Oct 29, 2013

I have some code for a button on click event to open a form and select the record which corresponds to a value in an unbound text box. The code is:

Private Sub Command25_Click()
On Error GoTo Err_Command25_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmOpenPatientRecord"

[Code] ....

This works fine when I put in a 10 digit NHS number but opens a blank record when I enter a four digit or six character/digit PatientNumber. Both patient number and NHS number are text fields in the underlying table.

View 14 Replies View Related

Modules & VBA :: Change Color Of Substring In Rich Text Field

Aug 14, 2013

I'm using Access 2010. I'm passing a string into the OpenArgs of my report - works fine. In the report there are 3 rich text fields which may contain the text I passed in, and if so I want to change the color of that text to red so it stands out.

The value passed to the report changes so I'll need to use VBA in the detail's format section to check each of the 3 rich text fields.

View 5 Replies View Related

Continuous Form View - Formatting

Jul 14, 2005

I want to display more records vertically than 1 column in my continuous form. Is this possible in some way?

I want to have like 2-3 columns with 5-6 records each.

View 4 Replies View Related

Continuous Form With Unbound Check Box?

Jul 7, 2005

hi guys, i have a continuous form with a check box and a button on each record's row.

now if i dont bind the check box to a control source when you tick it, it gets ticked for each record, i am using the tick box to pass a state to the button ( uses an if statement ) so that it will done different things if it is ticked when the button is pressed.

can anyone help me to get this to work without having to bind the check box to a control source?

best regards

View 3 Replies View Related

Forms :: Change Combo Box To Text Box - Show Unbound Column Value

May 28, 2013

How to change a combo box to a text box control in a subform for a field that is based on a two-column value list. I want to be able show the value in the unbound column (which is a text value instead of a number).

My subform has a field called "ProjectStatus". This field is a value list in my projects table with the following row source:

1;"Built";2;"Unbuilt";3;"Active";4;"On Hold";5;"Completed (Master Plan)";0

So, it is set as a two-column value list with a number data type for the bound column. In my forms, column 1 is made invisible (set to 0") so that only the text value is shown to the user. This works fine with combo boxes.

However, I want to change the unsightly combo box to a text box and show the text value of the unbound column (this form will only be used to show data not for entry). When I change it to a text box control, the value that appears is a number, of course.

If ProjectStatus were based on a table, rather than a lookup value list, I would query it but I am not sure how it should be done with a value list. I could just store the text value instead, I guess, and redo a bunch of stuff or I could create a "Status" table and redo a bunch of stuff (this seems like my lot in life lately) but I feel like there should be some way to do this.

View 6 Replies View Related

Forms :: How To Populate Bound Text Field With Text From A Unbound Text Field

Mar 22, 2014

I have 4 fields that are unbound on a form. img1 img2 img3 img4..When these are entered they are all combined and autofill another unbound textbox = imagename.. what i would like to do is from this unbound textbox 'imagename' ..i would like to populate a textbox that IS bound called FileName

[Event Procedure]
Private Sub imagename_Click()
Me.imagename = Me.FileName
End Sub

View 4 Replies View Related

Modules & VBA :: How To Increment Field On A Continuous Form

Mar 31, 2014

I have a form that is being used for sample submission. Ideally, the user will be able to put in some information (3 or 4 fields) and the number of samples that they're taking, click the arrow and it will insert that number of samples into a temporary table that is then displayed on a continuous form. From there, they can edit samples, add more samples, and generate a report to submit to the genotyping group. Once their sample list is final, I will append it to the master list and clear the temporary table.

I've got the basics working. A looped "INSERT INTO" using a counter inserts the relevant information. I cannot, however, seem to get the numbering field to work.

Ultimately, the numbers need to look something like MySample-001, where MySample would be one of the other fields. Incrementing the 001 is the problem. In another situation in the database, I can successfully use DMax+1 to assign a single number on a single form, but I can't get it to increment the sample numbers.

Ideally, I'd like it to happen when the form is generated. However, I'm also open to having them assigned when the sample list is finalized, before inserting into master table.

View 8 Replies View Related

Conditional Formatting Of One Button On Continuous Form

Jul 17, 2005

Hello there,

I was wondering if any of you experts out there know a way to help me out here.
I was wondering if it is possible to color the text on the last pressed button on a continuous form different from all the others, so people will know which one they pressed last?
I've been trying a lot of different things here but i'm stuck. All i can get done is that all the buttons turn a different color, but doesn't solve anything.

I hope some of u can help me out here.

Greetz,
And thanx in advance,
Rutger

View 7 Replies View Related

Continuous Form - Conditional Formatting On Option Box

Apr 24, 2015

I have a continuous form. On which I have a frame and three option boxes with values 1, 2 and 3 what I am trying to do if one record is selected in option box other text boxes of the same record turn red I am using this code which works perfectly expect that it's doing for all records. I want that particular record to turn red.

Code:
Private Sub Form_current()
FormatGroup
End Sub
'
Private Sub Frame53_Click()
FormatGroup

[Code] .....

View 1 Replies View Related

Populate Unbound Fields On A Continuous Form

Oct 5, 2004

Can I populate unbound fields on a continious form, if it is possible would you give me some code to look at or direct me to an article

Phil

View 2 Replies View Related

Forms :: How To Populate Unbound Continuous Form

Dec 19, 2014

I found a few regarding continuous form data but its not the sample that fits.

Attached here is my screen shot and my accdb file (MSAccess 2013)

How do they populate unbound continuous form from msaccess connecting to mysql server.

It should display 5 data but in my case it does show only one data.

View 8 Replies View Related

Reports :: Change Text Formatting Of Control In Report Based On Boolean

Jul 10, 2015

I would like to change the text formatting (color, italics, bold etc) of the contents of a control based on a boolean value in the underlying datasource of the report.

For instance, I have a report that generates a "Proforma Invoice" i would like to ability italicize the prices of certain items based based on a boolean value (EstimatedPrice) in the underlying datasource.

View 2 Replies View Related

Forms :: Conditional Formatting Of Control On Continuous Form

Feb 2, 2015

I have a continuous form on which where each record has many controls, including control (A). I wish to set the colour of this control based on the contents of another control (B). Control B is a memo format and is placed behind another control making it hidden. The idea being that the user can then click on control(A) and look at supporting information from Control B on another form.

Conditional formatting cannot be used since this only allows conditions based on the control (A), not (B). Event procedures cannot be used since they all depend on making a record the current record, and I want the user to immediately see when further information is available. When I apply VBA code using an 'on load' event it is action for all records on the form in a way that if only one record has extra information, all records are flagged in this way.

View 6 Replies View Related

Forms :: No Focus For Unbound TextBox In Continuous Form

Oct 27, 2014

I have unbound TextBox in continuous form and I would like that it never get focus. In property I specified Enabled=No and Locked=Yes. But it doesn't work.

View 8 Replies View Related

Forms :: Unbound Listbox - Change Text Color To Differentiate Between Current And Past

Apr 24, 2014

I have an unbound listbox on a form which displays a list of staff, both past and present, based on an SQL query.

I want to be able to differentiate between current and past staff using different colors, i.e. Black text for current employees and red for employees who have left, based on a field (True/False) in the original staff table.

View 4 Replies View Related







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