Search results

I have 3 fields that I'm trying to query. They are LOB, DIV and Project_Stat_Code. I am trying to count 4 values in Project_Stat_Code ("IP", "OH", "PD" and "C") and Group them by LOB, then by DIV. I'm not sure how to approach this. Should I generate a single query for each Project_Stat_Code...

I have the following in the OnClick Event of a "Save" button: Private Sub cmd69_Click() On Error GoTo Err_cmd69_Click Dim currctl As Integer, numctls As Integer Dim ctl As Control numctls = Forms!frmAddProject.Count 'counts the number of controls For currctl = 0 To numctls...

I have the follwoing in the AfterUpdate event of my combo box Sub cboFind_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[Atten_ID] = " & Me![cboFind] Me.Bookmark = Me.RecordsetClone.Bookmark End Sub if a user changes their mind and...

I've been running a report based off of a UNION query on 2 other queries in Access 97. Yesterday was a happy day (I thought)because I had Crystal 8.5 installed on my machine. But now my UNION query (running in Access)does not work. The two sub-queries work fine (one is a parameter query), but...

Judging from the posts, this group could use a good workshop in combo boxes. I have a 3 column combo box that displays Work_Desc, Work_Loc and Work_Date. It's control source is Work_ID. When the user selects a workshop from my drop-down list, I want to automatically fill the Work_Loc and...

I have the following code in the OnClick event of my command button: Private Sub cmdEditProject_Click() On Error GoTo Err_cmdEditProject_Click DoCmd.OpenForm "frmEditProjects", , , "[tblNewProjects]![Proj_ID] = " & Me![Proj_ID] Exit_cmdEditProject_Click: Exit Sub Err_cmdEditProject_Click...

OK, my apologies but a "search" for this problem was unsuccessful. I'm sure it's been discussed. I have a mainform (frmAttendeeProjects) that displays Attendee info. A Sub form, linked by Atten_ID, displays all projects assigned to that Attendee. I have a control button in the sub form that...

I have a form (frmAttendeeProjects) with a subform (subAttendeeProjects). The subform displays multiple projects linked to the Attendee on the main form. They are linked by the "Atten_ID" field. I am trying to create a combo box on the main form to scroll through a sorted list of Attendees...

I am writing reports from a SQL Server DB with Access. Access will let me do a UNION ALL query, but a UNION query (which would eliminate dupes)does not work. I get an error message about Can't do union on Memo or OLE Object field... Why would it work on one and not the other?

I have a form that enables viewing of Attendee info (name, department, etc.) with Project Info displayed in a sub-form. The datasource for both is a query (qryAttendeeProjects). I can edit the Attendee records, but not the Project records. So, I have created a 'Edit' button in the sub-form...