Search results

I see. Is it correct to add then a delete method?

thank you!

great, thanks!

I got it worked! The BackColor part was not right. Instead of setting the control backcolor, the formatcondition backcolor needs to be set. Private Sub Form_Load() Dim ctr As Control Dim frm As Form Dim fc As FormatCondition Set frm = Forms(tb) For Each ctr In frm.Controls Select Case...

Yes exactly. OnCurrent text13=ID. then i would like to have the control to be green. In other words highlight it.

I modified the code like this: Private Sub Form_Load() Dim ctr As Control Dim frm As Form Dim fc As FormatCondition Set frm = Forms(tb) For Each ctr In frm.Controls Select Case ctr.ControlType Case acTextBox Set fc = ctr.FormatConditions.Add(acExpression, acEqual, "[ID] = [Text13]")...

I see, thank you. I have modified the code, with a select case of ctr. controltype. This part is ok now, but i think i have a problem with the add method. So what i would like to achieve is that in my continuous form, the row where one of its control has focus, be highlighted and i would...

Hi, I have a continous form with multiple controls. I would like to have the conditional formating for these controls using VBA on onLoad event. Private Sub Form_Load() Dim ctr As Control Dim frm As Form Dim fc As FormatCondition Set frm = Forms(tb) For Each ctr In frm.Controls Set fc =...

sorry for not providing... https://answers.microsoft.com/en-us/office/forum/office_2007-access/highlight-row-in-continuous-form/a862821f-ebee-4ebc-93d9-e068debcab84

Thank you so much. I found this as well: "An alternative to highlighting only the control with the focus or using Conditional Formatting on every control is to add a text box with BackColor set to whatever BackColor you use on the other controls. Size this text box to cover the entire detail...

Thank you, but it changes all the fields on CF form.

Hi, I am trying to solve this: i would like to highlight the record/control having focus. I have seen several solutions but i wonder which one is the best for Office 365. thank you Andrew

no i do not use or want to use outlook. Only thunderbird.

Hi, I would like to ask if there is a way to create a vba code to download emails and save them to a table. Sending is no problem it is functioning. thank you

Hi, I have the following problem that emerged in my database. I have a table with alphanumeric id. I need to know the last one when i enter new data using an entry form. So on the entry form i have an unbound control with Dlookup/Dmax function. The function runs on a query based on the given...

sorry the control source is =fsubform.Form!control

I got it solved, but i am still wonder what causes this issue. So i turned around the "refering direction" meaning that i have changed the control source on the main form: =fsubform!control It works now perfectly. But what causes a vba code to run depending on the number of records visible...

thank for the inputs. Actually it is not a count but a sum, but i have tested with the count: same thing. It is clearly an issue with the number of shown records, making the subform smaller inducing the error. So the subform record source is a table but checked it with query too. Form footer...

Hi, i have a form with a subform in datasheet view. Subform footer has an unbound field to calculate total that is shown up in the parent form. Everything works fine as long the datasheet view is actually "shorter" than the subform height. If longer it does not and i need to click on the form...

The OnChange did the trick! As tab.value identified the pages this code did what i need: to show the command button in only certain situation: Private Sub TabCtl0_Click() If Me.TabCtl0.Value = 1 Then Me.Command3.Visible = False Else Me.Command3.Visible = True End If End...