Recent content by Brogrim

I have 2 tables that I want to build a complex query off tblBadgeMemberDuplicates MemberID (PK) tblBadge MemberID (FK) DateOfIssue DateOfExpiry Each member has 2 badges in tblbadge, I want to filter 1 badge for each member, I want the badge to be the one with the highest date in the date of...

No, there is no grouping totals in the query

I have a form that gets its record sourse from a query when I try to update a record, it gives me the message "The Form is Read Only" Thanks in advance

Thanks, working fine

Your Sort and Grouping Dialouge box should have 2 groups under Field/Expression Area Name SRNumber The group header should set yes. The 4 columns go into the section detail. This should resolve the problem

I have a mainform with a rtedcord sourse that includes the field memberID, this field is the link to the subform which has the memberid in its record sourse. This works fine but in the subform there is 2 types of records with either a 1 or 2 value in the MemALSSerAgreeTypeID field I want to...

Thank you I have used your instructions but the dubform is still shown all the records I am placing MemALSSerAgreeTypeID = 1 in the filter section of the form and the akkow filter is true. Is this where this information should be Thanks

I have a subform on a main form. I want to Filter the records shown in the subform The record sourse is tblMemALSSerRoster There is a field called MemALSSerAgreeTypeID which has 2 values 1 & 2 I have tried to use the following MemALSSerAgreeTypeID = '1' MemALSSerAgreeTypeID] = '1' (Do I...

Thanks for the answers dhookom worked.

I am adding the values in 2 sub reports Value 1 ([sbrptROCAttendances1/2].Report![txtAttendances1/2]/2) Value 2 ([sbrptROCAttendancesFull].[Report]![txtAttendancesFull]) The expression is...

I was getting the following message when I closed a file, Table 'TempMySysObjects' already exists I carried out the following tasks as directed by a rreply thread 1.Tools, Options, View - check Show System Objects. 2.In the db window, delete TempMySysObjects. 3.Tools, Options, View -...

Thanks alot I am not recieving the message anymore but it is now asking for the password when I close the file.

I am getting the following message when I close a file, Table 'TempMySysObjects' already exists the file is set up to compact on close Thanks

I have a form that I want to be in the background invisible at all times. 'Me.Visible = False DoCmd.OpenForm "frmLHO", acNormal Thanks

Thanks can you be more specific or are you advising me to start learning database design. thanks