Recent content by TheFerrisFile

There is a dropdown box that one user claims she gets an error periodically when she selects her name from it. Apparently nothing more than a dialogue box, but I guess she cannot be bothered to take a screen capture. Keep in mind these users are not tech savvy in the slightest. I have tried...

This question stems from an issue I am having within the agency I work for. I have a multi-user database of about 20 users. A few of them are saying that they are getting errors while inputting data that I have been unable to replicate both from my desk and theirs. I have requested multiple...

Actually...I figured out where I was going wrong. Thanks anyway!

I am not the most knowledgeable with coding and have limped my way along to even get this far. I have a continuous form that shows all of the records that are open in the db. I have a button on the continuous form that opens the main form to the specific record located in the subform on the...

Maybe next time before insulting someone, you could think about the fact that not everyone is savvy with even the most basic functions of Access and provide a little insight as to the correct way of doing this. Someone might take you as a jerk. I will chalk it up to you just having a bad day...

any takers?

Thank you for the response, except I need a button to toggle through the different records. How do I attach that button to my unbound text box and still use the search code?

I have a form where nurses enter claim numbers and the actions they have taken on those claims. At the bottom of this form is an unbound text box that they can search for a specific record with the following code (found on this lovely site): Sub CboMoveTo_AfterUpdate() Dim rs As...

I find the people on this site not only helpful, but understanding in that someone can ask a simple or newbie question and not feel like the dogs will be unleashed. Thanks again!

My goodness, that did the trick. It's always the simple ones that get me. Thanks everyone for your responses and thanks Bob for your help!

The purpose of the Status_ID is to notify the user if a record has been completed. Status_ID: 1 = Open Review 2 = Completed Review The user enters all of the information into the main form. When the record is completed, they "log out" the record on another form where they manage their...

Status_ID is a Combo box that is not visible on the form. I have tried writing some code that makes the combo box visible, then change the value, then back to visible = false. But it still gets caught up on the SetFocus of the button click event procedure.

I am trying to set up my form so that when a button is pressed it changes the value of a hidden combo box to another value. Here is my code so far: On the button Click event procedure: Private Sub bttn_date_Click() Me![ONCLog_DateOut] = Date Me![Status_ID].SetFocus End Sub On the GotFocus...

Thank you for posting this, except I keep getting VB errors... Here is my code: Private Sub Check100_Click() If (ClmInfo_FicheOrdered) = 1 Then (ClmInfo_DateFiche) = Date() Else End If End Sub But when I run it I get a compile error - Expected: line number or label or statement or end of...

I am building a DB in 2007 yet our department has not yet fully upgraded and won't be until the end of the year. Currently we are running Access 2003, will this prohibit the users that have yet to upgrade from utilizing the DB? Sorry if this has been touched on before, but I have searched high...