Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Brogrim

    Complex 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...
  2. Brogrim

    Read Only Form

    No, there is no grouping totals in the query
  3. Brogrim

    Read Only Form

    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
  4. Brogrim

    Filter on a subform

    Thanks, working fine
  5. Brogrim

    Controlling # of columns via Page Setup

    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
  6. Brogrim

    Filter on a subform

    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...
  7. Brogrim

    Filter on a subform

    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
  8. Brogrim

    Filter on a subform

    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...
  9. Brogrim

    Error message on expression

    Thanks for the answers dhookom worked.
  10. Brogrim

    Error message on expression

    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...
  11. Brogrim

    Compact on Close Password

    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 -...
  12. Brogrim

    Compact on close

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

    Compact on close

    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
  14. Brogrim

    Make a Form Visible

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

    Date and Day

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

    Date and Day

    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...
  17. Brogrim

    filtering a subform

    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...
  18. Brogrim

    On No Data Event run time error 2501

    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"...
  19. Brogrim

    On No Data Event run time error 2501

    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...
  20. Brogrim

    DMax Function as a control

    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

Part and Inventory Search

Back
Top