Recent content by hoikhype

Thanks! This works great, but it comes up with a number like 20.423092339439. How can I get it to not round, but just show the number 20? Any ideas?

I am looking to do a calculated field. Not sure what is the best way to do this, but I would like to have a dates in a table with all of our employees that has what date they started with the company. From that I want to know not how many days they have been with the company, but just the years...

How do you create a Multi-Value Field using a Combo Box on a form?

Haha, I know:p. I didn't create the other one. The person that did, no longer works here. I can't see anything in the properties that is making it do that, and if I copy it and use it in another form the checkbox is gone. If I copy and use it in the same form, it is still functional. It is puzzling.

Hmm.. it is definitely possible because that picture i put on there is from the current database I am working on, so I know it can be done. Just not sure how.

This is what I want to do, I just don't know how to do it.

I have a combo box, with 3 columns. I have a list of names in one column, position in another, and I want another column for a check box. That way on the drop down of this combo box, I want to be able to select multiple names in the combo box by checking the box by their name, and then clicking...

Wow.... I feel stupid. My bad. It is because I didn't have it switched to a textbox on my table with the source. ROOKIE MOVE! haha

Right now I created checkboxes in my database, and the dang things check when you click them, but until then they are filled in with a blue color. I have checked properties, and I don't know how to get rid of that so they are just clear or checked. Can someone please help?

How do I make it an option to open the Microsoft Access Database file in a read only or edit mode? I know I have seen it done, I am just not sure how to do it. Also, how can I prevent multiple users to be in edit at the same time? I don't want them to save over each others information being...

Thanks! Your information was very helpful!

I have a section on a report that is a checkbox for items that have been completed. What I want is the macro to filter the report so I only see the items that have been checked. I also want a macro that filter's the report so I only see the items that haven't been checked. Can anyone help me...

I got the check box to work. Thanks! I still don't know how to get that check box unlocked for certain users though.

What do I need to put in the Criteria for it not to show up? I tried "False" and "No", and neither worked. I don't have a logon form for the database.

1. In a form that I have created, I have a checkbox that I want to have checked when the form (help ticket) that was filled out has been completed by our company. I want the checkbox to only be accessed by us. How do I acheive this to only certain users have access to check that box? 2. I have...