Search results

That is the puzzle. The drop down is blank. See the attached pic. I am trying to capture the graident header of the report to use in other reports and forms..

I am trying to get a calculation to change when a cerrtain year starts. It is not doing what I want and I have tried multiple times. I want the calculation to be - Value = Initial * (1+ nRate) until I reach cYear then take the last Value and add cAmount and continue until end. Here is the code...

YOu can create a query that shows you ONLY the data you are lokking for and then set the record source for the report to that query.

I have a report where the Property Sheet for Report under the format tab shows Picture Type = Embedded and the Picture = (image). I have no idea where the image is or where it came from. How do I find that embedded image and use it in other reports and forms?

Thanks. That is helpful but I would still like to get the rest of DCrake code GetCustomProp

I fouond this code from DCrake in the forum and it references GetCustomProp. I would like to try this code out but need the function GetCustomProp. Any ideas where I can find it? Here is the code referencing GetCustomProp Private Sub Form_Open(Cancel As Integer) Dim ExpiryDate As Date...

SWEET .... That did it.

Below is the code I have. I am trying to return SegInvestmentBucketStartValue as currency, but keep getting intergers? Function fnSegmentBucketValues(nYear As Integer, SegROR As Double, pvAssets As Currency, PercAllocation As Double) Dim I As Integer Dim SegInvestmentBucketStartValue As...

Perfect and Simple...... I don't know why I didn't think of that

I am getting a write conflict error when trying to update another field on the same record. What is the best way to work around this? I have a form in continuous forms that filters records by month. I would like to Update the field CF Income to equal Actual Income when I Change Actual Income. I...

I did the decompile and compact and repair and the issue is still there. However, I created a new form with just the combobox "in the same application" and it works. Therefore I conclude that it is something with the existing form. I will migrate the different controls one by one into the new...

I created a new db with just the table and a form with just the cmbStartMonth and the code worked fine. I searched the Vb project and found no instance of date. I am at a loss.

Month Number is a number long integer

I get a type mismatch error. Is that an issue with the two columns in the row source?

I have a combo box named cmbStartMonth that is based on a table with 2 fields. MonthNumber and MonthTxt. The combo box control is unbound. But the column bound property is 1 and the dropdown list shows the MonthTxt "January","February", etc. which is actually column 2. I would like on form load...

I think I have fixed it by putting and iif statement in the query for the Dlookup. Percentage: IIf([Actual]=0,0,[Actual]/[Budget])

I have a form with drop downs for Vendor that returns the budgeted income and actual income. On the form I have a unbound control that uses a query to calculate the pertage of budget to actual income. =DLookUp("[Percentage]","[qryYTDPercentFinal]") this control works fine if there is a least...

The query works perfectly. However I am trying to display the results in the detail section of the form. If I close the form AFTER I click the button and reopen the results are correct. How can get the detail section to refresh and show the new "top values". Here is my code as modified. THANKS...

Thanks.... I am working on it to get it to work the way I intend. Very Close...I'll get it

Working with null can be a pain. I am sure someone here can help with that but in the meantime you can add an expense with the value of 0 zero in the category basketball. That should allow you to subtract zero from 1000 and give you 1000. HTH