Search results

Thanks you! This worked!

I created a function in a module shown below: Function GetEmail() 'GetEmail= DLookup("ManagerEmail", "tblLocations", "Location='" & Me.Location & "'") End Function I wanted to use this in multiple forms/reports. No matter where it's is used, the form/report will always has a 'Location'...

Gotcha. I haven't tried that. How would you suggest that that's coded? Any guides you know of?

So I have the below code in a command to send an Outlook email via VBA. It works great but I want to have it test if the email was actually sent (since I'm using '.display' and not '.send'). I want to update a field if the email is sent. I used this guide but I can't seem to figure out what I'm...

I'm gonna create a new post since so much of my code has changed since I originally posted. I found a viable solution but can't seem to get it working. Thanks for the help!

Yes

So I looked at that and it doesn't raises any error unfortunately :/

Got it. Thank you! So I rewrote the code as suggested. It is below. I'm still not sure how to write it so that my 'status' field ONLY updates if an email is sent (maybe it's not possible). The code below displays the outlook message and I only want 'Me.Status' to update if the user sends the...

Okay thanks. I am using the sendobject largely because I'm sending a report from Access with the email. Any suggestions on how to include that in the above code. I'm not finding any guides online that include how to attach a MS Access Report to the email Thanks!

I'm not sure what you mean by automating Outlook (not your fault; I'm an idiot). Could you explain or provide a guide? Thanks

So I am using DoCmd.SendObject on a command to open up an email with an attachment from my DB. I want to add some new code where if the email is sent, then a field in the form updates. However, if the user exits out of the email without sending, then nothing is updated. My code is below...

Gotcha. Any suggestions on a guide? I'm striking out on trying to find a walkthrough specifically for graphs

I have a report which has a line graph of complaints by month. I was wondering if its possible to have a combobox on that report that allows the user to select a certain complaint type and then the graph filters the data down to that selection in real time. If its possible and anyone has any...

Apologies; I didn't even realize there were other comments besides your last one (yesterday was long). I'll give this all a shot and circle back with any issues. Thanks!

How would you suggest to handle that situation?

I have a table that captures changes made to my form's fields. Here's the module's code: Function ChangeLog(lngID As Long, Optional strField As String = "") Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim varOld As Variant Dim varNew As Variant Dim strFormName As...

@arnelgp awesome! Thank you! Last question, I swear. Let's say I also wanted a 'complaint number' search field in that search form. How would you add that in the code? I tried adding the below code in but I'm getting an 3075 error. If Not IsNull(Me.txtComplaintCategory) Then sFilter =...

I have a bit of a unique question. I want my nav pane to be minimized on load of the DB. I accomplished this by using this thread: https://www.access-programmers.co.uk/forums/threads/determine-open-close-of-navigation-pane-in-a2007.220915/#post-1127715 Essentially, I placed this code in the...

@arnelgp One quick question. I've attached your sample DB with a slight change. If I wanted the search form to also allow for the user to input a date range, how would you suggest building the code for that with your existing code? Thanks!!

I have a label in a subform that I only want to be visible if the recordset of the subform is 0. I used the below VBA in the on current event of the subform to achieve that. Private Sub Form_Current() Me.lblNoRecords.Visible = Me.Recordset.RecordCount = 0 End Sub It works in the parent...