Search results for query: *

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...

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...

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...

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...