Search results

Do you mean testing to see if it's a hyperink and then formatting as a hyperlink if true? I thought about that, but it think it would hyperlink the whole control when I only want part of the text hyperlinked. I have a workaround that works but is far from optimal. I broke that field up into...

Hello, I am generating a report that needs to have a hyperlink in part of one of the fields. Prior to saving the field to the database I do a bit of VBA coding on it and add some HTML. The result is this in the field: "There are two ways to book with your preferred rate: <br> 1. <b><a...

That sound you hear is me kicking myself in the a$$. It's amazing how you get one solution stuck in your head and you refuse to see the simple answer staring you in the face. Thanks! That was a much easier way to do it.

Really struggling with something that I thought would be straightforward. It may just be the way I'm going about implementing. I have a report where my customer wants to be able to input a value and then be able to select whether the report shows values above or below that value. I have a...

Thanks for the reply. I actually solved this by creating a temporary table that violates all rules of data normalization, populating it with a function that cycles thru all the tables I need and then exports it to Excel. It works, but I think I like your solution better. It seems cleaner. I...

I hope this is in the right forum. I have built a app for a client (big hotel chain). This app is a type of project management app that helps them manage the start-up process for hotels. There are 6 major startup phases and each phase has a number of milestones and each milestone has a...

AH. Looked right past that. That worked! Here's the way I had to code it to not get a syntaxt error: TotalAtRisk = DCount("InnCode", "tblHotel_ActionItems", "InnCode = '" & InnCode & "' AND ActionItemDueDate < " & " #" & Date & "#") Thanks!

Thanks. Didn't see anything in the link that helped me. TodaysDate is not used anywhere else that I know of. It evaluates fine in the bottom part, just not in DCount. DCount sees every date as being greater than TodaysDate. I could create the count by looping the records but it seems...

Hello, I'm having an issue with the DCount function. I want to get a count of action items that are beyond are past their due date Here's my code: Dim rstActionItems As DAO.Recordset Dim rstRoadmapStatus As DAO.Recordset Dim SelectActionItems As String Dim HotelStatus As Integer Dim...