Search results

Okay, I got the subform to work and show as many details as I need. I used the Max() aggregate function on the date like you suggested and I grouped by ClientID. Since Access queries won't let you show other details unless they are part of an aggregate function, I just used the Last() function...

Thanks, Alex, a simple example would be great if you can spare the time. In the meantime I'll play around with maxDate and the report to see if I can get what I need. Richie

I guess the best way to explain this is to give an example, so: The main form and subform both have a field called [HomeId] which is the master and child link. The other important fields in the subform are [ClientID] and [Date]. Now, of course, the subform shows only the records where...

Thanks. I'll try it out as soon as I get our DSL and DHCP Server problems worked out.

I need a message box to pop up whenever a user enters a duplicate entry - three particular fields. Duplicate entries are allowed, but usually it's a mistake. The fields are FirstName, LastName, and Client from tblDemographics. The form is frmDemographics. I assume that the code would go in...

Thanks, Rich, your assumptions were correct, and it worked. Richie

I have a continuous form that contains the field [StatusClient]. In the form footer I have the field =Count([StatusClient]). Is there a way that I can make that field only count the records where [StatusClient] = "client"? I want all records to be displayed, but I only want specific records...

I have a subform that is linked/filtered by ReferralID. Within the subform are fields - FosterID and DateOfAction. I have a report that is grouped by FosterID and shows me DateOfAction and other information for each client(ReferralID). It would be really helpful if I could show the...

Thanks, GaryC, you got me thinking in the right direction, but I had to make some adjustments. Here is my final code for displaying a difference in the current date and an entered date that displays years and months in the same unbound text box: =DateDiff("yyyy",[LicenseDate],Now()) & " years...

I currently use this as my Control Source for an unbound text box to show the no. of years a client has been licensed: =DateDiff("yyyy",[LicenseDate],Now())+Int(Format(Now(),"mmdd")<Format([licensedate],"mmdd")) When a client has been licensed for less than 1 year, it shows "0". How can I get...

Talismanic, Your way is definitely more user-friendly. You can review both the starting and ending dates before you preview the report. I'll try it out. Thanks.

I use Access 2000, and this works for me: Create a text box in the report header, and set the control source to the parameter in your query - [SDate] Create another one for [EDate] The help files say you can have both parameters in on text box like: "Between " & [SDate] & " and " & [EDate]...

Open the form's properties box. Choose 'event procedure' for the OnOpen event. Click the elipses to the right of the OnOpen box. This will open the VB editor. Enter the command in between the "Private Sub Form_Open(Cancel As Integer)" and "End Sub" lines. That's it. Your code is saved when...

I really don't much about including image files, but it sounds like you'll need a subform for the images linked by the SSN if you want to tab through multiple photos for the person.

Thank you charity. Your reply let me know that I was on the right track. I had to use: & Me.Recordset.RecordCount I found it by doing a search in the object browser for recordcount.

I'm trying to get the header of a subform to display "Record n of n", so I can get rid of the Access navigator on the bottom. I can get it to display which record it's on, but I can't get the RecordCount to work to display how many records are in the subform. Here is what I have. If...

Is there a way to make a form scroll up or down on open? I couldn't find a command for it. Or is there code to emulate keystrokes like "page up"? I know there was a post similar (not exactly the same) to this one a little while ago, but I'm hoping there's more information so that I don't have...

You could also use input masks that force the letters to be entered as uppercase. Again, try the 'Help' for input masks. Richie

jonp, I had problems somewhat similar to codesmith's, and member 'llkhoutx' created and sent me a small sample. It helped me out a great deal. If you're still having problems, email me and I'll send you that sample database. Richie

I tend to use DLookup a lot for "snapshots" of records quite often, and this always works for me. Here is my actual code for the "AfterUpdate" event of the combo box. My combo box lists case managers' names. The "Department" field is automatically updated after I select a name in the combo...