Search results for query: *

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

I have a table called member attendance MemberID, Number Mon Boolean (Yes, No) Tues Boolean (Yes, No) Wed Boolean (Yes, No) Thurs Boolean (Yes, No) Fri Boolean (Yes, No) Sat Boolean (Yes, No) Sun Boolean (Yes, No) I then print a report off by date, example Tuesday 1st August. When...

I have a subform and I want to control the data displayed depending on a selection of combo boxes and list boxes on the main form. I am trying this code from a command box on the main form ___________________________________________________________ Private Sub Command17_Click() Dim...

Thank you, I am very new to this Where does the If Err.Number <> 2501 Then MsgBox Err.Number & ": " & Err.Description go in the code Private Sub cmdMemASL_Click() Case Is = 1 If IsNull([cboHSEID]) Then MsgBox "Please Select a Health Board Area"...

I am using a command button and and option box with values 1 – 5 to view reports in print preview I added some error code to the “On No data” event to each of the reports. Private Sub Report_NoData(Cancel As Integer) MsgBox "No data found! Closing report." Cancel = True End Sub This...

I am trying to get a max value from a query and am using the following, any ideas why it is wrong =DMax("MemberID","qryNameDOBMAATs1") Thanks