Search results

Your correct. Even though its the same form issue, I have posted a new tread under Modules & VBA. RG thanks for all you assistance. I appreciate your patience with me, I have much to learn about access. Thanks!

Trevor, I am still having some difficulties with my form. Could you assist me with this issue? My discription (post #5) is what I haven't been able to accomplish 100%. I think I am close. I believe the issue is my lack of knowledge in using the proper if statements in the correct properties...

Yesturday I had some questions about If statements, I am using alot of them, is there another way to combine these if statements????

I see the URL.... <--Silly me.

I don't want to sound silly here, but this idea of yours never crossed my mind. Do you have any URLs available? Thanks!

Its a User Usability issue. I don't want them to be able to check or uncheck the box inside this ActiveX component.

I would like to start off by thanking you for the time you are taking to help me!! Okay this is the purpose of the form. First when you open the form to input the records Checkbox1, checkbox2, and box3 will be enabled and the others will be disabled. Lets say you selected Checkbox1, then...

Okay I have attached the database, I have written some code in the OnCurrent event in the Form. When I scroll between records not all the checked boxes enable and disable properly.

I am trying to utilize an If, Else statement in my on Current event in the form. I am attempting to accomplish a serious of checks so when a record is selected, the stored record will display the selected check boxes properly and the none selected checkboxes are disabled. Any assistance is...

I am glad you were able to fix your issue.

Have one of your queries create a table with the information searched.

I am using Access 2000, on Windows XP SP4. Microsoft Date and Time Picker Control 6.0 (SP4). I used the ActiveX properties and turned the checkbox on. Below is the Private Sub I am trying to modify. I realized that I had to keep the checkbox option checked to get rid of the msg. I would like to...

I am using Access 2000, on Windows XP SP4. Microsoft Date and Time Picker Control 6.0 (SP4). I used the ActiveX properties and turned the checkbox on. Below is the Private Sub I am trying to modify. I realized that I had to keep the checkbox option checked to get rid of the msg. I would like to...

Okay, after I spent some time trying to pin point this error. It is not in VBA, or the Checkboxes. It has something to do with an active control I am using. I used a Microsoft Date time picker. When I try to attach a record source to this this ActiveX component, I recieve that msg.... Sry for...

I have a checkbox in a form, that if it is checked then checkbox2 becomes enabled. If checkbox1 is not checked, then checkbox2 is not enabled. I am trying to avoid this error msg: Can't set Value to NULL when CheckBox property = False. In my data type I utilized Yes/No, and the format is...

RG, I added a checkbox to my search form. I utilized the Triple State settings in the Property, and on my table I made sure I used Yes/No as my data type. I also used an If statement: If tcBox = True Then tcxBox.enabled = False Else tcxBox.enabled = True End If I also used...

Thank you. I was able to accomplish everything. I appreciate all your help.

I tried using your suggestion. But, I can still scroll through records using the mouse wheel......

RG, thanks a bunch. I was able to get everything working smoothly. The only thing I don't understand is when I turn the navigation buttons off in the property menu, I am able to use the scroll on the mouse to move between records... Do you have any ideas in how to disable this?

I tried, but I seem to have made it worse... Do you have an example in how I could utilize this?