Search results

next problem ok the first part works great but the next part is doing my head in. when i have entered the customer id and the next form(form4) has opened with the cursor in the part no text box how do i get the part no`s i enter into the text box display in the subform.

thanks absolutely perfect thanks very much for all your help.

almost that is almost what i want. basically when i type in the name and it automatically opens the form is better than i wanted but the subform needs to be hidden and when i type in part of the name and press ENTER then the subform will unhide and display the names matching the part name i...

I have added a copy of my database in the hope that someone can answer my questions. 1. On form4 i can get it to open from form3 displaying the info for the customer and go straight to the part no text box (that part is fine), What i need is for the subform to be empty and when i enter a part...

Studentos you have just helped me solve a problem thats been bugging me for weeks but can you go one step further if you can and tell me if you only enter part of the number can you get a subform to open displaying all matching numbers. For instance if you are looking for 12345 and you enter...

This is Probably the stupidest question but in what instance would you use a report rather than a form?

nearly there Ok problem solved sort of. I can now open up the second form with all the details i need but i only want to do this if the full customer id is entered. If someone enters the first few letters of a customer id can i have a subform appear on Form1 with the customers matching that...

Ok here goes I need some help with getting my form(form 2) to autofill from another form(form 1). Now i dont want to use combo boxes or command buttons as i only want to use the keyboard and not the mouse. Basically when a customer phones up to get prices they tell me there account code( this...

the subform is used for a price check when customers phone up to check prices. I just need to enter a bunch of part nos and have them displayed in the subform along with there prices and a total price at the end. thanks

Part no links the two forms.

i have posted a copy of the forms that i need some help with. basically the part no text box at the bottom is used for entering part numbers from the product details table and displaying them in the subform, but i can only get the subform to display either every part no or can only get it to...

This is either a very stupid idea or very hard idea. Really all i need to do is type in a number that is in a product table and get it to show the record on a subform but i need to be able to enter and have multiple items show up in the subform. Product table part no discription cost Main...

This is a price check form so it doesnt need to be saved it just needs to display the part no info and quantities with price If i enter a part no into a text box(PN1) on the main form it enters the data into a textbox(PN2) on a subform. Im using a continuous form on the subform and the...

What about if your copying the two bits of data from 1 record to the next

I have a database for orders but the problem is i have different types of orders like back orders,sales orders,purchase orders. my question is do i need seperate tables for each type or would it be easier putting them all in one table with an extra column saying which type of order it is.

sorted i found that the problem was that the second form was designed from a table. i re-did the form and it now warks perfectly. thanks very much for all your help.

ok sorry to take up all your time. the first part is there. the message box now tells me what i have typed into the textboxes but it still wont open the second form with the data. when you run the debug the yellow line is over the me.supplier_name = args(0) line i have checked all the textbox...

so where you have typed string1, string2 etc i need to type me.(info to pass to next form) ok the diagnostic msgbox say the args are [me.supplier name;me.ref;] but even with the changes i still get the runtime error

here goes ok the two pieces of information ar the supplier name and a ref which i want to pas onto the other form. the code i have in the afterupdate of the ref textbox is :- Private Sub Ref_AfterUpdate() Dim strWhere As String Dim strform As String Dim strarguments As String strform =...

Sorry for being aa pain but i entered the code and i now get a runtime error telling me i cant assign a value to the supplier name.