Search results for query: *

Thanks Skip! I might have another use for that function. I didn't know it existed. I appreciate your help. I actually found another post that I have tried. The combination of the up arrow, the alt key, and the home key copies the contents of the cell instead of the cell itself. I think...

Hi folks. I hope you can help. I have a spreadsheet with a list of file names Column B. The files themselves reside on a server. In column C, I have the path to the corresponding file on the server. The two cells are side by side in my spreadsheet. I'd like to be able to copy the contents...

I have an Access 2002 database I am working on but, alas, have practically no knowledge of VBA. I am using the following code to find a record on one form using a combo box on another form. I got this here many years ago and it seemed to work in Access 97. Here is my code: Private Sub...

When I create a new form in Access 2000 and click on the form properties button, under the "Other" tab, the "has module" setting on my computer is set to "yes". Does anyone know how to change this to a default setting of "no"? I've looked but cant seem to find the trick. Any help would be...

Oops, I forgot to mention this was for Access 2000. Thanks, kp

I want to change the back and fore colors of a field based on the PrepStatus field's value. This is an import from an AS400 that was exported to excel. This is my code but it doesn't work. Private Sub Form_Open(Cancel As Integer) If Me.PrepStatus.Value = "AT PRESS" Then...

Thanks MajP! I have to try it after dinner but am eternally grateful for your help! Enjoy the star! You earned it. kp

Thanks so much. Your star is almost within grasp. I'm not sure how to proceed since it's the input into one field that is to change the view of another. Will this work if I change to a single form view? Do I have to something with the "on Current" setting of the actual form? Any more help...

I am creating an Access 2000 database for my wife's very small business. I have created a form for her to log her expenses. There is a combo box with common expense types called "TypeOfExpense". I wrote this simple code so that, for example, if "Parking" were selected from the list a text box...

Thanks AceMan1! I found the problem. I'm not sure what the issue was but I relinked the table and it seems to work fine now. Here's your star. Thanks for offering a helping hand! kp

I have a form that I've created. I've set up my own navigation buttons. They work fine on one form but not on a new form that I copied from the form that works. Each time I click the navigation button for the next record, I get the message "You can't go to the specified record. You may be at...

Thanks so much! I'll give that a try. You've made my day. mgrogro

I have a form with a subform from which I create a report that is e-mailed in Snapshot format. All works suprisingly well considering the author. However, if I don't cycle completely through the subform to the point a new (blank) subform record is created, the last subform record (that only...

Oops, I forgot to mention that I'm still using Access 97. Thanks!

I have an option group with two choices. Toggle 1 is labeled 'yes' and returns a value of 1. Toggle 2 is labeled 'no' and returns a value of 2. If toggle 1 is pressed, I'd like to change the backcolor of my subform (called "TestSub"). Can anyone help without going to too much trouble? I've...

Thanks Golom. I was trying to do something stupid. Your ideas got me to thinking. I was trying to search with the database in edit mode. I had never tried that before and didn't know it couldn't be done. Thanks again! mrgrogro

I'm using the following code (provided to me long ago on this site...thanks!) and have used it many times to search one form from another pop-up form. Private Sub Enter_Code_AfterUpdate() Dim db As DAO.Database, rst As DAO.Recordset Dim frm As Form, Criteria As String Set db =...

Thanks handsonaccess! I had already removed the close button and was doing that from a command button on the form. Your post made me think of something else. I think I'm going to make the close command button visible only if all the criteria are met. Can you feel the synergy now? Thanks...

I have a form that has 36 checkboxes. (three possibilities for each of twelve items) Depending on which box is checked, a text box is updated to "Safe", "At Risk", or "N/A". Ive noticed that not every opertor has been diligent in making a selection for each item. I'd like to change that. I...

Great advice. I'll give it a try. I really appreciate your response. Have a great day! mrgrogro