Recent content by etislost

A coworker has created a great dB with reports that actually tell us what we want to know. How can he password protect the ability to save or otherwise deny users the ability to save those reports if they are not placed in a file or drive external to the dB? If this can't be done, is there a...

Whether it is a combobox or an option group doesn't matter. Both fulfill the same requirement. I am interested in the value stored in the form. How do you change the numeric value recorded for a yes response to 1 and for a no response to 0?

I have a combo box set up to record yes/no responses. Yes is currently recording as 0 and no is currently recording as -1. I would like to switch no to 0 and yes to 1. Is this possible? If so, how do you do it? Struggling with my lack of knowledge, Steve P.

I have a table set up with some addresses and other information. I have pictures of the structures at those particular addresses stored on the server. Is there a way to use the hyperlink or another function to link from the cell with the address in it to the picture? If so, please elaborate...

I posted earlier about this and recieved a link to the following code: '****************** Code Start ********************* ' This code was originally written by Dev Ashish. ' It is not to be altered or distributed, ' except as part of an application. ' You are free to use it in any...

Great. Just one problem though...where do I put the code? I'd like to get it to play the sound file when the error for Null entry pops up. If not possible, is there a way to change the text of the Null entry error message? Strugglin as a beginner, Steve P.

I finally have a form set so that it will not accept a Null entry in a Combobox. It shows the standard Access error message when you try to move to another record if you have a Null value in the cbo. Is there a way to change that message? Is there a way to get a sound file stored on the...

I was with you til that last paragraph. Sadly, I don't know how to do that. Please elaborate. Thanks, Steve P.

I have three comboboxes. Box 1 determines whether 2 and 3 are visible using the following code: Private Sub Combo001_Click() Select Case Me.Combo001 Case "Lewisville Lake" Me.Combo002.Visible = True Me.Combo003.Visible = False Case "Grapevine...

I have three comboboxes. The first contains Vbasic code which determines which of the other two boxes is visible depending upon the choice made in the first combobox. This is all well and good. My first problem is this... It is currently possible to not click in the first box, yet...

Is there a way to set up the field labels such that moving the mouse over them brings up a dialog box with a description of what kind of data to enter in the field? The closest thing I can come up with is a "What's This?" kind of thing. Thanks, Steve P.

I forgot to add that I have no experience whatsoever with SQL and don't understand where the variables in the code come from. Thanks, Steve P.

My table is titled "cardtrial". My form is titled "NEWCMNTCRD." My first combo box is bound to a field named "Project" with choices of Lewisville Lake and Grapevine Lake. The second is bound to a field named "Park Name" with choices of Hickory Creek...

Is there a way to link/connect two list/combo boxes so that the values available in the second depend upon the option chosen in the first? In other words, if the first has two options, "a" and "b", and the second box has other values, some associated with "a" and...

I'm trying to figure out Option Groups in the Form View of Access. I can make and label a group using the wizard, but have not been able to get the option group, once made, to change from a vertical list to a horizontal list. In other words, how do you change Title ()...