Search results

yes, the checkbox is a field in the form's table I originally had it unbound because I thought I would only need to view it through the form, but I later realized I needed it for query reasons so I made it a field.

Thank you for being so patient with me Rich. I think I found the reason to why your code's not working for me. After deleting the other codes and just keeping the one you provided for me, it works perfectly fine, like how I described it. However, maybe this is the reason why it doesn't work...

I also have other codes in the forms On_Current event for other actions.. Private Sub Form_Current() Me.cmdOpenBiop.Enabled = Nz(Me.chkBiopsy) If Not IsNull(VisitDateNB) Then Me.MedianDML.Enabled = True Me.MedianDMLleft.Enabled = True Me.MedianCVmotor.Enabled = True...

Thank for you help, but it still does not seem to work. I'm not receiving any error message, but when I open the form, the txtbox control is still disabled even when there's a check in the checkbox.

An error message of, "Invalid use of Null" appears.

ok, i thought Ray's suggestion solved my problem, but it apparently did not. Here's the problem, I put this in the On Click event of the checkbox control: If me.checkboxname = true Then Me.txtboxname.enabled = True else Me.txtboxname.enabled = false End I during data entry, when I click...

That was easy! Thank you Ray and thisisntwally!! =) I've been fooling around with the same code, but my problem was not being sure what to set the chkbox value as.... the part bolded in blue: If Me.txtName.Visible = True then I kept putting in "value" then "Yes/No" and I knew "Text" would not...

Hi there. I'm not sure what to reference a check box as. What I mean by this is.. I have a checkbox and a text control (the text control is disabled upon entering the form, but the check box is not). What I want to happen is if I click on the checkbox (with a check in it) then the text control...

Hello. I'm not sure if this is even possible, but just thought I ask those of you more experienced with Access. I created security for my database using Access' User-Level Security. What I'm wondering is if it's possible at all to create a command button in my database where I can have...

Thanks bob. For others in the future wondering the same thing, I found a solution to my problem. I tried setting the forms Pop up to yes and it works ok.

Hello. I have a form that has multiple command buttons that, on click, would direct me to other forms. In my Main form, I put the auto maximize code in it's Open event: Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize End Sub the problem is, when I open the other forms through the...

Hey thanks for both reply! I tried switching the Modal to Yes first and it works!! Thank you =)

I have a Main form with other controls on it and a command button that opens up a small form. On this small form, I have a SAVE and CLOSE button. How do I make it where the focus is set on the small form UNTIL I press the close button? Meaning, once I open the small form, I would not be able...

Hello. I have a text search form. When I enter in a value (text value) that pertains to a certain control on my form and press search, if such a record exists, the information in the controls will change accordingly to my searched text. It's a search control that only relates to that form. The...

Easy and simple, Thank you!

Hi. Is there a way to make the tab order return to the first control after it reaches the last control instead of having it tab on to a new record? Thanks in advance for any help.

Thank you, HiTechCoach. I'm not quite sure what you mean by, and as for placing a combo box control, that would be useful and good idea, but what if I wanted to print the report? That would mean I would have to print a separate sheet for diagnosis2 to indentify which ID is which diagnosis2...

Here's a review of how my form is like. I have a subform for Diagnosis for each patient. Each patient can have more than one diagnosis and within the diagnosis types, ONE of the diagnosis has additional subcatergories. I put those subcatergories in a separate table, Diagnosis2. What I want to...

THANK YOU for the reply. Unfortunately I am not. Are there any other options, or another way you can help explain it to me?

Hi. I have a form with tabs that also contain subforms within them. When I click through each tab, ONE field in the subform is highlighted with the cursor in that field. This gets really annoying when I just want to view the data and not enter in data. Is there anyway I can prevent this? Thanks!