Search results

This is crazy... I upgraded from Access 2013 To 2021. Now I find that some new VB code that I am writing in 2021 causes an error and some of the previous code written in 2013 works just fine in the newer version. Both versions are 32 bit. So I can not understand why this is happening. Has anyone...

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?

Is it possible to insert it (or the data) into a report? I have done this before with no DB bloat. Also it is totally possible that I do not understand what you are trying to do. If that is the case, can you explain it some more?

First, I think you should ask one question at a time. The other thing to remember is that you are over there with the database and we are all the way over here. So you have to make sure that you paint the picture of what it is you are trying to do and the trouble you are have so that we can...

I think you need to define things a little better so that we can help you. Based on what you have posted, I am questioning the table design of your database.

That is why I don't upgrade if it ain't broke. Then I wait for SP 2 before the upgrade.