Search results

Yes, you are correct. Once I do the changes in design, click on form view, it takes long time. Thank you,

I have a split database. It takes very long time to go from form design view to form view. I did compact the database also. File size is only 2 MB. Any help is appreciated. Thank you.

Thank you, I tried this and got syntax error. I wasn't sure what is wrong. I added labels with vbred color and added a select statement with vbgreen green in the form current event. It works fine. Thanks again.

Thank you, I have four text boxes. txtDocReceived, txtDocReviewed, txtDocPrepared and txtDocSubmitted. If the len(txtDocReceived)>0 then the the txtProgressBar1 changes the color from red to green. It goes like this for other text boxes (txtDocReviewed, txtDocPrepared and txtDocSubmitted)...

I have a form with 4 stages of activities. Is it possible to have a Status bar in Access?. For example, if the first stage is reached, a part of the the status bar get a specified color and so on. When the last activity is completed, the whole status bar gets the same color. It is like FedEx...

It works. Thanks.

Thank you. It may be very simple to you. I have six images in the form. All images has the same back color (Example. blue ). If one image is clicked, that's back color changes to red. If the next image is clicked, the second image back color become red and the previous image back color become...

Please help me. I have five textboxes for husband with the values typed(HustxtAddress1, HustxtAddress2, HustxtCity, HustxtState, HustxtZip). I have five more textboxes for wife. I have a combo box asking whether the spouse's address is same as the husband - with yes or no. If "Yes" is...

Thank you. But I need if the user click the image2, image 2 should get the red back color and the other images should go back to white. In short, whatever image is clicked, that gets red and other images are white. Thank you.

Thank you. But I need if the user click the image2, image 2 should get the red back color and the white should go back to white. In short, whatever image is clicked, that back color gets red and other images are white. Thank you.

I have images in my form, say, Image1 and Image2 . The default background color for all of them are white. If the user click image1, the background color has to be red. If the user click image2, the background has to change to red and the image1 retains its default color ( White ). I...

Thank you very much. It works.

Yes, you are correct. I need to empty the form before closing. I have given a command button to undo it and then close the form. I have to accomplish this without the undo record button. Thank you.

If the user click on any of the field and close the form without entering data, user get the error message "You must enter a value in the Masterdata.EmployeeID field ( which is primary key ). Please let me know how to handle this error. Thank you.

Kindly ignore my post. I found the reason. There was a code in the form - before update. I removed. It works fine now. Thank you

It is Me.Recordsource="Select*from Masterdata where employeeid='"220141'" Thank you

My database was working fine. Now, if I have to save or edit a record, I get a message Run time error 2107. The value you entered does not meet the validation rule defined for the field or control. I am able to enter and edit new records in the table. I did not change any validation in form...

Thank you very much. This link helped me. Thanks for your help ;)

Thanks for the replies. Actually I am trying to change the control tips color. When I move the mouse over the control ( Textbox ), the control tips color is in white background color which I wish to change to yellow. Thank you.

Can you please let me know how to change the Textbox Contol Tips text or background color in access 2010? Thank you.