Search results for query: *

The button still does not work when I close the form and application and go back in. I do get the same error message also. The name of my command button is cmdCloseVisitEdit and the name of the procedure is cmdCloseVisitEdit_Click(). The only code in the procedure is cmd.Close...

I have 5 forms so far in my database and am currently working on a data entry form. The first four forms all have exit buttons that close the form and open a main menu. For some reason on my fifth form the exit button brings up an error when it is clicked: The expression On Click you entered...

I am having trouble with a calendar control on a form that pops-up when a user enters a date text box. First I am getting an error about the on load event for the form because that is where I set the date for the calendar to today's date. Then once I cancel the error message, it does put the...

I will try that. Thanks for the help.

Is there a way to select an option group button or checkbox and have a memo box pop-up to fill in with text? I have a user that has questions on a form. Each question can be answered with choosing from 4 choices and the last choice is Other and needs to be specified. Please let me know if...

A little background first: I have a main data entry form where you choose a Contract ID from a drop down and an autonumber field ID is activated when you tab form it to the drop down. This autonumber ID is the key for the table under the form. On this main form I have a subform that only...

Is there anyway to change the color of a command button from the default gray color? I now you can change the background color of some controls but I haven't found anything for buttons.

Thanks Jeff for your code suggestion. I added it to my search form and it worked. Now when I open up an edit form I see all of the fields that have been filled in for the ID I was searching on. I can finally finish up my database and train the users on it. Thanks again.

Sorry about the confusion. That code was given to me by a coworker trying to help me with the solution. I am trying to pull up an existing record. I will add your code to what I have and take out the acNewRec. Can I still keep the code for locking the records and unlocking them?

I am using the code: txtContractID = cboProvider DoCmd.OpenForm "editform" DoCmd.Close acForm, "currentform" This code is in the click event for the button on the search form. On the edit form I don't have an open event but a form_load where I...

I have a search form where you select an ID from a drop-down and the command buttons(for edit forms) below the drop-down are enabled if that ID is contained in the table that is queried for each of the edit form buttons. When you click on an edit form button the ID becomes a global variable...

I am pulling the patient id, proc code and pay amount with a query and then adding a new field in the query with the module that contains the loop. My new query field would look something like this: payoutamt: pay([patID],[payamt]). The calculations on the pay amount would possibly be saved to...

Am having trouble building a function to loop through a recordset that contains records that can have one or more billing codes under the same patient number. I need to calculate 100% of the highest paying amount, 50% of the second highest and 25% on all remaining amounts. I have a Do While...