Search results

I ahve a form that is based on a query. I would like to place an unbound control on the form to count a field on if it is blank. Any Help on the code please. Thanks. BAC

Thanks Jack I'll try that. BAC

R. Hicks I am experiencing tremendous difficulty trying to convert this db to 97. I keep getting error messages stating that certain forms are not going to be converted. I'll keep trying. Thanks for your patience. BAC

Can anyone explain why the following code placed on a control would cause the user not be able to navigate through the records in a form? Me.lastname = StrConv(Me.lastname, vbUpperCase) For example: The above function is associated to the "On Exit" property of a control which stores the last...

I can convert it and send it to you but I will have to delete the info in the tables because it is a law enforcement database with sensitive information, but I can do that if you need to look at it. BAC

Unfortunately it is in A2K. Can you tell me how to go about it? BAC

I have a command button on the switchboard that I have set to open form in edit mode. The query is bound to the form.

Thanks for your quick response R. Hicks. I see your point. Is there a way that I could achieve the same results without using a form to launch the query? Thanks, BAC

Jack and R.Hicks, Thanks again to both of you this worked great. Keep up the great help. BAC

Thanks Jack, I am sure Rhicks appreciates your help. Will that msg box allow the user to enter another date or to cancel, whatever he chooses to do? BAC

Rhicks, Thanks for your quick response. It all makes sense and I think it will work, however I am not very adept with vba yet. Would it be possible for you to send a sample code so I could use as a template? Thnaks alot for your time and Merry Christmas to you and yours. BAC

I believe that you need to check the bound coulumn property of the combo box. If that option is not bound to a unique identifier (i.e. the primary key of the table) then you will only get the first selection in the combo box if the there are two selections that are equal in value. For example...

I have a query that shows its results on a form. The Select query had a parameter criteria for the user to enter a date. If the user puts in a date that no data exists I would like a message box to appear and give the user a choice to close or to retry another date. It is easy to do with...

Melody, Your Child link field should not be a primary key. It should be a foreign key that relates to your CustomerId. For example in your reimbursement table have a customerid key that is a number value that you use as a child key to your CustomerId key in your customer table. HTH BAC

Thanks that worked. BAC

Is there a way that I can still obtain the column information without the combo box actually physically on the form?

As usual.....thanks Pat.

I have a form that is strictly used as a result of a look up query. The problem is that I do not want the combo boxes to show as combo boxes on the form. I want them to show as text boxes. I created an unbound text field and made the control source.......cbocombobox.coulumn2 but this is not...

Thanks for your quick response Jack. However, I do have many columns in the combo box. I have lastname, firstname, mi, dob, race, sex and ss# and the person id#. I just can't figure out why I can navigate fine through the records with the navigation bar at the bottom of the form, but the combo...

I have created a combo box on a form that "Looks up values based on the selection in the combo box." However, if I have a list of people with the same last name to choose from in the combo box, I can only choose the first one on the list. For example, if there are two "Smiths" listed in the...