Search results

I agree with you but the users want to use the keyboard for all their work so i have to make it the way i have to keep things easy for them.

Thanks for the suggestions ezfriend. I have made all fields visible and have put a star next to the required fields but i would rather a text box at the bottom as there will be other options available at a later date so i just need to know how to code the text box. I have tried a select case...

I am having a few form coding problems and i hope someone can help. I have attached a copy of the form and the relating table so you can see what i have tried so far. Basically i have the form which is used to add new customers to a table. The first text box (accountcode) works how its supposed...

thanks for the reply bob that works a treat. All i need now is a way of having a message box pop up if anything other than Y or N is entered into the final checkbox. At the moment if the text box is empty or has any character in it when the enter key is pressed it adds the record. i have a...

first of all thanks mutdogus and gemma for the help. Mutdogus, the code you suggested for the vbyes and vbno was perfect for what i want The select1 textbox is used to enter either y to add the record or n to delete the record entry and the code is in the afterupdate event of select1. The...

Thanks for the swift reply wayne, changed the code as you said and got it sort of working The problem im having is that it is still adding the record if i select the vbno button or if any other character is entered into the text box. Is there a way of returning to the form as it was after the...

First of all i hope this is in the right discussion and sorry for the long post Hopefully someone can point me in the right direction as i cant figure this out. I have a form used to add new customers which works fine for adding customers but if i get to the end and then want to cancel it the...

Wayne Is there any way to change that Thanks

First of all sorry if this is in the wrong discussion section I have a search form that displays a list of customers in a list box dependant on what i type into a text box.There is a query tied to the list box that gives a number sequence for each customer i.e 1 for the first line, 2 for the...

Thanks for the reply uncle gizmo. It makes things much easier when you know what to search for. heres the link to the post that helped me solve the second part of the problem :- http://www.access-programmers.co.uk/forums/showthread.php?t=142247&highlight=checking+duplicates Now all i need is to...

I have a form for adding customers to a table which works well on its own but i have added a text box to the bottom for a simple y or n answer heres where my problem start if the user presses y it should add the details to the table but if the user presses n then it doesnt. Now whichever the...

more than expected Thanks very much CraigDolphin All works a treat and the work you've done is much more than expected.I'm off now to learn what you have done. Thanks again.

firstly sorry for the long post but hopefully i can get these annoying problems sorted on here. I have a search form that i use to search the customers table and display the matching names in a list box. The listbox is based on a query with a sequence field. Problem 1 When a user enters part...

me![accountcode] comes from tblcustomers. I have added a copy of my db so you can see exactly whats going on. Thanks

Search form extension Now i have the search form working and i have added a sequence to the results. I have a text box at the bottom of the form and i want to enter the number of the customer and have it open in another form. The code i have on the afterupdate of the text box is : If...

Uncle Gizmo I have been looking at the demos you supplied and am having some trouble converting them for my own db. I have a table of customers (tblcustomers) and two fields accountcode and customername.when i try to change the query to suit my db and i try to open it i get an enter parameter...

It works (yippee) That worked a treat thanks Oldsoftboss And also thanks to Dcrake for all your help and patience. Also without seeming rude (im still learning access) could one of you explain the difference in the code you both supplied. Thanks

ok I tried what you said and i get an error when trying to save it. Ive attached a picture of the error message. Hope you can spot the error cause my eyes and brain have lost the will to do anything. Thanks for the help and patience.

thanks for the info on problem solving code, couldnt quite get it to work but it is something i will look into when i get time. the problem code is this line "WHERE accountcode Like '*" & sText & "*' ORDER BY accountcode;" the parameter value is asking me for accountcode and i know that this...

thanks so far dcrake The problem im still having is it is asking me to enter all the details in the enter parameter value box that pops up every time i touch a key. heres your code : Private Sub txtsearch_Change() 'Purpose: to refresh the contents of the list box based on the text entered...