Search results

I have a situation where ideally I'd like to use the statement: if A = B then C Unfortunately, A and B are the result of calculations so are often carried out to many decimal places and not exactly equal. However for my purposes they are. Would it be better to try rounding A and B when they...

That worked perfectly! Thanks so much!!

I have set the Tab Order for each tab in the control. When I click through the tabs in Right-to-Left order, Setfocus is on the LAST tab in the Tab Order. Any idea why?

I have a form with a Tab control containing several fields. I have created a SetFocus statement for the "on click" property of each tab. If I click through the tabs in "forward" order (i.e. Left to Right) the SetFocus is exactly where I want it to be. However, if I click through the tabs in...

That did it. Exactly what I needed. Thanks so much!!

Thanks vbaInet, that gets me closer, but the field is BirthDATE, so with your code it only works if their birthdate is in 2011. I'm guessing the DateDiff coding needs to be a bit different to calculate from the birthdate.

For example, if a user is on the phone with a potential donor and is reminded that it is the person's birthday, the user can score a few points with the donor (hopefully) by recognizing it's their birthday. Here's what I've been trying and it gets an error: Private Sub Form_Load() If...

It's to be consistent with another software package that has that function.

I can't quite get the VB code to work right on this..... I have a form that has information about people. The form stores the person's birthdate (formatted as short date). If today is the person's birthday I want a MsgBox to come up saying "Happy Birthday" and after the user clicks "OK"...

Thanks, I figured it out on my own right after I posted. That's exactly what I did and it worked great!!

I am designing a query based on the data displayed on a form. I want the query to return the related records but EXCLUDE the record displayed on the form. I'm very close. I get the data I want PLUS the current record. Is there a command to EXCLUDE the current record?

Thanks, worked like a charm!

I'm working on a database for an MBA class. The data is mainly information about people: names, birthdates, addresses, etc. I am displaying a photo of each person on that person's form. In order to do this I have to enter the path of the photo (example: r:\images\123456.jpg) into the...