Recent content by newbE

After closing the form and reopening it... it is now working. Thank you.

... And the IsNull is no longer working when using the wherecondition.

After changing the code I am getting the first field of the form (same information) for every customer. Any thoughts about that?

I have a table, tblCustomers, where the command button cmdShowLots resides. I have created a report that shows each Customers/Owners lot information from tblLots. I am trying to filter the report to include only the lot information for the current customer/owner and to display a msgbox if the...

Thanks! Problem solved. So simple, but I just didn't see it! Thanks again!

I have attached a screenshot of the form

lblStatus is a label.

Compile error: Method or data member not found I cant figure out why I am getting this error. Any ideas? Thanks Option Compare Database Option Explicit Dim intItems As Integer Dim strName() As String, datBirthDate() As Date, intAge() As Integer Private Sub Form_Load() intItems =...

Input: Duck, Daffy I have a school assignment to create a form with several buttons. I can't get the 'Greeting' button to work. I need the return to be "Hello Daffy Duck". The entry will always be Last, First not matter what the name. I am getting a runtime error '13' "Type mismatch". What do I...

Thanks for the replies. This is an assignment that I am working on. I unfortunately do have to use a loop to calculate the original problem, 2 times the number of years, and three times the number of years as instructed by my professor. Check out the attached form. Anyway, I think I'm gaining...

Thanks for the reply. I have posted more information about what I am trying to do. I need interest to be calculated monthly.

Hi, I am fairly new to this and I am trying to create a form that will calculate compound interest. To encourage the user to invest more money for longer periods, also display the consequences if the investment were for twice and three times the amount and years. I have attached the form. I...