Recent content by joemach

Truthfully, I am not really sure why it works that way. I can only assume that it has something to do with the fact that a check box is a graphic image (something special to Access). All I know is that it works that way. Good luck with your project!

GREAT! Glad it worked out for you. Where is PA are you? I am in State College. You can click the "Thank You" link if my answer helped.

Put "Not Is Null" in the Criteria row for the field in the query. Without the quotes. Let us know how that goes.

That's odd. It works for me. What version of Access are you using? My preference would be to add code to the Before Update event of the Form and not let the user leave that control until it was filled in. Let us know if you need an more help.

I think you mean blank fields. You can set "allow zero length string" or "Required" to "No" in the table design for that field. HTH

Question; why is the email address in another table than the contacts table? That email address can only belong to one contact, correct?

How does the data look in the query as the Row Source" of the combo box?

I think you could call a Refresh or Update when you click on the date tab. You should not be hiding or showing fields to do this. You should use a query with a continuous form. And a Yes/No field as a check box to indicate whether the course is needed or not. Then only show the fields that...

Here is another way to accomplish what you want: Put a control on the pop up form with the index field from the main form. Set the visible property to "False". Now you will see only the records related to the main form. Also I would set the model property to true so you can not go back to the...

Definitely agree with getting rid of "On Error Resume Next". That will make debugging a nightmare. You can not find the line throwing the error. Also, no error handling until the code runs without any error. That way when it does trow an error you know what error to trap and how to proceed...

Can you upload your DB so we can see whet your are talking about. Hard to get the picture from way over here.

What reason do you have to save the results of a calculated control (or query) into a table. This would normally be considered bad database design practice.

Think about it, if you are not logged in, how the heck will the server know where you are to give you the time where you are?

Thanks for that, now it makes sense. Don't know why I didn't think of that.

Answered in line ... How many decimal places are you telling Access to give you?