Recent content by brendandaly

Dim LICEXPDATE As String Dim LDate As Date Dim NEWEXPDATE As String Dim NDate As Date LDate = CDate(Me.LICEXPDATE) NDate = CDate(Me.NEWEXPDATE) If LDate >= NDate Then MsgBox ("Updated Expiration Date must be after Original Expiration Date. Please Re-Check.") Check19 = False End If This...

I figured it out. Thanks any way!

Because it return the msgbox whether the date original license date is after the new one or not.

Dim LICEXPDATE As String Dim LDate As Date Dim NEWEXPDATE As String Dim NDate As String LDate = CDate(LICEXPDATE) NDate = CDate(NEWEXPDATE) If LDate >= NDate Then MsgBox ("Updated Expiration Date must be after Original Expiration Date. Please Re-Check.") Check19 = False End If It give me a...

Yeah, that's exactly the problem. I need it to work on the LICEXPDATE field, not a specific date in an expression. By the way, you've helped me before. Again, I can not possibly thank you enough for what you do.

Ok, I'm checking out CDate() but everything I can find on it has it working on specific date expressions. I'm trying to fool around with it to figure it out, but can you provide me an example?

I've got two text fields (they have to be text fields as they're in a dbf file) with dates in them in the format "yyyy-mm-dd" and I'm trying to have a message box pop up if one of the fields, lets call it LICEXPDATE, is the same or after the other, NEWEXPDATE. I'm not even sure if I've figured...

I need to figure out how to put together a graph based on counts of records of different types. There are 4 different categories the the records can fit in: DEA, NPI, Medicaid Sanctions and OIG Sanctions. In addition, under each of these categories, the records can be either "good" or "bad."...

Oh and pbaldy, you are officially the most helpful and generous objectivist I've ever met.

No, no, no. The problem here was my ignorance. I didn't know that it was impossible to use VBA to focus on a specific record. I just added invisible text fields for FIRST, MIDDLE, LAST, SUFFIX and PIID, used your code (expanded for each name part) and bam. It worked like a charm. THANK YOU SO...

Btw, this code is returning a "Object Required" error.

Ok, I think this is going to work and I REALLY appreciate the help, but a couple of quick questions to get this going. I actually need the boxes in the second form (and thusly those fields on the second table) to be filled from the table the first form populates from because the form actually...

Yeah, I apologize, that wasn't the best description of the issue. That article is close to what I'm talking about. I've got this form that allows auditors to do edit records of doctor's office addresses that is based off of one table (lets say 'tblIndividuals'.) What I need to do is bring up...

I need to build a form that fills out a table with records that are linked to a master table but I can't figure it out. Some of the fields in the table need to be automatically filled out by information from the master table on a record by record basis. This seems pretty straight forward but I...

Hmm. My original thank you post didn't show up after I posted it so I reposted.Oops. Eh, for these beautiful queries I'll thank you twice.