Search results

ok i have found some code that works in the demo but cant seem to get it to work in my db Heres what i have table1(customers) field 1 = accountcode field 2 = customername field 3 = address form1 txtbox1 = txtsearch txtbox2 = txtfilter lstbox = lstdata i have the following sql statement in...

demo missing thanks for the reply but could you attach the demo please thanks

Can someone point me in the right direction please. i have been searching for ages and cant seem to find what i want. I have a search form for customers with a text box and a list box. What i am trying to do is as i type into the text box the list box displays the customers names etc. I know...

I have the following code in a forms textbox: Private Sub Text29_AfterUpdate() Select Case Me.Text29 Case "t" DoCmd.GoToRecord , , acFirst strWhere = "[jobno] =" & Me.JobNo DoCmd.OpenReport "jobs", acViewPreview, , strWhere DoCmd.Close acForm, "newjob" Case "c" DoCmd.SetWarnings False...

basically i have a text box for customers name and i want a message to pop up saying that a name is needed if the user goes to the next text box ( by pressing enter or tab) and also a different messag saying that the name already exists if the user enters a duplicate name.

I have a text box that is used to enter a customers name.I have this code on the lostfocus event : If Len(Me.Customer) > 0 Then MsgBox "message" Cancel = True Me.Undo End if This...

Changed the name and used some sample code from a reply post by mstef (Error 2501 using DCount ) and swapped the names for my own and it works fine. thanks for all the help.

ok i can get a message to show butnot under the right circumstances. Heres the code im using in the beforeupdate box to display a message for duplicates: Private Sub Name_BeforeUpdate(Cancel As Integer) If DLookup("Name", "table6") > 0 Then MsgBox "message2" End If And Heres the code for the...

That gives an invalid qualifier for the .Name part of the statement The name of the field is Name

Thanks for the reply KeithG Got one message to come up for the empty field using (with a little help from one of ruralguy posts) If Len(Me.Name & "") > 0 Then MsgBox "Message" End If but if i wanted it to setfocus on the name field after clicking ok how would i do it and where in the code...

Not sure if this is in the right forum but here goes. I have a form for entering customer and job details (form1) which work fine. What i cant figure out is a couple of simple message boxes. The first field on the form is a "name" textbox. What i want to happen is if the name field is empty...

I have a contiuous subform on a main form that i use to enter multiple products for a price check. I am using Dlookup to pull the description and other details into their respective unbound textboxes on the subform. The problem im having is that when i enter a partno into the text box on the...

the cycle property is set to all records but i have tried it with current record and current page but it makes no difference.

ok now that works the next major headache im having is i cant add more than one line for some reason. If i enter a part no into the text box it fills in all the details and goes to the quantity text box and after i enter a quantity it wont go to the next line it just returns to the part no text...

it works thanks rv it works a treat

its form4 thats the problem.

the problem is that if i use a query then it shows all the records from the table in the subform and i dont want that.I want to be able to enter a part no and bring up the details in the other text boxes and then move to the next line.

yes it is a text field

Im having a strange problem with my dlookup. heres the code:- Me.description = DLookup("[description]", "table2", "[partno] = '" & Me.PartNo & "'") basically this is in the afterupdate of the partNo text box and when i enter a part no it brings up the description of the first record only no...

feeling a bit simple relative info(i think) table 2 part no bin no description retail discount subform 2 form header text box(unbound) main part of form all fields in table 2 as datasheet view when i enter a part no into the unbound text box i want the other text boxes to autofill with the...