Search results

Heres the db that you requested. Its the invoice header form thats the problem Thanks in advance Gareth

ok maybe i did understand it then cause i think i have followed the instructions correctly but it is not work so i obviously havent. It is still giving me the complete list instead of the correct values based on the entered letter. Any ideas

Thanks for the reply rg, very helpful but i cant quite get it to work for me probably because i dont quite understand the first part saying: Paste this into the General Declarations section of your form?s module The parts i dont understand is what is the general declaration section and the...

Sorry if this is not in the right place. My problem is filtering a combobox. I have a combobox on a form bound to QryCustomers, when the form opens the focus is on the combobox and when i start typing the combo drops down showing the list of all the customers. What i want is a filter as you...

Firstly let me apologize for starting another thread on this subject. I have been reading the posts on here about stock control and got myself into a right muddle and need a bit of help. Firstly i have started a database and am now at the point of stock control, I created tables for the...

Excellent rainlover works a treat Thanks Gareth

I hope this is in the right place. I have a form(frmCustomerSelect) with a listbox which gets its data from a query(QryCustomerSelect). The query gets its data from a customer\supplier table, the table has two checkbox columns , one for customer and one for supplier. When i enter an...

Ok i had a look at that page (very useful) but im not sure at the types of query. I have attached a copy of an error i get if i use the form to update the query and also a picture of the query.

I have a query which contains four tables. There is a form based on the query and when i try to add a new record it will not allow me. i have a line of code (docmd.gotorecord,,acnewrec) on the afterupdate of the last textbox but it just takes me back to the beginning of the current record. Any...

Here it is i cant work out what im doing wrong.

I have a single form based on a query with three tables that is used to add records to these tables but when i get to the end of the form and try to move to the next record i get an error (document attached) that seems to point towards a relationship problem but i stumped with it. Any help...

Ok ive found out why i have the problem but not sure how to fix it. The problem is with the code in the forms before update event. If i remove that then the other code does as it should so i guess im back to the original question. How can i have a text box only accept Y,N or any other letter...

Thanks Rural guy tried that aswell still no joy. This is really annoying now as the help you have given me should be working but im obviously doing something completely wrong and i can quite see where. Maybe if i explain myself better you gurus may be able to see something i cant. This main...

Thanks for the help This doesnt seem to be working, would it make a difference if the control before it was a yes/no checkbox. Thanks Gareth

Thanks for the help both. Ruralguy i tried it in the afterupdate event and it would still update the record regardless of what i typed into the text box. Nigel your code works if i enter it into the forms beforeupdate event. i have changed the delivery address form to a subform but am now...

Hope someone can help with this. I have the following code in the beforeupdate event of a text box on a form Dim response As Integer Select Case Me.SupplierAdd1() Case "y" MsgBox "New record added", vbOKOnly Case "n" response = MsgBox("Are you sure you want to delete this record", vbYesNo)...

Ok consider me told off. This order form is a two part form which instead of a combo box for the supplier code i was using a kind of search form(FrmPOSupplierSelect) to select a supplier based on the first few characters and then copy this across to the order form and then they can go straight...

Sorry bob but ive been a complete idiot and realised why i couldnt get it working like you have. I was using the FrmPOSupplierSelect form to select the supplier and copy it to the FrmPurchaseOrder2 form and the SupplierCode was not regestering on the new record which is why i was getting that...

Tried that and it made no difference (I only added that so i could get the supplier name to show) Ok i see your point with the combo`s , That was what i was using the FrmsupplierSelect form for to search the suppliers based on a few letters. im basically just using the sales app from work (not...

Here is what im working on (please dont tell me off for changing the combo`s)