Search results

Hello Uvuriel, First, create a new macro. Under the action column on the 1st line, type 'RunCommand'. Look down where you'll find a command line. Enter DeleteRecord. Then on the 2nd line, type 'RunCommand'. Enter Close on the command line. Save your Macro whatever name you chose...

Almost Got It!!! :D DCrake, ok, here's what I figured out thus far... I have created a 'New Entry' form, with txtFirstName and txtLastName fields. Once I type in the last name, if there are similar names that already exist, I get the 'Select Participants' form to open, which has a listbox...

Thanx DCrake...I'm pretty new to this...could you be please be more specific? I understand how to make the new popup form, and all of the buttons, but, a. how do I 'perform a count' b. what is partial string comparison c. how do I write the code to set the filter with the 'Use Me' button...

I have a "New Entry" form which pops up a msgbox when a duplicate name is entered. Is there a way to pull up a listbox of the potential matches? The user should be able to select the correct one, and either double-click or hit a yes button, which would take the user directly to the selected...

I have the code below on both unbound fields (txtLastName & txtFirstName) on the after update event. It works when I enter the first name first, then last name. Gemma, at the top it says Option Compare Database, but I did include the "." with NoMatch, and I don't get the error with it anymore...

Thanx for the response. I tried the NoMatch without the "." and it seemed to work...I will let you know for sure soon. Meanwhile, what's wrong with the following code (redlined where the problem lies) When you mouseover rst, it says rst=Nothing. Private Sub txtLastName_AfterUpdate() If Not...

The highlighted line is where the problem lies. I've made sure MS DAO 3.6 object library, VB for Apps, MS Access 9.0 library, OLE automation, and MS Data ActiveX Data Objects 2.1 Library under Tools---->References are all selected. What am I missing or doing wrong? Thanx in advance for your...

Paul, You Are The Man...that Worked Out Great!!! Thanks A Million!!!

Paul, I know I'm on the right track. Is there a way to format PCDate as a date field. My statement is based on the PCDate being greater than 1 year ago. The Inactive box isn't working because it's looking for a date and the Nz statement produces a string (I believe). I'm fairly new, so...

Paul, Here's what I've done so far. In my query, I created a new field (PCDate: Nz([ProgramClassDate],#1/1/2020). That gets me past the Error 2427, but the Inactive box is box is blank on all records. Is there a way to format this new field as a date? I believe the statement 'Me!Inactive =...

Here's the scenario: There are Activities (subform) that Participants (main form) were involved in. If the activity took place over 1 year ago, they are considered Inactive (checkbox on main form). If there are no records in the Activities subform, I get the Error 2427 "You entered a value...

Still a bit confused... Function nnz(testvalue As Variant) As Variant 'Not Numeric return zero If Not (IsNumeric(testvalue)) Then nnz = 0 Else nnz = testvalue End If End Function Should I create a field called testvalue or substitute testvalue with...

Thanx for your response Paul... Would you suggest I use it in the main form or as a global function? And if on the main form, should it be under the on current? Again, thanx for your help...

First, let me say, I've searched and searched, and have been trying to make sense of all the posts, but they all seem to point to reports and not forms. What I'm trying to do is simple. On my main form, I have a checkbox called 'Inactive'. I have an Activities subform, which has a Class Date...