Search results

YES!!!!!! Thank you Dan!!! That was it, the Call piece. I really didn't think it was possible. :D I really appreciate the time you took to help me on this. Cheers! Cris

Dan, I have attached the database. Let me know what you find, and thanks again.

Here is my click Event code: Private Sub Command4_Click() 'Macro to export data for reports 'Turn off Warnings DoCmd.SetWarnings False 'Determine and set the path for the database location Dim Path Path = Application.CurrentProject.Path Dim...

Where would this code be entered?

I did :) the listbox is gone completely. I think that it is executing the For code without allowing time for the LeadEmail textbox to update itself. I think this is why if it is null to start out then nothing happens after the if, and if a value is in there then it generates something for...

Dan, I know I am really not good at this :) but appreciate you helping me out. Your code to make the LeadEmail a textbox works perfectly. The problem I am running into now is that the If statement will not do anything because the LeadEmail field is empty to start out, it only get populated...

Dan, I have the LeadEmail as a List box because when I try to populate the LeadEmail text box using the following code, it does not pull the email from the table, but rather populates the code itself :/ Private Sub txtPMOLead_Box_AfterUpdate() Me.SCOList.RowSource = "SELECT DISTINCT...

Dan, LeadEmail is a List box. I did not have the code pasted correctly, but once I ddi paste correctly the code did not kick out an error. Unfortunately, it did not execute anything after the If statement (where it should create the email and attach the file. I have attached the entire...

Dan, Thanks for the code. LeadEmail is a List box. I entered the code you suggested and got a Compile error: "Next without For"

Paul, Sorry about the vagueness. Let me try to help clarify. I am using this to automatically send out reports in outlook. The variables populate a textbox that autopopulates certain information that I will use to send my emails. So once abc1 is populated on the form, it will autopopulate...

Hello, I have a For Next statement that I use to cycle through a list of variables. These variables populate a textbox on my form. Once this textbox is populated, i have other listboxes autopopulate based on a query result. My issue is that not every variable will have results in the query...

Hello. I posted this in a VBA forum, but received no response, i know this is not directly applicable to Access, but the users in this forum are AWESOME and very knowledgeable so i fugured I would see if someone could help me. I am trying to publish an Excel Pivot Chart, but keep getting Run...

Paul, Thanks for the prompt response. I had the same name for both the Public Function and the module, I did this to make sure it would work, when really it was why it wasn't (go figure). Trust me i was googling this like crazy trying to solve on my own before posting here. As always you...

Hello, I created a Public Function called fNetWorkDays in my access database, however, when I try to use it in an expression I get "Undefined function 'fNetWorkDays' in expression". The Public Function is in a standard Module in my vba project. Does anyone know why I cannot call it in my queries?

Thanks Brian, that appears to have done the trick. My new code is: Private Sub cboStatusRFQ_AfterUpdate() Me.cboSupplier.RowSource = "SELECT DISTINCT [Consolidated_Master_Req_Pool].[RFQ Contact] " & _ "FROM Consolidated_Master_Req_Pool " & _...

Hello, I have an AfterUpdate event where I want a list box to be populated based on three different criteria based on a table in my database 1. Complete = False AND 2. Supplier on form = supplier in table AND 3. Status in table = "SUPPLIER_RFQ FOLLOW-UP" OR "SUPPLIER_RE-RFQ TO OTHER...

Hello, I am trying to populate a list box with an event after update in a combo box. I can get the formula to work using 2 criteria, the problem is i nee to add a third criteria. When I try to add it I get the run-time 13 error. Here is the code I am trying to use: Private Sub...

Paul, Thanks again, this worked. I think I am where I need to be on this, you have been a life saver.

Paul, You are the man! That would have seriously taken me 3 days of googling. The last piece to this puzzle is getting the results of my query "qmoreinfo" to populate as an attachment to this email. I am trying to use the .attachments.Add to do this but am coming up empty. This will...

Here is my code: Public Function sendemail() ' On Error GoTo ende esubject = "" ''' Apply you subject here sendto = Forms!Escalation![cboSPA] ' apply send to email ccto = "" ''ccto email ebody = Forms!Escalation![emailbody] ''' body details ' newfilename = "" ''' location of file...