Search results

OK, I think I figured it out. I set the control source of the text boxes to: =IIf(DLookUp("EventDate","qsfrmEvents","[EventName] = 'Name of corresponding Event for textbox'")>0,True,False) Which returns True if the date has been entered. I then used conditional formatting to set the...

I just realized I said status bar earlier, I meant progress bar. So for instance, once the "Date Assigned to Rep" date is filled in in the subform, the first textbox, which is the first segment in the progress bar, should have its background color change. Then once the "Date Estimate...

Dmax would return the latest date, correct? How do I get which status goes with the date?

Sure, my post was a bit vague, sorry. This database will be used to track dates of events that occur in the course of processing a claim; such as, Loss Date, Report Date, Estimate Date, Payment Date, etc. The main form has information such as Claim Number, Rep Name, Location. The subform has...

I have a main form with a continuous sub-form. On the main form I have a series of text boxes that I want to use as a makeshift status bar. The text boxes would be filled in if a value was entered into certain records on my sub-form. The problem I have is since the sub-form is continuous...

Reviving this thread because I've noticed the above solution doesn't work if the combobox is Null. How can I handle that? The filter I currently have is below: Me.Filter = "[ClaimNum] = '*" & Me.txtSearchClaim & "*' Or [ReviewerName] = " & Me.cboSearchReviewer Thanks

OK, I think I got it. I created the queries like in your example, plog, and saved them, then used them as a source for a query to tie them together. SELECT tblClaim.ClaimNum, sqryPaymentDate.fkClaimID, sqryReportDate.ReportDate, sqryPaymentDate.PaymentDate...

I have used DateDiff before to get the difference in two differentdate fields, but in this case all the dates are in the same field. That's where I'm stuck, in how to refer to both dates in the same field/Column.

I’m developing a claim tracking database that tracks dates of events that occur in the course of processing a claim; such as, Loss Date, Report Date, Estimate Date, Payment Date, etc. I currently have the following tables set up: tblClaim ClaimID ClaimNumber tblEvents EventID EventName...

Hello again, I have another question related to this one. One of the primary goals of this database will be to track time between events. With the tables listed above, where each date is stored in the same field, it seems like it would be more difficult to calculate the dates between events...

Ahh, that makes sense. I kept getting hung up on the table relationships and didn't even think about an index. Each event will only happen once, at least as far as we're concerned with now. But, there could be multiple payments issued which we might want to track in the future. Thanks!

I’m developing a claim tracking database that tracks dates of events that occur in the course of processing a claim; such as, Loss Date, Report Date, Estimate Date, Payment Date, etc. I currently have the following tables set up: tblClaim ClaimID ClaimNumber tblEvents EventID EventName...

So I was posting a question earlier today and when I attempted to navigate away from the page I was presented with a dialog about "Stay and earn credit to talk to hot girls" With the options Stay or Leave. I clicked Leave, and now in my browsing history I have an entry for an adult website...

Got it, thanks. One more question, is there an easy way to copy the QstnID from tblQuestions to the appropriate fields in tblRelatedQuestions, since the main question is always "A" and the subquestions are always "B" or "C"?

Thanks for the reply! The subquestions are already records in tblQuestions. They have the same question number as the main question, but a different letter for the subquestion ID. I have created a tblRelatedQuestions. How would I set up relationships with tblQuestions? What would the join...

I have the following table (tblQuestions) structure and example data for a survey database: QstnID(PK), QstnNum, SubQstnID, RespType, QstnText 1,1,A,1,Text of Question 2,1,B,Blank,Text of Sub-question The RespType field defines whether the question can be answered Y/N (RespType = 1) or...

That worked, thanks!

I am trying to apply the following filter to my form: Me.Filter = "[ClaimNum] = '*" & Me.txtSearchClaim & "*'" OR "[ReviewerName] =" & Me.cboSearchReviewer.Column(1) but I'm getting a type mismatch error. I'm using the .Column(1) property to return the text value of the combo box rather...

Just moved this from the Queries forum since it has more to do with Reports, sorry! I’m working on a file audit database, which has a series of questions with possible Yes, No, or NA responses. I’m using the At Your Survey database as a guide, but there are a few details in my database that...

Hi all, new member here. I am a long time lurker, first time poster. Been using Access for basic projects and hobbyist stuff for a few years, off and on. This time I can't figure things out on my own from searching and need some more personalized assistance. So see you in the forums!