Search results for query: *

Hi, Thank you both for your help. It finally worked! I can sleep better now. :oP

Hi, Thanks for your time and input. Unfortunately, I had already tried those 2 things and none of them had worked. I should mention that my database is an .mde file. I wonder if that has something to do with it. I hope someone else out there has an answer. *crossing fingers* I've run out...

Hi, I am using Access 2002. I have some landscape reports and some portrait reports. They work fine on my pc but for some reason they all preview as portrait on some other pc's. I was thinking of using code to force landscape in the Report_Open event but I am not having any luck and decided...

Hi. Does anyone know if begintrans, rollback, and commit can be applied to continuous forms? And if so, can you lead me in the right direction? I thought I read somewhere that it was not possible. I have not used this functionality before. I want to be able to have an undo button that will...

Wow, it worked! I would have never thought of doing that. Thanks soooooo much! Star for you!

I have a date picker on a form which at some point can be disabled. Everything works fine until I re-enable it using the '.enabled' property. The date picker box then jumps to the top left hand corner of my form. Does anyone know why? I just don't get it. It's driving me nuts!

Wow, it worked wonders! Thank you so much Coley. I was just about to start coding every checkbox but decided to check my posting first. Definitely deserves a star! My headache is gone! :o)

Thank you both. This is the code I am using. It seems to work. Does it look alright? So I suppose there isn't a way to simplify this? I guess I will have to call this code for every check box that I have. :oP *sigh* Private Sub chkCheckBox_KeyDown(KeyCode As Integer, Shift As Integer)...

Thank you Coley. I tried that but now the 'Alt + r' doesn't work. Also, I was hoping to not have to code every checkbox. But I do appreciate the help. :o)

Has anyone had experience with this problem? I find it very odd. I have a form which has a 'Clear' button on it which clears all the fields in the form. The form consists mainly of date fields and checkboxes. I have used the '&' before the letter 'r' on my button so that users can press 'ALT...

Thanks to all of you for your quick responses. It's worked! I should have come to you earlier! ;o)

Thanks Paul but I'm sorry, I don't understand. How would I do that? I have declared the variable in the General Declarations as a global variable (I believe that's what it's called). For example: Option Compare Database Option Explicit Dim blnAnswer As Boolean What I would like to do is...

Good Day, Does anyone know if it is possible to reference a variable of one form module from another form module? And if so, how? For example, I know you can do this to access a textbox in another form. Form_frmFormName.txtTextBoxName But I would like to know how to access a variable...