Search results

That doesn't work as I need to select the max ReportID number for each client that has multiple records in the query.

I have searched through the forums and unless I'm not performing the right searches, I'm not find the answer, so I apologize in advance if the answer is out there already! I have a query pulling data from two other queries (qry_Reports and qry_Surveys). Clients may have more than one ReportID...

I need to design from scratch a Facility Maintenance database that tracks inventory, repairs, preventative maintenance, costs, requests, vendors, etc. I am trying to find some template examples to give me ideas on how to proceed. I have already viewed the vehicle maintenance template in...

I am trying to develop a report that when the user selects the report from a combobox, the report will prompt for parameter questions and then open. I have a list of counties that I want to be able to query for as well as dates. Is there way to have a box open with the list of counties to...

Thanks! That worked!

I have a subform in datasheet view for tracking calls from clients. The Client Name is a combination of the first and last name. I want to create a text box that allows me to start typing in the client name and it will filter for only those Clients that match. Currently, I have the following...

Found it, I didn't have AfterUpdate, just Update! Now it works...again, thank you!

HI pbaldy, I spoke to soon, everything is working, however, now when I choose Other (Specify) in the PrimaryDisability field, the PrimaryOther no longer shows up, I can't figure what I did wrong with the codes! Any thoughts?:banghead: Private Sub Form_Current() If Me.PrimaryDisability = "Other...

Thanks! I just figured it out, but I couldn't have done it without your help! Thank you!:)

Great! Thank you, that fixed the Primary Disability, however, the Secondary Disability continues to show in the new record. I'm guessing I need to change something within the code to make that work as well. Any suggestions would be great! I really appreciate your help!

Private Sub Form_Current() If Me.PrimaryDisability = "Other (Specify)" Then Me.PrimaryOther.Visible = True Else Me.PrimaryOther.Visible = False If Me.SecondaryDisability.Visible = Me.SecondaryDisabilityYN = True Then Me.CauseofSecondary.Visible = True End If End Sub Private Sub...

Thanks for the suggestion, but if I try to create this under On Current I can't use End If or End Sub to complete the code. It keeps coming back with errors.:banghead:

I have the following Event Procedures in a form: Private Sub PrimaryDisability_Change() Select Case Me.PrimaryDisability Case "Other (Specify)" PrimaryOther.Visible = True Case Else PrimaryOther.Visible = False End Select End Sub Private Sub SecondaryDisabilityYN_Click()...

I have searched the site and the internet, without finding an answer to my problem, I'm hoping that someone can help me find a solution! I have created a Access 2010 database to track applications/reports deadline dates. I would like to set up an automatic email to be sent to my outlook 2010...