Recent content by crisb184

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 " & _...