Thanks Twinnyfo and PhilofWalton,
I might be able to implement those suggestions in the future. However, right now they're pretty set on this approach. The issue is more that they don't recognize that they have new projects even though the new projects are listed at the top the list. I was able to develop coding that appears to work. However, it seems to interfere with the functioning of the vba code in the subform. Specifically,...
Karen20785
Last Activity: May 14 '18, 03:23 PM
Joined: May 1 '18
Location:
-
-
Right now, new assignments appear at the the top the list and the status is bolded. Unfortunately, some people are not noticing their new assignments. Ideally, they do want to receive an e-mail listing the newly assigned projects but also want a more visible/audible alert when they open the project form if possible. KarenLeave a comment:
-
I found every bit of guidance very helpful since I'm still learning VBA. I do have a somewhat related question and could use your help. I posted a new thread: https://bytes.com/topic/access/answe...ds#post3815999Leave a comment:
-
How to get Access to Display a Message Alert for New Records?
Hello,
I have a project management database that tracks the status of various projects that have been assigned to users. I was wondering if there is a way to get MS Access to beep and display an alert box when a user has a newly assigned project? The database has a main project form (FRM_staff_proje ct) that uses qry_staffprojec ts as the source of the project data. The main form is a split form.
A newly assigned project... -
Thanks Twinnyfo and NeoPa,
I just wanted to let you know that I tried your suggestions and the form now works perfectly! I really appreciate your help!
KarenLeave a comment:
-
Thanks Twinnyfo and NeoPa,
Sorry for the delay in responding back. I had back-to-back meetings all day. I definitely will try your suggestions tomorrow and let you how it works out. KarenLeave a comment:
-
I think I found a solution:
...Code:On Error GoTo Done Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim TheDate As Date Dim lngStaff As Long Set db = CurrentDb lngStaff = Me.ID_staff strSQL = "SELECT max(Milestone_Date) as Dte " & _ "FROM qryvw_milestonesLeave a comment:
-
Thanks Twinnyfo,
Unfortunately, it still gives me "Run-time error '2427': You entered an expression that has no value" message whenever the user has no milestones.
Below is a copy of coding (for some reason I had to replace Me.frmvw_milest ones.Form with Me!formvw_miles tones.Form)
...Code:Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim TheDateLeave a comment:
-
Thanks twinnyfo!
Yes, field tbl_pria_projec ts.ID_staff is part of the query qryvw_milestone s. Your suggested coding worked with one slight modification:
...Code:Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim TheDate As Date Dim lngStaff As Long lngStaff = Me.ID_staff Set db = CurrentDb strSQL = "SELECTLeave a comment:
-
Open a subform on a record closest to today's date
Hi,
I'm trying to get MS Access to automatically move the cursor to the record near today's date within a subform in a project management database (frmvw_mileston es). The Main form (FRM_staff_proj ect) has the project information and it includes a subform (frmvw_mileston es) that has details about the important milestones within certain projects. The subform shows all the milestones for the fiscal year for the staff member. I want to...Last edited by NeoPa; May 3 '18, 03:15 AM. Reason: Added code tags and adjusted formatting - Made pics viewable (NeoPa).
No activity results to display
Leave a comment: