Search results

Hello, I have a continuous subform that shows records from a table [not the table the parent form is based on] - a check box, a text field with text, and a blank text field for notes. When I click on one particular of the checkboxes I see in form view, I can make the notes field/s visible...

Throwing out the yes/no fields is something I'd rather not do at this point, so I think I'll just stick with my 2 fields. Or maybe the people who are going to use this db can tell me how un/likely it is for people to change their minds, and maybe I can go the triple-state route after all. Thank...

Ok, Gemma, I'm not sure a triple state checkbox setup will work for me in this case. Why? Because I read in my Access book that once a value has been selected, the field can never go back to Null. What I am trying to do here is to show publishing options - publish method 1, publish method 2, or...

It's working now. Thank you very much, gemma, for taking all this time trying to help me. I appreciate it.

It's working now:

I had partial success: When I put this in the AfterUpdate event of the checkbox, I can indeed make my subform visible when I check the second box. What is not working yet is updating the status as I browse through the records on the main form, or just loading the form. I've been...

I had partial success: When I put this in the AfterUpdate event of the checkbox, I can indeed make my subform visible when I check the second box. What is not working yet is updating the status as I browse through the records on the main form, or just loading the form. I've been...

Pat, John, Thank you for your replies. But believe it or not, I am using an option group on my form. And as I said in my initial post, yes, I do have a yes/no field in my table. It is no problem to use check boxes in an option group, just as it is no problem to have them put out either "-1" and...

I think you can have that easier. What I did in a similar case was to provide different arguments to the form via the command buttons, and then the same form can be used for adding data or for browsing. For adding data: "acDialog" acts like the "modal" switch so the form will stay in the...

Thank you, John, that was a very nice example file. Unfortunately, I am using yes/no [boolean] fields, and I am reluctant to change my entire database at this point. The reason why I chose those is that I really need checkboxes for data entry and it was easier for me to go that route.

I'm not exactly sure what you mean by that, sorry. Right now I am using an if statment to un/hide the second option group. What I am wondering though is if there was a way to do all this without using 2 options groups.

Hello, I have an option group with check boxes on my form that updates a yes/no field in a table, so the choices the user used to have were check "something A" or "something B". Now I have to add a third choice of "nothing" to this. Is there a way to achieve this with my current setup, or do I...

In case somebody looks for something like this again - here's a little time picker tool I made based on the form posted by ___, and a pop-up calender by Allen Browne http://allenbrowne.com/ser-51.html

You could turn the mousewheel off when the form loads, and enable it again when it is closed, by using the method described here: http://www.lebans.com/mousewheelonoff.htm Or you can open the form as an edit only form just from that button: DoCmd.OpenForm stDocName, acNormal, , , acFormAdd...

I'm not sure why this isn't working for you, but I'd like to point out to you that it would be better if you created a new thread for each question you have. Somebody who may be able to answer your last question may never see it because he will assume that the thread is about the first question...

I'm afraid it is not quite clear to me what exactly it is you want to achieve - you start out by saying that you disabled the mouse wheel, and then you ask if an enabled wheel can be made to scroll through subforms. So what is your situation - is your mouse wheel working, or not? If it is, then...

I don't think you can close other people's applications remotely - unless you are an administrator for that network.

Hello, Something like this should work:

Thank you, Bob. I'm fairly new to Access, to "trapping" for an error would be a bit of a problem for me. :) Fortunately, I found a solution elsewhere that doesn't require this, so I'll just use that. Thanks for your assistance though, I appreciate it.

This works great; it's for a tab control with 5 pages; adjust "if IngPageNo = " as required [your number of tabs minus 1]: [I didn't come up with it myself, I'm just sharing the solution. :) ]