Search results

I am trying to change a calculation every 6 years if a variable is true. Here is what I have. (see the comments after If nInflYear = 5 Then) There is a test function below using the arguments. The correct answer will be 5000,5000,5000,5000,5000,5796.37. So every 6th year the calc changes...

Thanks Kiwiman PERFECT.

I am trying to calculate monthly interest on a value after each withdrawl. The starting amount is 175502.95 The monthly withdrawl is 5000 The annual interest rate is 1% or .0008333 (.01/12) start 175502.95 5000 0.01 0.000833333 1 175502.95 5000 170502.95 142.0857917 2 170645.0358...

Thanks. I understand that now. I mofified it a little by setting default values for the control show when the form opens it show results then the user can filter the results on change events. Happy New Year!

I am getting an error. Expression to complex. Not sure what to with it. See attached mdb. Thanks for looking and your help.

Thanks for the response. I not sure how to generate the corresponding dates for the beginning and end months. I will try to figure it out though. I makes sense just not sure how to do it. HAPPY HOLIDAYS.

There may be a better way than this BUT - You can export the table to excel then sort the column with the "Null" and delete the "Null" Values. Then attach the excel sheet and do an update query. HTH.

Here is a stripped version. Thanks.

Month is number format integer

I have a field in a query that gets the month from the date field ---- Month: Month([Date]) using the criteria Between [forms]![frmMiscExpenseInput]![cmbSTARTMonthtxt] And [forms]![frmMiscExpenseInput]![CmbENDMonthtxt]. The control on the form cmbSTARTMonthtxt is a combo box that is bound to a...

Solved the problem using 3 option buttons.

I have a procedure to filter and create a query. One of the fields is a checkbox. The code below works and filters whether the control is True or False. The questions is what do I do if want to see all records True and False. ' Check for LIKE Paid If Me.chkPaid < 1 Then varWhere =...

Thanks AGAIN Bob, I always have a problem with "" and ' and "'". Maybe someday I'll get it. I liked the Chr(34). It did make it easier to understand.

This code works varWhere = varWhere & "[Month] Like """ & Me.txtstartmonth & """ " When I try to add a between varWhere = varWhere & "[Month] Between """ & Me.txtstartmonth & """ AND """ & Me.txtendmonth & """ " I get a "data type mismatch in criteria expression" error. [month] is a number...

You are correct. It does have a time element in the table. I am writing the date in code using Me.datebl = Now(). I changed it to Me.datebl = Format(Now(), "mm/dd/yyyy") and that fixed it. Thanks

I am using Between [forms]![rptfrmCriteria]![StartDate] And [forms]![rptfrmCriteria]![EndDate] to select records. This statement does not include the end date. I have 1 record that should show up using today as the start and end date. It does not. If I use today as the start and tomorrow as the...

Boy is my face RED. I tried everything BUT that. Live and Learn. Thanks AGAIN Bob!

I this error "The setting you entered isn't valid for this property " when I try to open a linked table. When I go to the source data table it opens fine. All the other linked tables open fine. I tried to Compact and Repair on the Source Database. It didn't help. The table with the error is the...

Thanks for the response. I guess I wasn't clear. I am looking in a table named tblWO in fieldname [NewWOno] for the control value(txtWOno) on the form. If (txtWOno) does exist in tblWO field [NewWOno] and the field [AmountPaid] in tblWO is null or 0 then I will update the tblWO with that data...

I have a form to enter work order numbers and AmountPaid. What I need is an after update event to verify (look at all the records) and if the WO value in the form control does not exist then Msgbox " Not valid WO number". If the WO exists and there is already an AmountPaid > 0 then Msgbox " WO...