Search results

I am working on some code that will check for duplicates after update, but what I am wanting to do is if there is a duplicate to pull up that record. I really don't want to do this with a combo box or list box because my users won't check for duplicates, they are sales people in a hurry. My form...

Although I appreciated the advice about the combo boxes, I would really like to just use some code to do this. All I really need is some code to use the data in the [Homephone] field and find the matching data and move my focus there. Does anyone know how to do this? Thanks

How could they enter new information into combos if the customer is not in the system yet? Please excuse my ignorance on this.

That is good advise, but my users aren't going to take the time to check a combo box to see if the customer is already in there. Sometimes they just start typing and never even think to check. So this would be like their check.

Here is my problem, I am trying to check for duplicates and if any found find the matching customer and go to that record. My coding is working all the way up to checking for a duplicate and warning the user that there is one, but that is where I am stuck. I need some code that will then find...

Without being able to look at the way you have these forms and tables setup I can only tell you a few things that you might check. 1. Do both of your forms contain the related "ID" and that id is part of both of the forms tables? 2. Are your tables joined together with that ID? I hope these...

Try using a copy and paste technique. I have an OLE object in my form and there is almost always trouble with "insert object" but not copy and paste. Good Luck!

While setting this up I came across another question. The check boxes are not what is called runners, there is a field called "setup item" and it is a combo box. What I need is if "Setup Item" = runners then make the box visible. How do I alter the code above to do this. Thanks

The disclaimers aren't stored but can be very easily and would probably be a lot easier. Thanks for the help, this is what I was looking for.

I am building a report where I need to have customized text boxes appear if an item in another field is shown. For example These are service agreements and if the sales person checks "runners" to appear on the agreement then I also need a text box with a prewritten disclaimer to appear on the...

Thanks for the quick response. When I am in form view the "Size to Window" option is greyed out. So what am I doing wrong?

I have a form that has a tab control with subforms on it and when you click on some of the tabs it auto resizes or auto centers to that form. The forms are big, but I want it to not take the entire screen, but show the top of the form. I have the auto resize and auto center set to no but that...

You all are wonderful. I will check out every site and hopefully learn enough so that I can start making some of my own code. Thanks again! :=)

Thank you very much. This will be a great start.

I am a beginner in VB programming and I am wanting to learn the ropes of VB. I know some things, but the actual writting the code and the order it goes in is what I am somewhat stuck on. Can anyone suggest any sites or helpful information that I might refer to? Thanks in advance, sam

I have a notes field that users type in caps in and I want to restrict that. I have the rest of my fields set to proper case but I need something like a sentence case. Is there such a thing? Thanks in advance.

On your command button you will need to have some coding that will help. This is the coding on mine and hopefully this will guide you in the right direction. The "stlinkcriteria" is the part that links the forms together. Private Sub Edit_Orders_Click() On Error GoTo Err_Edit_Orders_Click...

I hope I have understood you correctly and here is what I would suggest. It sounds like you have created your form from a query and don't have your links set correctly on you relationships. Check your relationships and see if your referential integrity is checked. When I had the same problem, by...

That worked wonderfully. NOW I WON'T HAVE TO SEE THIS MESS! Thanks

I have users that use their caps button all the time and I wondered if there was code that I could use to change the case of the text afterupdate. I would like the first letter cap and the rest lower case. Can anyone help? Thanks