Search results for query: *

Thank you both for your help. I was able to achieve my desired results bu creating a second query. One produce the greater than dates and the second produced the qual to and less than dates. I added a second combo box to the form to produce the less than dates and the orignal box contained the...

Hi All I am having trouble adding criteria to a query. I need the criteria to change based a drop down box found in a form "fmReportXIRR." If "In Progress" is selected then I want the query to produce a list of all dates greater then the DLOOKUP value, and if not then I want the query to...

This worked great. Thank you so much for your help.

Public Sub TestXirr() Dim objExcel As Excel.Application Dim p(4) As Double p(0) = -10000 p(1) = 2750 p(2) = 4250 p(3) = 3250 p(4) = 2750 Dim d(4) As Date d(0) = #1/1/1998# d(1) = #3/1/1998# d(2) = #10/30/1998# d(3) = #2/15/1999# d(4) = #4/1/1999# Set objExcel = New Excel.Application...

Hi All I am rather new to access. I am trying to calc the XIRR not the IRR. I have a table in which houses all the amounts and dates necessary for the calculation however I know this calculation does not exist in access. Other posts reference using the excel library to get access to the...

HI. I have the below code in a command button which allows me browse for a file to import into my access db. The button works fine but the excell file gets locked and a placeholder file shows up whit "~$" before the name. The original file now only opens as read only. I would like to stop...

I have the following code in a command button which is used to import excel files into my access db. When the browsing window pops up if I hit cancel I get the following error. Run-Time error '1004': " could not be found. check the spelling of the file name. Any help you can provide would be...

Hi All I pulled the below code from a post to import excel files into access. I do not like using code I don't understand but in this case I had no choice, I am not that proficient in VBA and it works. The only problem I appear to have is that after I import files I get a message that states...

Thank you so much, you are a genius.

Disabling a Command Button for 15 seconds. Hi, I am learning Access/SQL and started building forms as a front end. I have a command button that runs the following code. DoCmd.SetWarnings False DoCmd.OpenQuery "qrAllocationsPhase1Update" DoCmd.OpenQuery "qrtemptable" DoCmd.OpenQuery...

I have a table that collects income generated each month. Each month is a record and each column has different income types interest, dividend etc. The number of columns can grow so i want to pull all columns into the query, a simple select all will work here. Next I want to apply a...