Search results

All, I'm trying to conditionally format a field on my report based on the time portion of a date/time field. See below for my syntax. For some reason, the formatting is applying across the board regardless of whether the value in the field meets the conditions below. Any ideas? What am I...

Thank you again, but I'm afraid this isn't working. The report is applying the conditional formatting to the field no matter what time appears (for example, 7:00am or 12:30pm). Any other ideas?:banghead:

Thank you kindly, but this did not work. The field is a date/time field and I have it set to Medium Time (ie: 6:00 AM or 12:30 PM). I need the field to recognize the time is before 6AM or after 6PM. My users are not likely to remember to enter times in 24 hour format so we need the AM/PM...

Another conundrum... I have a control on my report that I'd like to turn red if the value is before 6:00 AM or after 6:00PM. I have tried several approaches to this but it isn't giving me what I need. Any tips? Thanks! :):D

This is a new one to me, hopefully some brilliant person here can help me solve it. I have a query that pulls records from two tables and a related query based on user entered criteria. The results will pull just fine into a query view (datasheet). However, when I try to view these same...

As an update, I tried putting a text box named "txtStatusMessage" bound to the "Status" field in the query results on my main form and basing the msg box on the value of this field; it still did not work. Any other ideas?

I updated the code to me.combo14. still nothing.

Hi, This combo box is connected to a table so that folks can choose from a dropdown. The query behind my subform pulls all associated records from a table and displays them. When they add new records to this table, they use Combo14 to choose the status for the new record. Is this what's...

My apologies, I appreciate your assistance :) The field is a combo box, bound to the field "Status" in my table. It is called "combo14."

Hi, [Status] is a bound field on a subform which displays query results. There could be many records in the query results, showing the progression of a particular item through several status steps. I want the box to pop up if one of those steps matches any of the four criteria specified in...

All, Thank you for your quick replies. I tried both suggestions and I'm afraid that now the message box does not pop up at all, regardless of the value in the [Status] field. :( Thoughts?

Here's my challenge! I have the following code behind the On_Load event of my subform: Private Sub Form_Load() If Me.Status = "74" Or "33" Or "8" Or "7" Then MsgBox "This Case Has Been Closed!", vbOKOnly, "Case Closed Alert" End If End Sub The problem is, my message box is...

Thank you kindly, but I'm afraid that doesn't work. I'm still getting the parameter request: forms!frmInquiryMain!cmboType (this is my original form name, the one I copied to make frmInquiryFraud).

I hope someone can help me solve this mystery. I have the below code behind a form so that a combo box will display a specific list of items based on the data in another combo box on my form. I have two copies of this same form for two different departments. One of the forms works like a...

Hi TJ, Can you give me an idea as to what that would look like? I already have an Inner Join between two different tables, as you can see. Can I possibly add another outer join? I really don't know what that would look like. I apologize in advance for my lack of VBA skill! :mad:

Greetings and here's hoping you can help with my conundrum. I have two tables, tblCandidate and tblNewHire. I am trying to transfer candidates to tblNewHire based on the date they are hired. However, I would like the database to skip any records that are already in tblNewHire, just in case...

Update! I was able to use Conditional Formatting to achieve my aims. However if anyone knows of a way to do this using VBA I would love to have an answer for any future projects that may require more criteria than CF will accommodate. Thanks! ;)

Hello! I am attempting to adjust the font color of a date field on a report based on the value of two other fields. I have the below code set in the "On Format" property of my detail section - however it does not work when I open the report to view. Any thoughts on what I'm doing wrong? Your...

Thanks for your replies, however I am a total beginner with VBA and don't know how to interepret your instructions at all. Can we spoon-feed this in some way so that I can be sure to get it right?

Ok, so. I have a user form with six different dropdown boxes. I would like to create a query that gets its criteria from users selecting values from one or more of these boxes. I have tried: [forms]![frmName]![comboboxname] or [forms]![formName]![comboboxname] is null in the corresponding...