Search results

Is there a simple way of creating F1 help messages for individual fields? I don't want to use the status bar ... easily overlooked. I searched (F1, field, help) without luck

PBaldy ... thanks ... that did it

The following If Then statement doesn't work. Am I using the And's and Or's correctly? If (Me.CurrentSGLIAmt <> "400,000" Or Me.RSN_Increase_Amt <> "9") And Me.UBLCombo = "Married" Then Me.SpouseLetter = -1 Else Me.SpouseLetter = 0 End If

I'm still having problems, so I took a different approach. I have a text on the form called LabelCancel. I want the label to appear when a condition exits (placed in OnCurrent property of the form). I have no problems if I reference a field from the form, such as this If...

I have a syntax error. I believe it's how I'm referencing the subforms =IIF(Forms!frmTrackerPCS!frmMissingItems_Subform!MissingID = "41" And Forms!frmTrackerPCS!frmMissingItems_Subform!DateClosed = Is Null, “Cancel”,”Open”)

I'm trying to write an IIF but I'm having trouble because of the nested form and the one to many query I'm using (see attached graphic). I have a form (frmTrackerPCS) with a subform (frmMissingItems_Subform) On my main form (frmTrackerPCS) I want to show a label if MissingID (41) from...

I have a pdf file which I want to print (Event Procedure on button). I'm having trouble finding how to print the file. Any suggestions would be helpful

I have a form. I want to disable various fields on different pages (tabs) on the form. I can disable a field on the page I'm working on, such as ... RetirementDate.Enabled = False How do I disable a field on a different page (same form)?

Got it now, thanks. First I changed the properties of the field from Plain Text to Rich Text, then add <b> to start bold and </b> to end bold (<i> and </i> for italics), such as, "="According to DOD 52.1-R, <i>Information Security Program</i>"

I have Access 2013. Can you give me an example of rich text in a text box?

In my database I have several letters (reports). In the reports, I need certain words in a text box to be bolded and other words italicized. For example I need only "Information Program" to be bolded ="According to DOD 52.1-R, Information Program" I've tried <b> and /<b> before and after...

In each record I have two date fields (retirementdate and separationdate). In the record one of the date fields will have a date. The other field will be left blank. I want to combine the two date fields into one field (combineddate) then sort the data (ascending). I created a new field...

Thanks ... that's a clever solution

I have a table (CSR) that lists all our customer service reps to include the name, position, (Y/N), etc. I can add new reps but don't delete them when they leave because I need to keep CS info in another form; instead, I mark the rep as Inactive (Y) when they depart. I have another form...

I have a report, which is actually a letter. I want to italize the name of the publication but cannot figure out how to do it. I tried </ text /> (no luck). I tried <i> text <i> (no luck). Can I create italics? ="1. Reference Inter-Service publication AFI 36-3026," & "Identification Cards...

It's a customer database. I have an appointment time field. I use a combo box (value list): N/A";"7:00 AM";"7:15 AM";"7:30 AM";"7:45 AM";"8:00 AM";"8:15 AM";" etc. I have another field that captures the time a customer signs in. In a query I compute which customer is served first. This...

I have a field called AppointmentTime. The drop down field has several options: N/A, 07:00 am, 07:15 am, etc. The field defaults to "N/A" since most customers don't have an appointment. I don't want the field blank (null). I'm trying to write VBA to execute After Update in the field. If...

Thanks for the help.

I have a button with code. I want to close the record if there isn't any data. If there is data I want to delete the record. Is there a more efficient way than what I have below? I don't like the first If statement. On Error GoTo Error_Handler If IsNull([Grade]) And IsNull([FName])...

When opening an Access db a pop-up window appears. EMET 5.1. EMET detected DEP mitigation and will close the application MSACESS.EXE What does this mean?