Microsoft: Access Forms | Forum profile

You may consider a command button (in the header or footer section of the subform) dealing with the current record's values. Hope This Helps, PH. FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? FAQ181-2886: How can I maximize my chances of getting an answer?

You can set the Tag property to your "Search MSDN with Bing". Then add code to your Form Open and text box Got Focus like: CODE Private Sub Form_Open(Cancel As Integer) If IsNull(Me.txtDescription) Then Me.txtDescription = Me.txtDescription.Tag End If End Sub Private Sub txtDescription_GotFocus() If Me.txtDescription.Text = Me.txtDescription.Tag Then Me....

Well! I am ALMOST there! If I got a more specific problem I will seek for help...

How are you determining the week number? Perhaps if you share the code, we can help you better. Are you using the function DatePart? It has an optional parameter "firstweekofyear", which can be one of four values. I assume you are using the default value of vbFirstJan1 which gives the results you stated, weeks 53 and 1. Setting it to vbFirstFourDays will put both 12/31/2009 and 01/01/2010 in...

How are ya Goondu . . . Try: CODE With rs .FindFirst "CompanyID = '" & "Chubb" & "'" 'error Chubb-SP If Not . NoMatch Then Me.Bookmark = rs.Bookmark Else MsgBox "no match" End If End With See Ya! . . . . . . Be sure to see thread181-473997: How To Get Good Answers To Your Questions Worthy Reading! Also ...

You might want to try the Requery method rather than Refresh. Duane Hook'D on Access MS Access MVP

If this was a report, you would have more options. However, on a form, you can use a text box with these properties: Control Source: =String([YourNumericValue],"g") Fore Color: 255 Font Name: Webdings Special Effect: Flate Back Style: Transparent Locked: Yes Enabled: No You may need to adjust the font size and text box width to display the full line. Duane Hook'D on Access MS ...

You may try simply this: Me!Text67 = Environ("USERNAME") Hope This Helps, PH. FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? FAQ181-2886: How can I maximize my chances of getting an answer?

What is your expected result? You are treating Appr like a yes/no field and yet you are displaying values of 1 or -1 when they should be -1 or 0. What are you summing? Duane Hook'D on Access MS Access MVP

try Adding an alias to the assigned to name and use the alias

What do you want? A subform is by definition a control on a main form that generally has a form as its Source Object. "Pop-up" refers to a form that opens separate from any other form. I'm not sure how a subform can be pop-up or what you actually are asking. Duane Hook'D on Access MS Access MVP

Well! I am ALMOST there! If I got a more specific problem I will seek for help...

If it is necessary to requery the RowSource of a ComboBox, then do it in the OnEnter or GotFocus event of the control. (RG for short) aka Allan Bunch MS Access MVP acXP ac07 winXP Pro Please respond to this forum so all may benefit

You may try simply this: Me!Text67 = Environ("USERNAME") Hope This Helps, PH. FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? FAQ181-2886: How can I maximize my chances of getting an answer?

You can only save design changes in design view. If you have some properties you would like to change, you can store them in a table and then when the form opens, retrieve and set the property values. Duane Hook'D on Access MS Access MVP

How are ya qitcryn . . . What have you tried? ... What to do is spelled out in the thread! See Ya! . . . . . . Be sure to see thread181-473997: How To Get Good Answers To Your Questions Worthy Reading! Also FAQ181-2886: How can I maximize my chances of getting an answer? Worthy Reading!

You need to move the where clause: CODE SELECT DISTINCT CONTRACT_TERM.AY_related_to_year_term FROM CONTRACT_TERM WHERE CONTRACT_TERM.AY_related_to_year_term NOT IN ('Pending', 'N/A') UNION SELECT "All" FROM CONTRACT_TERM ORDER BY CONTRACT_TERM.AY_related_to_year_term DESC Duane Hook'D on Access MS Access MVP

cstuart79, Do you have a value stored in the row/record that identifies if it should be formatted? What is the reason for the highlight? Is it like just a temporary pointer to a record? Does the row have a primary key field? Duane Hook'D on Access MS Access MVP

Please provide all significant information with your questions. We don't know: -your list box row source -field in form's record source to filter on -data type of field to filter on -form name -list box name Duane Hook'D on Access MS Access MVP

The reports won't open, instead they print Replace all acViewNormal with acViewPreview Hope This Helps, PH. FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? FAQ181-2886: How can I maximize my chances of getting an answer?