Search results

figured itout i joined the two fields and used that to match.

I have a report which brings up all our candidates that we have sent to a particular customer. I need the first name and last name fields to not show up up when they have been sent twice for two diffrent job orders. but when i hide duplicates if anyone has the same last name it blanks thier...

i zipped it and it was 7,000 kb. ill try to pick ou just the stuff youll need and post it but im working on something at the momment. thanks for being so helpful.

lol. i do work mostly in a developmental database. because i would as you say ball it up.

i can't really do that cause im an intern and the thing is friggin huge. i figgured out however where the root of my problem is. My Job order table combines the name of company and the contact which means some companies are uneccasarily listed twice so theresa serious like matching problem or...

syntex error missing operator in query expression combo name ='name of compnay i chose'

OK that seems to be almost working but im dealing with a duplicate problem in my combo box now is there any way to use the properties to not allow dups? the problem is that the table im using shows all the job orders for evreyone so some companies are on there like 30 times and some only 1 so...

I would like to have a form with a combo box open and then when a company is clicked on i would like for my report to open showng all those listings. I have the query and the report and the form but how do i get them to all work together they are not playing nice.

Thanks!!! that helped i went with Private Sub LastName_AfterUpdate() Dim strMsg As String With Me.LastName If Not IsNull(.OldValue) Then strMsg = "Change the name from " & .OldValue & _ " to " & Nz(.Value, "nothing") & "?" If MsgBox(strMsg, vbYesNo +...

I have a lastname field that can easily be erased accidentily. so i need to put a piece of code in there that will bring up a msg box that will ask them weather they relly want to change the last name. The code i have so far just brings up a message box but i need it to restore the last name...