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

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

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

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?

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